MySQL Embedded Backup and Restore

[easd1327]

Hi,

How can I Backup and Restore a MySQL Embedded with the mysql and mysqldump?

Thanks a lot

sorry my bad English

Samantha

[mdaems]

Try to use the SELECT ..... INTO OUTFILE syntax. (Using TZConnection.ExecuteDirect or TZQuery.ExecSQL, not ZQuery.open.)

Using mysqldump or mysql will not work, as far as I know.
I believe these tools don't use libmysql.dll. If I'm wrong and they do use the shared library, you can try to use these tools with the dll replaced by the embedded server dll.

Mark

[easd1327]

Try to use the SELECT ..... INTO OUTFILE syntax. (Using TZConnection.ExecuteDirect or TZQuery.ExecSQL, not ZQuery.open.)

Thanks a lot, practical and usefull

[aigartua]

Hola Samanta checa el siguiente post, espero te ayude:

http://zeos.firmos.at/viewtopic.php?t=2329