![]() ![]() First off though, I need to stress that I am in no way a database expert, rather I am just a humble application developer who has built up a business building custom business applications that just happen to have a database for the back-end. I just thought, having completed most of what I set out to accomplish, that I would share the results of that effort with everyone else out there who needs something like this. So I set out to make a bulletproof, fully managed, backup class that I could use in my. Then you have an irate client on your hands, telling you that you have the programming skills of a twit, who couldn't even make a backup system that worked. I tried, but it would always stuff up, especially when it is the client trying to do a back up with no one else around to recover the process for them. Sadly, I have never had much success with this. The obvious answer to this would be to use Process.Start("mysqldump", filename), and hey presto, you have a full backup. When it comes to backing up, they just want to press a button that says Back-up and everything is taken care of. Unfortunately, in my experience, 99% of my clients do not even know what a relational database is they just want a computer program that can do their invoices and manage their stock with pretty graphs to look at. There are applications that do this for you, obviously, such as SqlDump, mysqlhotcopy etc., but these require some knowledge of MySQLl and relational databases in general. Unfortunately, unlike Access, SqlLite etc., it is not really a case of just copying a file and renaming it, you really have to get down and dirty and basically recreate the SQL that creates all tables and inserts all data back into tables from scratch. #TRANSDATA DATABASE HOW TO#One of the most frequent questions on forums is how to back up MySql databases directly from a. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |