SQL Dump?

A place for users and developers of the Xataface to discuss and receive support.

SQL Dump?

Postby 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.
00Davo
 
Posts: 55
Joined: Sat Jan 02, 2010 9:02 pm

Re: SQL Dump?

Postby 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
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm

Re: SQL Dump?

Postby 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. :lol:
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. :)
00Davo
 
Posts: 55
Joined: Sat Jan 02, 2010 9:02 pm

Re: SQL Dump?

Postby 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

strast
 
Posts: 29
Joined: Thu Feb 05, 2009 6:14 pm


Return to Xataface Users

Who is online

Users browsing this forum: No registered users and 44 guests

Powered by Dataface
© 2005-2007 Steve Hannah All rights reserved