Biz and Internet Stuff

Upload a big chunk of sql file to remote server – a sweat free way

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.

  1. Get the bigdump file from here.
  2. Edit the php file – change the database setting essentially.
  3. Upload the sql to your server with your favorite ftp program. It seems to support gzip.
  4. Run bigdump.php.

And that’s it! Very convenient. Credit to http://www.ozerov.de/bigdump.php

 

[tags] sql, bigdump, mysql, database[/tags]

Leave a reply


*