How to dump one database to another database using mysql?

Question

i have tried the following query but i gate with an error.

mysql> mysqldump test |mysql test1;
ERROR 1064 (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 test |mysql test1' at line 1
mysql> mysqldump test |mysql test1
-> ;
ERROR 1064 (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 test |mysql test1' at line 1
mysql>

@adiintern not without console. You should do it in the command promp of your OS not inside of the mysql console — Jens
– Jens, Commented Oct 6, 2016 at 11:40

Suraj · Accepted Answer · 2016-10-06 11:55:19Z

1

You have to use these commands on command prompt.

Syntax :

mysqldump --opt -u [uname] -p[pass] [dbname] > [backupfile.sql]

i.e.

C:\>mysqldump --all-databases > dump.sql

If you want to create dump for any specific database then you have to mention that database name in the command.

C:\>mysqldump --databases yourdb > dump.sql

To import the database you have to use following command,

C:\>mysql -p -u[user] [database] < dump.sql

edited Oct 6, 2016 at 11:55

answered Oct 6, 2016 at 11:43

Suraj

3,1954 gold badges32 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Internship Over a year ago

will it copy along with tables created in old database or it wont@Pirate

Suraj Over a year ago

yeah, because you have mentionned all-databases. If you want to create only particular db then you have to give that db name only.

Internship Over a year ago

Error occurs: mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect

Suraj Over a year ago

did you give credentials? mysqldump -u [user] database > dump.sql

Suraj Over a year ago

try mysqldump -u[username] -p[pass] [yourdb] > dump.sql

|

Collectives™ on Stack Overflow

How to dump one database to another database using mysql?

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related