Backup and restore a local/remote database
Posted on 2005-03-24
I would like to backup and restore a MySQL database form my delphi program.
I have tried a few components, one which was recommended on About.com but I can't work out how to backup a database with it...it doesn't seem to have anything to do with MySQL.
What is the quickest, easiest and more secure way to backup a database?
I would like to give the user a button to backup either the complete database or just certain tables and also restore certain tables, or the full database.
I would also like to give the option to compress the database for faster download (Maybe upload if possible to upload a compressed sql dump)
Hope someone can help me out!