If you run a sql-driven website, you may need to upload a large sql file for execution. And chances are that the administration section enforces a file size limit (like phpmyadmin). Pasting the sql content will be also tiresome. Here is the simplest, bullet-proof way to solve the problem.
- Get the bigdump file from here.
- Edit the php file – change the database setting essentially.
- Upload the sql to your server with your favorite ftp program. It seems to support gzip.
- Run bigdump.php.
And that’s it! Very convenient. Credit to http://www.ozerov.de/bigdump.php
[tags] sql, bigdump, mysql, database[/tags]