7

I have just upgraded (uninstall, restart, download new installer and installed) MySQL Server for Windows on my 2008 R2 box.

In the upgrade procedure webpage it says:

To use mysql_upgrade, make sure that the server is running, and then invoke it like this:

shell> mysql_upgrade [options]

But I can't figure that bit out... I'm probably having a mental blank but if I run mysql_upgrade; through the mysql command line client, I get an error 1064: you have an error in your sql syntax etc...

What am I doing wrong?

Improve this question

1 Answer 1

Reset to default
11

The mysql_upgrade command is system command, rather than a MySQL command.

Execute "mysql_upgrade" from the Command Prompt (cmd.exe). If it is not in your path, you can most likely find it at the following location: C:\Program Files\MySQL\MySQL Server 5.6\bin

Or otherwise in the "bin" subdirectory of your MySQL server installation path.

You will likely want to pass it the root username and request it to prompt for your password as follows:

mysql_upgrade -u root -p

Improve this answer
7
  • That worked. But I got a lot (I'm assuming all Wordpress database tables) of errors: "websitedatabasename.wp_posts doesn't exist"
    – Reece
    Sep 13, 2013 at 4:04
  • Sounds possibly like InnoDB failed to start. Can you pastebin your MySQL error log file?
    – Trent Lloyd
    Sep 13, 2013 at 4:06
  • pastebin.com/h8EwCZrn
    – Reece
    Sep 13, 2013 at 4:18
  • as a bit of background... the old MySQL version (5.1) kept having issues starting, so I upgraded to the most recent windows release. I've just copied all of the database folders for each website from the old \DATA\ folder into the new \DATA\ folder. I haven't got any dumps or exports.
    – Reece
    Sep 13, 2013 at 4:25
  • Wait! I got it working. I disabled the server, backed up the existing ibdata file, MySQL folder, ib_logfile(s) and replaced them with the files of the same name from the old 5.1 install. Started the server and now all the websites are working again.
    – Reece
    Sep 13, 2013 at 4:48

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .