How should I copy the "mysql" database to my new server using PHPMyAdmin
Posted
by undefined
on Server Fault
See other posts from Server Fault
or by undefined
Published on 2010-04-01T12:50:16Z
Indexed on
2010/04/01
12:53 UTC
Read the original article
Hit count: 473
My new webhosting company has set up a MySQL database for me and it has the tables MySQL and Information_schema already there. I want to copy my existing database from another server (a) to the new one (b). I assume I need to overwrite the 'mysql' database on server (b) with the one from my existing server (a) or atleast copy over the permissions.
1) What information does the mysql database hold? users and permissions I can see, does it have the login info for phpMyAdmin? I dont want to overwrite that obviously. 2) Should I drop the table on server (b) and import my original? 3) Should I just copy the users table? 4) Do I need to worry about the information_schema table? should I copy this over too?
thanks
© Server Fault or respective owner