Page 1 of 1
MySQL Embedded Backup and Restore
Posted: 16.01.2009, 10:56
by easd1327
Hi,
How can I Backup and Restore a MySQL Embedded with the mysql and mysqldump?
Thanks a lot
sorry my bad English
Samantha
Posted: 16.01.2009, 11:29
by 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
Posted: 16.01.2009, 23:50
by easd1327
mdaems wrote:Try to use the SELECT ..... INTO OUTFILE syntax. (Using TZConnection.ExecuteDirect or TZQuery.ExecSQL, not ZQuery.open.)
Thanks a lot, practical and usefull
Espero te sirvan estos procedimientos
Posted: 18.04.2009, 20:06
by aigartua
Hola Samanta checa el siguiente post, espero te ayude:
http://zeos.firmos.at/viewtopic.php?t=2329