Export Database As Sql Statments

[Simon_66]

I have SQLyog Enterprise v5.31 and I cannot export the entire database.

I used to be able to, (with a previous version I think) but now it only exports 1 table at a time.

The DB is hosted remotely (MySQL v4) and I am connected by SQLyogTunnel.

The setup for DB export is below:

Also when I export separate tables I regularly get an error saying “incorrect table name” but there is “scribble” in the Exporting_table description field. See below:

I can export some tables OK but not others, and I can't find a common problem in the 'error' tables.

Does anyone have any ideas or similar experiences?

Simon66

[peterlaursen]

Really looks like some character set 'mess-up'

First: we need to be sure if it woked OM with a previsous version. Which version do you think worked? Do you still have the installer?

Second: It is important here to know if it is MySQL version 4.0 or 4.1. Execute “select version()” to find out! Wiht tell the exact version!

Third: Let us see the returns of ” show variables like '%character%' “

I think you mean SQLyog 5.13.

(if not I would like to know from where you got 5.31 🙂 )

Please try latest 5.17 RC too!

[Simon_66]

Ah ha—My secret version 5.31

Thanks for your reply Peter, I tried your last suggestion first and updated to latest version – 5.71 (sorry, 5.17)

and everything works perfectly now.

Thanks again

Simon Radford

[peterlaursen]

OK ..

I do not recall every detail here and am uncertain why 5.17 works and 5.13 not.

But probably there was some issue with the character set for the connection that was not correctly implemented for the export tool!

BTW: I apologize for all my typo's. Really looked bad last time! 😮

[Author]

Posts