Jump to content

Archived

This topic is now archived and is closed to further replies.

OriginalSunny

backing up database

Recommended Posts

Hi,
i am having trouble backing up my database. I am using the following command:

[i]mysqldump -u jonny -p jon dvd > dvd.sql;[/i]

and it is comming up with the following error:

[i]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 ... [/i]

Someone please help!!!

Share this post


Link to post
Share on other sites
You can't run that as a MySQL statement -- you have to run this on the command-line.

Share this post


Link to post
Share on other sites
How do i go about doing that then? Can i save it using a statement? is there another way to save the database and tables??

Sorry but i am fairly new to mysql.

Share this post


Link to post
Share on other sites
Not cleanly -- you can use SELECT INTO OUTFILE for a table dump, but you'd still have to deal the table SHOW CREATE calls too. That's why mysqldump is such a niftly little script. You should have no trouble running it, and I'm sure PHPMyAdmin has sort sort of interface to it.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.