SQL Syntax Errors...

[tucklis]

Hi,

After many attempts at trying to get SSH to work I have reverted back to dbtools (www.dbtools.com.br (http://www.dbtools.com.br/)) as my host says that in essence it's doing exactly the same thing except it has a GUI.

The problem is that dbtools keeps coming up with "you have an error in your sql syntax, would you still like to continue?".

Here are some samples of the errors:

You have an error in your SQL syntax near '---- Dumping data for table 'access'------ Table structure for table 'adminlog'-' at line 1
You have an error in your SQL syntax near '---- Dumping data for table 'adminlog'--INSERT INTO adminlog VALUES (1,1,1047075' at line 1
You have an error in your SQL syntax near '---- Table structure for table 'adminutil'--CREATE TABLE adminutil ( title varc' at line 1
You have an error in your SQL syntax near '---- Dumping data for table 'adminutil'--INSERT INTO adminutil VALUES ('ids','')' at line 1
You have an error in your SQL syntax near '---- Table structure for table 'announcement'--CREATE TABLE announcement ( anno' at line 1
You have an error in your SQL syntax near '---- Dumping data for table
Table 'soccerfan.forum' doesn't exist
Table 'soccerfan.forum' doesn't exist

I have 3 questions:

1) Does anyone know what these errors actually mean?
2) If I were to upload it via SSH would it still error check, and would I still get these errors?
3) What the heck should I do next?

Thanks for your help.

Regs,
kez

[eva2000]

try using ssh and mysqldump explained here http://www.sitepoint.com/article/678