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
To migrate from your old system to the new one export all the databases and tables EXCEPT mysql and Information_Schema. Then import them into the new system.
The mysql database is the "system" database and you shouldn't even be seeing it if the system was set up correctly. You certainly shouldn't have, or require, write access to it. Ditto for the schema, which is a virtual table and doesn't actually exist.
Chances are those tables are not writable for you.
You will most likely just want to copy over the data tables relating to your use and then update your web config files with the new username given to you by the host and the password for the database that you will change so it's not the default one given by them.