Forums

I'm trying to make a backup from my db, but when I try to make the dump I get this error

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 -u mediexcelhp -p -h mysql.server --databases 'mediexcelhp$basedatosme' at line 1

This is the syntaxthat I'm using

mysqldump -u mediexcelhp -p -h mysql.server --databases 'mediexcelhp$basedatosmediexcelpr' > /home/mediexcel2/Sep.sql;

are you doing that from a bash console? (you should be) also, you don't need the semicolon at the end

That was my error :) I was don't it from mysql, Thanks :)