Hi,
I am just opening a new site and I am trying to use my database from my old site so that I do not have to add all the products again. About 600! But I am getting this error when I try and use the sql file that I downloaded from phpmyadmin. My host wont help me with it for some reason so I would really like your help!
ERROR 1064 at line 20: 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 'ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1' at
line
lsh413:~/www$
Just wonding if anyone here has any ideas. The database is about 22mb in size and I am trying to upload it to a unix server and the original was also on a unix server.
Thanks,
Jamie
Sites I Have Built:
Sex Shop Canada (Warning Sex Toy Site)
Greg K posted this at 21:59 — 14th July 2006.
He has: 1,667 posts
Joined: Nov 2003
Check what version of mySQL is on each server. I know I tried to test an export from version 5 of mySQL on an older server and it errored out. Back on a v5 server again it worked fine. Try doing a search and replace on the file, searching for ENGINE=MyISAM DEFAULT CHARDET=latin1 and replace it with either a blank, or just a space. As long as when you set up the databases to begin with you didn't specify anything other than defaults for ENGINE and CHARSET, it should work fine.
-Greg
[This space intentionally left blank]
Cool Geek Supplies: www.ThinkGeek.com
john23 posted this at 08:42 — 15th July 2006.
He has: 6 posts
Joined: Jul 2006
Wow it worked great! Thanks so much!, That saved me hours of work. My host couldn't even help me with that.
Thanks again!
Jamie
Sites I Have Built:
Sex Shop Canada (Warning Sex Toy Site)