How should I copy the "mysql" database to my new server using PHPMyAdmin
- by undefined
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