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

Related posts about mysql

Related posts about phpmyadmin