Page 1 of 1
Backup and Restore MySQL Databases from HMG
Posted: Fri Jun 22, 2012 8:27 am
by 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
Re: Backup and Restore MySQL Databases from HMG
Posted: Fri Jun 22, 2012 9:00 am
by 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.
Re: Backup and Restore MySQL Databases from HMG
Posted: Fri Jun 22, 2012 9:01 am
by 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.
Re: Backup and Restore MySQL Databases from HMG
Posted: Fri Jun 22, 2012 10:31 am
by jayadevu
Dear Rathinagiri,
Many thanks for your reply. Helpful as always.
What libraries have to be linked to compile this application ?
Warm regards,
Jayadev
Re: Backup and Restore MySQL Databases from HMG
Posted: Fri Jun 22, 2012 10:36 am
by 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.