Hi,

I had binlogs from the mysql 4 which I was trying to get into mysql3 using
the mysqlbinlog utility. Obviously I got the version mismatch error i.e

ERROR 1064 at line 8: You have an error in your SQL syntax near 'DEFAULT
ROW_FORMAT=DEFAULT' at line 1

My question, is there anywaay to make the logs compatible?

Any /pointer to where to look will be appreicated


Thanks

--NZ

First, I don't know if there is a way to make binlogs compatible,
it seems SQL syntax incompatibility.
You should look for single errors and correct it by hand or,
if your target is to import data from a MySQL 4.x server to a MySQL 3.x server you could import the binlogs into a MySQL 4.x server,
dump the databases and reimport them in the MySQL 3.x server.
Finally my hint is to upgrade the DB server to 5.x version,
It's much much better and it is not hard to do the migration.

Aloha!

Claudio Nanni


-----Messaggio originale-----
Da: Naufal Sheikh [mailto:naufalzamir@gmail.com]
Inviato: lunedì 24 marzo 2008 17.53
A: mysql@lists.mysql.com
Oggetto: version mimatch

Hi,

I had binlogs from the mysql 4 which I was trying to get into mysql3 using
the mysqlbinlog utility. Obviously I got the version mismatch error i.e

ERROR 1064 at line 8: You have an error in your SQL syntax near 'DEFAULT
ROW_FORMAT=DEFAULT' at line 1

My question, is there anywaay to make the logs compatible?

Any /pointer to where to look will be appreicated


Thanks

--NZ


"Questo messaggio ed ogni suo allegato sono confidenziali e possono essere riservati o, comunque, protetti dall'essere diffusi. Se il ricevente non é il destinatario diretto del presente messaggio, é pregato di contattare l'originario mittente e di cancellare questo messaggio ed ogni suo allegato dal sistema di posta. Se il ricevente non é il destinatario diretto del presente messaggio, sono vietati l'uso, la riproduzione e la stampa di questo messaggio e di ogni suo allegato, nonché ladiffusione del loro contenuto a qualsiasi altro soggetto"
*****
"This message and any attachment are confidential and may be privileged or otherwise protected from disclosure. If you are not the intended recipient,please contact the sender and delete this message and any attachment from your system. If you are not the intended recipient you must not use, copy or print this message or attachment or disclose the contents to any other person."