OriginalSunny Posted February 12, 2006 Share Posted February 12, 2006 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!!! Quote Link to comment https://forums.phpfreaks.com/topic/3397-backing-up-database/ Share on other sites More sharing options...
fenway Posted February 12, 2006 Share Posted February 12, 2006 You can't run that as a MySQL statement -- you have to run this on the command-line. Quote Link to comment https://forums.phpfreaks.com/topic/3397-backing-up-database/#findComment-11626 Share on other sites More sharing options...
OriginalSunny Posted February 12, 2006 Author Share Posted February 12, 2006 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. Quote Link to comment https://forums.phpfreaks.com/topic/3397-backing-up-database/#findComment-11628 Share on other sites More sharing options...
fenway Posted February 13, 2006 Share Posted February 13, 2006 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. Quote Link to comment https://forums.phpfreaks.com/topic/3397-backing-up-database/#findComment-11631 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.