Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

I can't restore my joomla database

8:43 am on Nov 26, 2009 (gmt 0)

New User

10+ Year Member

joined:Oct 10, 2005
votes: 0

I can't restore my joomla database(backup by mysqldump without complete-insert, quote-names options):

C:\Documents and Settings\Administrator>mysql -u root -p jojo < h:\DatabaseBAK\joomla091112.out
Enter password: ************
ERROR 1064 at line 175: 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 'option varchar(50) NOT NULL default '',
ordering int(11) NOT

mysql version: 4.0.20a-nt

BTW, according to test, database dump with "--complete-insert --quote-names"options can be restored!

12:06 am on Dec 18, 2009 (gmt 0)

Senior Member from US 

WebmasterWorld Senior Member whoisgregg is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Dec 9, 2003
votes: 0

Sorry for the late response, lecter!

If you're still having trouble with this issue, could you perhaps post lines 170-175 for us to take a look at?