File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
dumping whole database
Joined: Jun 22, 2012
Aug 21, 2013 03:00:29
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
-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
LDUMP - 0 row(s), 0.000 secs] [Error Code: 1064, SQL State: 42000] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqldump' at line 1 Code: 1064 SQL State: 42000 --- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqldump' at line 1 ... 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec [0 successful, 0 warnings, 1 errors]
Any idea, please?
Joined: Mar 22, 2005
Aug 21, 2013 03:30:17
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
What is the easiest way to dump a Table into text file?
simple mysql questoion
problem with Database Configuration Script
Uploading a text file to a blob in MySql, then downloading that file to local file system
Prepares Statement : No ResultSet was produced
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015