Tel: 0113 2170419
www.littlefishwebdesign.com
Importing large files into phpMyAdmin
Wednesday, March 28, 2007
Okay, so I moved to a Hostgator server earlier this week. It's gone fairly smoothly, and as I have unlimited addon domains, it means I can host all my sites on the one package. There are reasons not to do this if you're heavily into using one of your websites to promote the next which I'll cover in a different post.
In the meantime, one site had a MySQL dump file of 57,571 KB which is quite large. It's bigger than the allowed upload limit for phpMyAdmin and the thought of manually pasting it filled me with dread - it would take several hours, perhaps too much caffeine and definitely not much fun.
A quick Google search threw up 'bigdump' - a single PHP script that you input your database variables into, create a folder in your hosting account - 'dump' for example, and upload the large mySQL file in question to it.
The database to import to must exist, and if the dump file doesn't contain 'drop' commands, you must manually do this first in phpMyAdmin.
For more details, see this post I found called "How to Import Large MySQL Data Files" with a much more detailed explanation. And if you don't know what I'm talking about...lucky you!
Labels: hosting, programming
