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 users and permissions.
- 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.
- Should I drop the table on server (b) and import my original?
- Should I just copy the users table?
- Do I need to worry about the information_schema table? should I copy this over too?
thanks