Mysql
02-20-2006, 10:27 PM
#1
Banned
Thread Starter
Join Date: Dec 2005
Location: Tampa
Posts: 196
Likes: 0
Received 0 Likes
on
0 Posts
Mysql I keep getting this error when trying to transfer a database from my home server to my 1and1 server...
What does this mean?
Home SERVER:
Server Type WINNT
Web Server Apache v2.0.54
PHP 5.0.4
PHP Max Post Size 8.00 MB
PHP Maximum Upload Size 2.00 MB
MySQL Version 4.1.14-nt-log
MySQL Packet Size 1,023.0 KB
New SERVER:
Server Type Linux
Web Server Apache v1.3.33 (cgi)
PHP 4.4.2
PHP Max Post Size 8.00 MB
PHP Maximum Upload Size 20.00 MB
PHP Memory Limit 40.00 MB
MySQL Version 4.0.25-standard-log
MySQL Packet Size 10.00 MB
Do you know how I can fix this error?
Code:
MySQL said: Documentation #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 'DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci' at line
What does this mean?
Home SERVER:
Server Type WINNT
Web Server Apache v2.0.54
PHP 5.0.4
PHP Max Post Size 8.00 MB
PHP Maximum Upload Size 2.00 MB
MySQL Version 4.1.14-nt-log
MySQL Packet Size 1,023.0 KB
New SERVER:
Server Type Linux
Web Server Apache v1.3.33 (cgi)
PHP 4.4.2
PHP Max Post Size 8.00 MB
PHP Maximum Upload Size 20.00 MB
PHP Memory Limit 40.00 MB
MySQL Version 4.0.25-standard-log
MySQL Packet Size 10.00 MB
Do you know how I can fix this error?
02-21-2006, 07:29 AM
#2
TECH Senior Member
iTrader: (7)
Join Date: Jan 2002
Location: Katy, TX
Posts: 12,754
Likes: 0
Received 0 Likes
on
0 Posts
your destination server might not support that character set or collation (sorting) order. If you don't explicitly need that collation order, and/or language set, omit that line and try it again. The server will use the configured default.
02-21-2006, 05:57 PM
#3
Banned
Thread Starter
Join Date: Dec 2005
Location: Tampa
Posts: 196
Likes: 0
Received 0 Likes
on
0 Posts
Originally Posted by Brains
your destination server might not support that character set or collation (sorting) order. If you don't explicitly need that collation order, and/or language set, omit that line and try it again. The server will use the configured default.
I am finally done with my site after all the help you have given me! Thanks sooooooooo much!
Oh here is my site www.lsxgto.net
02-21-2006, 09:11 PM
#5
TECH Senior Member
iTrader: (10)
Join Date: Nov 2001
Location: Gainesville, Denton TX
Posts: 8,766
Likes: 0
Received 0 Likes
on
0 Posts
speaking of that
why in the hell would it redirect to oralb?
do you have to set something else up so it doesnt have to have the www?
never did understand that.
why in the hell would it redirect to oralb?
do you have to set something else up so it doesnt have to have the www?
never did understand that.
02-21-2006, 09:28 PM
#6
Banned
Thread Starter
Join Date: Dec 2005
Location: Tampa
Posts: 196
Likes: 0
Received 0 Likes
on
0 Posts
Originally Posted by Brandon
speaking of that
why in the hell would it redirect to oralb?
do you have to set something else up so it doesnt have to have the www?
never did understand that.
why in the hell would it redirect to oralb?
do you have to set something else up so it doesnt have to have the www?
never did understand that.
WTF!
Why is it redirecting to oral b?
Thats weird...
The site is: http://lsxgto.net/
EDIT:
I think it may have redirected like that b/c i used bold on the url... and it was inside the url tags...