database import error

5 posts by 2 authors in: Forums > CMS Builder
Last Post: February 9, 2009   (RSS)

By esupport - February 6, 2009

hi sir

I tried to import the database from development server. got erro message. in phpmyAdmin

#1064 - 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 'CREATE TABLE `cms__accesslist` ( `num` int(10) unsigned NOT NULL auto_' at line 1


-JH
-Jax H.

Re: [JH] database import error

By Dave - February 6, 2009

Hi JH,

Are both your dev and production database servers using the same version of MySQL?

You may need to make sure everything is exported as UTF8 and that if your mySQL is newer that it exports in a mode that is compatible with older versions.
Dave Edis - Senior Developer
interactivetools.com

Re: [Dave] database import error

By esupport - February 6, 2009

hi dave

I send a email for you.

please kindly check it.

Thanks!

-JH
-Jax H.

Re: [JH] database import error

By Dave - February 9, 2009

Hi JH,

I got your email that you got this working. Let me know if you run into any other problems.

Also, if there was any "trick" that made it work feel free to share. I hadn't figured out what the problem was myself, yet.
Dave Edis - Senior Developer
interactivetools.com