*
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 Murach's Java Servlets and JSP this week in the Servlets 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: 331
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: 41078
    
  43
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.


Ping & DNS - my free Android networking tools app
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: dumping whole database
 
Similar Threads
Uploading a text file to a blob in MySql, then downloading that file to local file system
Prepares Statement : No ResultSet was produced
simple mysql questoion
What is the easiest way to dump a Table into text file?
problem with Database Configuration Script