aspose file tools*
The moose likes JDBC and the fly likes dumping whole database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "dumping whole database" Watch "dumping whole database" New topic
Author

dumping whole database

Isaac Ferguson
Ranch Hand

Joined: Jun 22, 2012
Posts: 418
Hi

how could I dump a whole database using SQL. I need make a backup I am using DBVisualizer but I am not being able to do it the I prefer do it by hand

I am using "mysql -u test -p test -h svdapp221 fsp > backupname.sql" and "mysqldump -u test -p test -h svdapp221 fsp > backupname.sql" and another queries like that but I always get the same error




Any idea, please?

Regards
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 42913
    
  68
It looks like you're doing this inside ode of DBVisualizer - you need to do this on the command line, because "mysqldump" is an executable, not a SQL statement. Consult the MySQL documentation, it talks at length about how to use mysqldump.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: dumping whole database