import or appending with ibdata1, no mysqldump

[Adam S]

We have a 160GB innodb db including lots of indexes. We loaded the data in-house on a windows server and sent the data out on a TB drive.

The thing is, we just dropped our xampp directory onto the drive.

So they will have the data directory with the ibdata1 file and all the frm files.

It is being loaded onto a BSD server that already has mysql up and running.

We didn't do a mysqldump of the file, so it's just the ibdata1 file.

Is there a way to extract the db out of that file?

I also read somewhere that mysqldump doesn't work very well with very large InnoDB databases. Are there any alternatives?

Is it possible to just swap the ibdata file with the one on the server? Or perhaps rename it and add it to innodb_data_file_path?

Or use mysqldump with the ibdata1 file?

Help please.



Edited 1 time(s). Last edit at 03/27/2009 05:19PM by Adam S.