MySQL Import Script

[Mike]

Hi all,

I've got a huge mysql database file that I need to import into another database. It's too big to import through phpmyadmin, so does anyone know a php script or something that can do it?

Thanks,
Mike

[Chris]

a php script would have the same limitations, namely php's max file size limit. Remember, phpmyadmin IS a php script.

The easiest way to do this is to upload it via FTP then import it via the shell.

However, if you do not have shell access, perhaps try breaking the file into small chunks.

[Xander]

The easiest way is to do as Chris said above, however if you don't have shell access try BigDump (http://www.ozerov.de/bigdump.php), does large imports in a staged manner.

[AmbulanceBlues]

Could you remotely connect to your database and replicate it with a php script run on your new host? Record for record, or small chunks at a time?

[Mike]

I think it looks like Shell could be the option, cheers guys.