Moving Mysql DBs and IDs?

I'm moving a Wordpress site on to Linode. I was able to move all of the data from all of the DBs by using mysqldump on the existing site, using rsync to move the data, and the the "mysql source" command to rebuild the databases on Linode.

My question is, how do I move all of the Mysql IDs and passwords? Even though I used the –all-databases option on the mysqldump it does not appear like the IDs/passwords were moved.

Thanks, Len

1 Reply

Users and privileges are stored in the "mysql" database, in particular the "db" and "user" tables. Log in to MySQL as root and try to dump/reload them. Make sure you make backups, because this might break your database if you don't do it properly.

On the other hand, if you're moving from a shared host, you'll probably have to recreate the users manually.

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct