This week's giveaway is in the EJB and other Java EE Technologies forum.
We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line!
See this thread for details.
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 EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "dumping whole database" Watch "dumping whole database" New topic

dumping whole database

Isaac Ferguson
Ranch Hand

Joined: Jun 22, 2012
Posts: 321

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?

Ulf Dittmer

Joined: Mar 22, 2005
Posts: 39542
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 - updated with new look and Ping home screen widget
I agree. Here's the link:
subject: dumping whole database
Similar Threads
Prepares Statement : No ResultSet was produced
simple mysql questoion
problem with Database Configuration Script
What is the easiest way to dump a Table into text file?
Uploading a text file to a blob in MySql, then downloading that file to local file system