coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: Justttt on June 28, 2006, 03:33:38 PM

Title: moving server error
Post by: Justttt on June 28, 2006, 03:33:38 PM
hey i am moving servers so i have exported my coppermine database , when i import it to my new database i get this error

You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1 ' at line 18


and on that line is AUTO_INCREMENT=2 ;

any help please? ?
Title: Re: moving server error
Post by: Nibbler on June 28, 2006, 03:43:00 PM
When you export, select compatibility options appropriate for the database type and version you will be importing the dump into.
Title: Re: moving server error
Post by: Justttt on June 28, 2006, 10:40:24 PM
Yup Thanks Nibbler Your A Star , Problem Solved