File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes copy of existing 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 "copy of existing database" Watch "copy of existing database" New topic

copy of existing database

Santhosh Puttu

Joined: Jun 08, 2010
Posts: 27
Hello, All,
Good Evening .

What is the command to create a copy of an existing database in mysql?
I need to manipulate my code using duplicate of my database.

I tried using mysql dump command to put duplicate copy on my desktop as:

Cd /usr/local/mysql/bin
./mysqldump studentdb > ~/Desktop/studentdb.sql

But unsuccessful.

Help me Professionals.
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3749

mysqldump is one such command. Perhaps you should try one of the GUI tools to assist.

[OCA 8 Book] [Blog]
I agree. Here's the link:
subject: copy of existing database
jQuery in Action, 3rd edition