Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is it okay to move my MySQL database without moving Information_Schema?

Tags:

mysql

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.

like image 547
Strawberry Avatar asked Oct 27 '10 09:10

Strawberry


1 Answers

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.

like image 103
Piskvor left the building Avatar answered Oct 20 '22 01:10

Piskvor left the building