Two Laptop Bag
The moose likes JDBC and Relational Databases 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 REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "dumping whole database" Watch "dumping whole database" New topic

dumping whole database

Isaac Ferguson
Ranch Hand

Joined: Jun 22, 2012
Posts: 651

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: 42959
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:
subject: dumping whole database
It's not a secret anymore!