开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