Is it okay to move my MySQL database without moving Information_Schema?
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.
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.
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.
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.
精彩评论