Mysql – How to ‘attach’ a MySQL database

MySQL

I have been given a MySQL database in the form of ibdata1, ib_logfile0, ib_logfile1, and a collection of .myi, .myd, and .frm files.

How would I go about 'attaching' this db to my local MySQL 5.1 installation? I found one advice to create a new directory in MySQL's data directory, but I can't find any such directory.

Best Answer

To find the 'data directory', which ended up under ApplicationData\AllUsers, I looked in 'my.ini' under the MySQL directory in Program Files. Then it was as simple (on the face of it) to copy all the .myi, .myd, and .frm files to a new directory under the data directory. Voila, instant DB.

Related Solutions

Mysql – Fixing “Can’t find file: … (errno: 13)” on thesql

Are you running something like selinux or some other similar package? I'd suggest disabling that (or modifying the security policies) to see if something there is preventing MySQL from being able to access the files.

[edit] If so, check syslog to see if selinux is blocking mysql from doing anything. If it is SELinux, I'm told this may disable it so that you might test this theory.

/usr/sbin/setenforce Permissive

Mysql – thesql with innodb_file_per_table – cannot see any .ibd files

File-per-table only applies to tables created after the option was enabled -- existing tables aren't copied out to separate files. You'll need to create new tables, copy the records across, then drop the old table and rename the new one to the old name to get all of your tables into their own files.

Best Answer

Related Solutions

Mysql – Fixing “Can’t find file: … (errno: 13)” on thesql

Mysql – thesql with innodb_file_per_table – cannot see any .ibd files

Related Topic