Tag Info

Hot answers tagged

30

Contact Rackspace support.. That's what they're there for. Do everything they suggest. If that doesn't work, try Dan's suggestion of data recovery software. Use this as an opportunity for growth and learning. Always ensure that all your servers are backed up, and test the backups regularly. There's no point in having a backup service if you never ...


24

I think that it needs username and password mysql_upgrade -u root -p If I don't pass them I get your error


8

There are times when MySQL 5.1 may outperform MySQL 5.5 under certain circumstances. Percona performed a bake-off among multiple releases of MySQL MySQL 4.1 MySQL 5.0 MySQL 5.1 (with built-in InnoDB) MySQL 5.1 with InnoDB-plugin MySQL 5.5 MySQL 5.6 All tests were performed with MySQL unconfigured (In other words, no my.cnf was made). The results? ...


7

Yes, you are correct that if you don't specify --ssl-ca then the client does not check the server certificate at all. Since it works without that option the most likely reason for the failure is that the client doesn't trust the server certificate. If you are using self-signed client and server certificates then the ca.cert file should include both these ...


7

It seems to me that your .sql file actually contains the text <br /> <b>Fatal error</b>: Maximum execution time of 300 seconds exceeded in <b, which is obviously not valid sql. You have possibly exported your database with some tool like phpMyAdmin, which took longer than 300s to create the export which was cut short at that point in ...


7

It's a safe move. Shutdown the mysql dameon and copy the database dir to another disk (it doesn't matter storage topology), then you should modify mysql config, restart mysql daemon and go live. This is a raw backup / migration and it's the safest way to get a snapshot of your database. For your security you can make a data dump for your databases using ...


6

Innodb is the default storage engine, and it is loaded by default. I would consider this a flaw in MySQL Workbench. You can read more about the --innodb (and --skip-innodb) option here: http://dev.mysql.com/doc/refman/5.5/en/innodb-parameters.html#option_mysqld_innodb Notice that if you disable innodb, MySQL won't even start unless you specify a different ...


6

I'd suggest you use mysql 5.5 from IUS instead of webtatic. With it, you can also get yum-plugin-replace, which will let you do yum replace mysql --replace-with=mysql55 and it will figure out the dependencies and install the new package. This would avoid removing php53-mysql (which you need if you have any PHP code that interacts with MySQL).


4

