SQL Dump?

[00Davo]

Does Xataface have a command to make .sql dump backups? I've been trying a few different methods, but an integrated solution would really be more effective here. Basically just an action (like, say, -action=sql_dump) which dumps the entire database as a valid .sql file.

[shannah]

There isn't currently an SQL Dump action in Xataface. You could implement it yourself. There are 2 strategies I can think of:
1. Use exec() to call mysqldump on the command line.
2. Build the SQL manually .

You may want to dig through the source of PHPMyAdmin and see if there is anything you can borrow for dumping.

-Steve

[00Davo]

There isn't currently an SQL Dump action in Xataface. You could implement it yourself. There are 2 strategies I can think of:
1. Use exec() to call mysqldump on the command line.

Trouble with this method is that XAMPP doesn't seem to have a mysqldump command. Hmm.

2. Build the SQL manually .

Trouble with this method is that I'm too lazy to do it.

You may want to dig through the source of PHPMyAdmin and see if there is anything you can borrow for dumping.

This is a good idea. I'll tear apart PHPMyAdmin this afternoon.

Thanks again.

[strast]

00Davo said...
Trouble with this method is that XAMPP doesn't seem to have a mysqldump command.

Should be there..

Code: Select all

C:\xampp\mysql\bin>dir mysql*.exe

07/06/2007  06:24 AM         2,039,808 mysql.exe
07/06/2007  06:24 AM         1,990,656 mysqladmin.exe
07/06/2007  06:24 AM         2,052,096 mysqlbinlog.exe
07/06/2007  06:24 AM         1,986,560 mysqlcheck.exe
07/06/2007  06:24 AM         8,454,144 mysqld-debug.exe
07/06/2007  06:14 AM         5,730,304 mysqld-nt.exe
07/06/2007  06:24 AM         5,730,304 mysqld.exe
07/06/2007  06:24 AM         2,035,712 mysqldump.exe
07/06/2007  06:24 AM         1,982,464 mysqlimport.exe
07/06/2007  06:24 AM         1,998,848 mysqlmanager.exe
07/06/2007  06:24 AM         1,982,464 mysqlshow.exe
07/06/2007  06:24 AM         2,101,248 mysqltest.exe
07/06/2007  06:24 AM         2,285,568 mysql_client_test.exe
07/06/2007  06:24 AM         1,544,192 mysql_upgrade.exe
              14 File(s)     41,914,368 bytes