MiniSqldump (New MySQL Backup/restore util.)

[extras]

I made a new MySQL backup/restore tool, an alternative to mysqldump, named "MiniSQLdump"

It's a samll shellscript offering both Web interface and command line capability.
So, you can use it in crontab or in other scripts, and aslo backup/restore via browser.
And it's faste/more efficient than many other common methods.

No editing is required. Just upload/copy the file and set permission to 700 (using WebFTP/site tool...)
in a well protected directory, and it's ready to go.

It keeps table creation SQL command and data in separate files with 'Qucik(default' method.
You can specify to put all files in a zip, tar, tgz (tar.gz), tbz2 (tar.bz2) format, too.

Moreover, it doesn't convert the character code (mysqldump does it, normally), so it's more efficient.
I've made a companion restore script for 'mysqldump' and a few other scripts,
but this one is the easiest and fastest.

Also, it can restore from 'mysqldump' generated backup, as well as create backup using 'mysqldump'
When you want to import .sql (or .dmp created by PowWeb's daily backup), use 'mysqldump' method.

I've done lots of testing, and it is working well, so far, but it is still under testing.
So, plese keep a copy of backup with 'mysqldump', just in case.
(PowWeb makes daily backup using mysqldump, too)

Here is the code.
http://check-these.info/tools/minisqldump_cgi.txt

For more info:
http://check-these.info/MiniSqlDump.html

Simple MySQL query tool with interface to MiniSqlDump:
http://check-these.info/MiniSqlAdmin.html

[mitchind]

Adding this link for people with SQL files that use single INSERT statements (one per record) instead of the multiple INSERT method. This can cause the error that "max queries (72,000) have been exceeded".

extras has built a cgi program that will convert those individual statements into a bulk INSERT that imports the data using LOAD DATA LOCAL INFILE.

http://check-these.info/tools/restore_cgi.txt