Hot answers tagged

72

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


32

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 ...


10

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 ...


9

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 ...


9

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.


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? ...


8

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 ...


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 ...


7

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 ...


7

That seems a Plesk server, when using Plesk there is no root for Mysql, but the administrator of Mysql called admin, so this command should work on Plesk as I tried it before: mysql_upgrade -uadmin -p`cat /etc/psa/.psa.shadow`


7

A quick search results in the correct chapter of the manual with: mysql> FLUSH TABLES WITH READ LOCK; mysql> SET GLOBAL read_only = ON;


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).


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 ...


5

Rsyslog can group multiline log message into a single message via imfile module, however only following three read modes are supported: Line based (default) - each line is a new message. Paragraph - there is a blank line between log messages. Indented - new log messages start at the beginning of a line. If a line starts with a space it is part of the log ...


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


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 ...


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

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.


3

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 ...


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

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

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 table....


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 ...


3

Same issue! The solution for me came from http://www.freebsd.org/cgi/query-pr.cgi?pr=180624 Briefly: the error is misleading! run mysql_upgrade -u root -p with the DB on-line and provide the root password.


3

As this has been explained by @M Somerville, there is a conflict between the packages previously installed by the dotdeb repository that you're using, and the official debian repository that now contains a more recent version of mysql 5.5. What you need to do is remove mysql 5.5 completely and then install the latest version available in your repositories. ...


3

errno 28 means ENOSPC, that is, "No space left on device". There's several lookup commands available for such standardized errors, one is called simply errno: % errno 28 ENOSPC 28 No space left on device Another is called perror: % perror 28 OS error code 28: No space left on device


2

Yes, 51k entries were added, only 986 are in there now. so there were roughly 50k entries which were added to the cache, but are no longer there, 9k of them because it ran out of memory in the cache and the rest because inserts/updates invalidated cache entries. Com_select is a parameter which is useful to know when trying to decide if you are getting ...


2

You can compare the output of 'show variables' on both mysql servers. 5.5 is going to have new features and different defaults than a 5.1 setup. I would recommend putting each set of settings into a file, comparing with diff, and looking for smoking gun(s).


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

MySQL.com does have .dmg files. What do you mean by "requires lots of manual linking"? If the .dmg file on MySQL.com doesn't work for you, then your best bet is probably to compile it yourself. Compiling stuff from source might sound daunting, but it's really not that hard. Here's a pretty thorough tutorial that should help you out.



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