0

mysqldump -u root -p pass**** coke_pos > testbc.sql i tried this command to generate back-up of my database but i got an error about, eroor in my syntax

i have mysql 5.5.11 community server and i am using mysql workbench 5.2, i am using windows 7

please help

i will appreciate in any help

thanks

Edited by ZER09: n/a

2
Contributors
5
Replies
6
Views
6 Years
Discussion Span
Last Post by smantscheff
0

What is the exact error message? Also, omit the spaces between parameter flags and the parameters: mysqldump -uroot -ppass**** coke_pos > testbc.sql

0

What is the exact error message? Also, omit the spaces between parameter flags and the parameters: mysqldump -uroot -ppass**** coke_pos > testbc.sql

ERROR 1064 (4200): 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 -u root -p emachine coke_pos > testbc.sql' at line 1

this is the error i encounter

0

mysqldump is an OS command, i.e. an executable program, not a mysql statement. You cannot enter it in mysql but only on the command line.

0

i cant understand can you explain more. sorry for that actually i am new in sql thanks.

0

Find out what a command line program is. Google is your friend.
Press the "windows" button, enter "cmd" into the search field and press enter. You'll get a command line window.
Now enter your mysqldump code. You'll probably have to set the system path, too.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.