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: [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

Re: [Dave] database import error

By esupport - February 9, 2009

hi Dave

I think the problem is from the .txt.

When I export the detabase and open it with .txt. all content is mess and come together.

but when I open the database with Dreamweaver.
The database content is list in each line. That is clear.

Our language is mutil-language. If we import .txt. The database will show the error and tell the character can not be read.
One way we need to do is make the database code in each line and clear.
than import again.
The problem has been solved.

Hope it could help for everyone. specially mutil-language country's friend.

ps. Sorry for my poor english and have a nice day.


-JH
-Jax H.