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!!! 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. 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. 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. Link to comment https://forums.phpfreaks.com/topic/3397-backing-up-database/#findComment-11631 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.