I am moving all my websites to one server, and I was wondering if it is okay to leave out the information_schema because I have multiple different ones from different servers.
A:
if you dump your tables structure and data (export in phpmyadmin) you can easylie import that data in an other mysqldb. and u don't need the information_shema for it.
be sure to have same encoding and mysql versions.
helle
2010-10-27 10:06:50
+1
A:
information_schema is a virtual db used for querying database metadata.
You don't have to move it, the data there are generated automatically from your other databases.
Piskvor
2010-10-27 10:07:30
A:
Yes. In fact, the mysqldump tool often used for backing up databases ignores INFORMATION_SCHEMA. When you restore the database on the new server, MySQL will update the INFORMATION_SCHEMA on that server.
Rob Sobers
2010-10-27 10:08:04