SQL Dump?

Archived from the Xataface Users forum.

00Davo — Tue Feb 09, 2010 3:26 am

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 — Tue Feb 09, 2010 8:30 am

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 — Tue Feb 09, 2010 2:58 pm

shannah wrote: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.

shannah wrote:2. Build the SQL manually .

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

shannah wrote: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 — Sat Feb 13, 2010 11:05 pm

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`