CODEWITHSUNDEEP
mysql
Strawberry
Strawberry

Reputation: 67938

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.

Upvotes: 6

Views: 3262

Answers (3)

Rob Sobers
Rob Sobers

Reputation: 21155

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.

Upvotes: 0

Piskvor left the building
Piskvor left the building

Reputation: 92792

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.

Upvotes: 4

helle
helle

Reputation: 11660

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.

Upvotes: 0

Related Questions