This question is a bit old now, but in case other people come across this page (like I did), here is what got me working: In my case the answer was apparmor. The solution: edit the file /etc/apparmor.d/usr.sbin.mysqld Add the following lines: /path/to/new/data/ r, /path/to/new/data/** rwk, /path/to/new/logs/ r, /path/to/new/logs/ rw, Then restart ...


4

If you're using SELinux (Fedora, SUSE, some Ubuntu), it is probably the problem. You need to change your security context for mySQL with something like: chcon -Rv --type=mysqld_db_t /my/new/data/dir or if you're using AppArmor (Ubuntu), you'll need to update your /etc/apparmor.d/usr.sbin.mysql


3

Use whichever version is latest on your distribution of choice. I'd suggest you use Ubuntu 10.04 LTS, and the current version of that is.. MySQL 5.1.41-3ubuntu12.7 That means that you'll get easy to install binaries sudo apt-get install mysql-server , and support for them from the ubuntu community, because things will happen as expected. Mixing and ...


3

I opted to try this out on my MySQL server to see what the problem was. It appears that you need to create the table in MySQL (with engine=csv specified) so that the table will appropriately be added to MySQL and it will keep track of the table field metadata. In my testing, I was unable to make MySQL learn of the csv file without first using "create ...


3

The configuration file use the dash (-) The variable name use the underscore (_) http://dev.mysql.com/doc/refman/5.1/en/server-options.html#option_mysqld_open-files-limit Another question I have, in my config file I have open_files_limit = 500, but whenever I do a show variables the open_files_limit is 7048. Why would this be? It sounds like ...


3

Is the web server the same physical server than the database server? bind-address should be an address that is assigned to your server -- if ifconfig lists the address, then you can use it for MySQL. You can't just blindly pick some IP and put that as bind-address, no sir. EDIT: It seems you understand bind-address completely wrong. 1) Put your database ...


3

I just encountered these precise symptoms when upgrading from 5.5 to 5.6, and it turned out to be a service reachability issue. Even though the cli MySQL client could connect to my local DB instance with only a -u and -p provided, I also needed to specify -h 127.0.0.1 for mysql_upgrade as it was attempting a socket file connection and failing miserably in ...


3

ERROR 1231 (42000): Variable 'general_log_file' can't be set to the value of '/var/lib/msyql/ubuntu.log' What's going on? The simple answer is this file doesn't exist. You type too fast. There is a typo in the file name, it should be /var/lib/mysql/ubuntu.log.


3

I don't think key_buffer_size is deprecated, mysql use key_buffer_size in the documentation on their website from the earliest available right up to the latest version. There is also a bug report that requests deprecated variables emit warnings at startup which suggests that it's key_buffer that is deprecated. I personally would go with the documentation as ...


3

When you connect to MySQL, just run SELECT SUBSTR(variable_value,1, LOCATE(' ',variable_value) - 1) DBVersion FROM information_schema.global_variables WHERE variable_name='version_comment'; You should get this when you connect to MySQL mysql> SELECT SUBSTR(variable_value,1, -> LOCATE(' ',variable_value) - 1) DBVersion -> FROM ...


2

Run the following command mysqladmin variables | grep version_comment | awk '{print $2}'


2

Do you have SELinux enabled? It's possible that the MySQL packages are not built to play nice with SELinux (not uncommon for 3rd party packages) and that it is blocking access to creating the PID file. A quick and dirty test would be to set your SELinux context to Permissive (or Disabled) # setenforce permissive If that is not the case then have a ...


2

Use whatever version is in your distro's package repo. Seriously. Unless you have very specific needs that require you to run the absolute newest stable, just use your distribution's packaged MySQL.


2

It's not really that simple to do a DNS Failover for a database. There are many reasons, but here are a few that might cause problems. A lot of applications use connection pooled libraries, so they might create persistent connections to the database, so the assumption that a DNS failover might actually cause all application traffic (reads and writes) to ...


2

To use one way ssl, you should try with: mysql -u <user> -p --ssl=1 --ssl-ca=ca.cert --ssl-verify-server-cert The --ssl-cert and --ssl-key on the mysql client are used for 2 way SSL. This means certificate based authentication. The subject of the client certificate should be the username.


2

This is a syntax error in the .sql file. There should be a line there with "<b>Fatal error: Maximum execution time of 300 seconds exceeded in This error looks alot like a PHP error to me. During database export/dump, php stopped after 300 seconds, and wrote out the error to its output -> your file. You should fix php.ini, to allow longer execution ...


2

There is no way to run multiple MySQL installations using yum on a single instance. But, it's very easy to install and uninstall current and future versions via yum or rpm. It seems you are going about this in a very wrong way. First do this on a staging machine. Document the steps and time taken in detail. Do this multiple times if you have to improving ...


2

cPanel should be fine with MySQL 5.6 but you would need to confirm on your dev/test/staging environment where you're going to trial the upgrade process first =) cPanel support suggests doing the MySQL upgrade their way: http://forums.cpanel.net/f5/mysql-upgradation-211421.html#post871392 You would need to be using a yum installed version of MySQL under ...


2

Sounds like an issue with MySQL Workbench. MySQL 5.5 has a default storage engine of InnoDB. In fact, the option default_storage_engine is predefined as follows: MySQL 5.5.4 and prior, MyISAM MySQL 5.5.8 and after, InnoDB There is another option called storage-engine, which was deprecated as for MySQL 5.5.3. Keep in mind that MySQL 5.5.8 was the very ...


2

CentOS 5 and 6 have a good repo available for the lastest mysql RPM's without needing to compile it. http://rpms.famillecollet.com/ enjoy.


2

Your mysql package installed into /opt/mysql. You'll need to run the programs from there. You probably want to add the mysql bin directory to your path. Alternatively, does testing or unstable have mysql 5.5?


2

In ordet to simplify the promotion of the Slave to a Master, I have a suggestion to keep the Slave closer sync'd to the Master. You should use the tool mk-slave-prefetch. Here is the beauty of this tool: On a slave, it will read the relay logs, look for all queries that have a WHERE clause, convert it to a SELECT and execute it. That way, the caches for ...



Only top voted, non community-wiki answers of a minimum length are eligible