Hi,

I'm new to MySQL - having used Microsoft SQL Server for about 10 years.

I'm not terribly impressed. All of my attempts to move data from mssql
to mysql through the data migration tool failed - and this was on a
really simple schema with six tables. I finally had to write a Java
program to do the job right.

Now I'm having problems with mysqldump. I took what I thought was a
backup of my database and tried to load it into another server to make
sure it worked - it didn't. When I execute the script, I get an error
saying the syntax of "UNLOCK TABLES" is wrong. Then I get about a dozen
more syntax errors, all of which look like they are being caused by
column data containing quote marks which was not properly escaped by
the dump application. (I did specify both "--quote-names" and
"--allow-keywords" on the command line, but it's hard for me to imagine
that any program purporting to dump data in a generic fashion would not
automatically account for strings with quotes in them).

Finally, the script ends with a series of errors that say, "MySQL
server has gone away".

Can anyone offer any guidance? I read the manual page for mysqldump
several times.

Thanks,
Frank

I am also seeing that the blue dots in the editor, which I think are
supposed to indicate the beginnings of statements, are often not at the
beginnings of statements.

I strongly suspect that the editor in the query browser is not parsing
lines over a certain length correctly - I'm running the Windows version
of the query browser.