Backup and Restore MySQL Databases from HMG

[jayadevu]

Dear All,

Is it possible thru HMG ? any samples ?

I know it is possible thru passing parameters to MysqlDump.exe, but can we do it thru HMG without Mysqldump.exe.

Warm regards,

Jayadev

[Rathinagiri]

By backup if you mean to create .sql file, yes, we can do manually. I had done that. For detailed code please see MySQL to SQLite converter.

[Rathinagiri]

This is the link for MySQL2SQLite Converter.

http://hmgforum.com/viewtopic.php?f=15&t=857

The idea is, you can use 'SHOW CREATE TABLE' command to find out the exact create statement for all the tables.

Then use select * for all the tables, and create a text file with insert command for each row in the table.

Save the file with extension .sql.

[jayadevu]

Dear Rathinagiri,

Many thanks for your reply. Helpful as always.

What libraries have to be linked to compile this application ?

Warm regards,

Jayadev

[Rathinagiri]

No extra library is required to be included. You can just compile it.

In this converter I have created a sql text file for the whole mysql database selected.