You can create a batch file like this or if you want it to be in a web
interface much like phpmyadmin, but with your backup scheme you can use
the load data outfile command. This page from the mysql manual describes
both the infile and outfile methods:
http://www.mysql.com/doc/en/LOAD_DATA.html. Th
Have you considered using the console-tool, "mysqldump " ?
You could write a quick script ... say
mysqldump -u adminuser -p adminpass --all-databases > backup.sql
tar -zcvf backup.tar.gz backup.sql
mv backup.sql /somepath/backup.sql
if you're on Winders, a batch file:
mysqldump -u adminuser -