Web Hosting Talk







View Full Version : MySql Help


Mooecow
09-26-2004, 09:11 PM
ERROR 1064 at line 1: 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 '®Ü/¬q
Ƶ' at line 2


Any clue what could be causing this error? Im trying to restore a customers database via ssh ( which ive done be4 ) and i get that error:bawling:

Any ideas on what is going wrong?

probonic
09-26-2004, 09:28 PM
Have you looked at the actual SQL file you are restoring to see if there is any corruption in there?

It looks like there has either been corruption of the file, or it doesn't like the contents of a BLOB or similar data item in there...

Mooecow
09-26-2004, 09:34 PM
DROP TABLE IF EXISTS allywar;
CREATE TABLE allywar (
id int(11) NOT NULL auto_increment,
union1 int(11) NOT NULL default '0',
union2 int(11) NOT NULL default '0',
type varchar(5) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

^ That is the 1st few lines of the sql dump. I finally was able to open the file, its huge. I cant see anything wrong with line 2 :-\