homepage Welcome to WebmasterWorld Guest from 54.198.42.105
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
I can't restore my joomla database
lecter




msg:4032094
 8:43 am on Nov 26, 2009 (gmt 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!

 

whoisgregg




msg:4045168
 12:06 am on Dec 18, 2009 (gmt 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?

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved