Export DB using MySQL Console error in syntax

Question

I'm using WAMP Server in a local PC. I'm trying to export a big database using MySQL console but its just not working. I always get a syntax error 1064

The queries I tried:

mysqldump -u USER -p DATABASE > backup.sql;
mysqldump -u USER -pPASSWORD DATABASE > backup.sql;

(of course I'm replacing USER, PASSWORD and DATABASE with real values)

I also tried some more similar queries but I'm getting the same syntax error every time.

Please help!!!!!

Mchl · Accepted Answer · 2010-11-12 17:05:01Z

2

You should type this in your command prompt not in MySQL console.

mysqldump is an application not MySQL command.

answered Nov 12, 2010 at 17:05

Mchl

62.4k9 gold badges121 silver badges121 bronze badges

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

Collectives™ on Stack Overflow

Export DB using MySQL Console error in syntax

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related