Hello

I have just exported a table as .sql from one server and imported it
into mysql on another server.

The table seems to have loaded OK but I see the following

--------------------
Error
SQL query:

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

MySqL said
#1064
-----------------------

Any ideas please?!

Cheers

Geoff

On Sun, 25 Dec 2011 08:12:55 +0000, Geoff <geoff (AT) invalid (DOT) invalid>
wrote:

Statements of the form
/*!nnnnn statement */
are staements which not every version can handle.

1064 indicates a parse error.

What method did you use to export the sql file?
What method did you use to import the sql file?
What is the MySQL version of the source?
(service and client)
What is the MySQL version of the target?
(service and client)
Best regards,
--
( Kees Nuyt
)
c[_]

On Sun, 25 Dec 2011 12:46:26 +0100, Kees Nuyt <k.nuyt (AT) nospam (DOT) demon.nl>
wrote:

Kees

these statements are in the exported sql file;

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

the error message when importing the sql file has

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

note the 2 extra @ symbols in the error message?

The mysql server for the export is version 5.1.56 - that for the
import is v5.0.18-max.

I clicked on the help icon netx to the 1064 but this gave no info.
I exported as an sql file. Looking at the options I see

1. Output

character set utf-8

2. Format specific options

display comments

3. Object creation options

the following are selected;

add create procedure / funtion / event statement
create table options / if not exist / auto_increment

For the import I select SQL and next to this it states "this format
has no options".

Any of the above help?!

Cheers

Geoff