syntax error on database
-
-
- damo
- Elite Rocketeer
- Posts: 2142
- Thanks: 0
-
hallo, need some quick help.
i'm moving a site from one host to another. when i try and upload the database i get a syntax error
this has happened to me before and it got fixed relatively easy but i've forgotten how; i think it's to do with version of sql from/to
anyone know where i should be looking or have any advice?
cheers - Last Edit: 18 years 2 weeks ago by damo.
- www.c3p0.se - sweden
-
-
-
- Dan L
- Elite Rocketeer
- Posts: 1453
- Thanks: 0
-
Yeah my Friday evening was wasted because of something that may have been the same issue...was it a 1064 error? Complaining about the charset?
The database export I had was from MySQL 5 and the version that it was being imported to was 4.0. My JSAS localhost SQL Server imported it just fine, and that's running 4.1.
You could try:
- exporting the database using 4.0 compat mode (assuming you are running V4.0 of course)
- strip out the references to the charset that the import complains about (latin1 in my case)
- see if the target host has the option for a newer version of MySQL, I know GoDaddy have this
All this assumes that the error was the same of course...it may be something completely different!
Good luck chap. - Toolbox Digital | Dribbble | Forrst
-
-
-
- damo
- Elite Rocketeer
- Posts: 2142
- Thanks: 0
-
almost dan
it's 1064 but
#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 '---------------------------------------------------- -- Server version 3.23.58 ' at line 1
sorted. just needed to remove the
- Last Edit: 18 years 2 weeks ago by damo.
- www.c3p0.se - sweden
-
Time to create page: 0.064 seconds