homepage Welcome to WebmasterWorld Guest from 23.22.252.150
register, login, search, subscribe, help, library, PubCon, announcements, recent posts, open posts,
Subscribe and Support WebmasterWorld
Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library : Charter : Moderators: physics & whoisgregg

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.
Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About
WebmasterWorld ® and PubCon ® are a Registered Trademarks of Pubcon Inc.
© Pubcon Inc. 1996-2012 all rights reserved