database import error
5 posts by 2 authors in: Forums > CMS Builder
Last Post: February 9, 2009 (RSS)
By esupport - February 6, 2009
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
Re: [JH] database import error
By Dave - February 6, 2009
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.
interactivetools.com
Re: [Dave] database import error
By esupport - February 6, 2009
I send a email for you.
please kindly check it.
Thanks!
-JH
Re: [JH] database import error
By Dave - February 9, 2009
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.
interactivetools.com
Re: [Dave] database import error
By esupport - February 9, 2009
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