Hello:-) A few days ago, I saw a lot of questions (and solutions) to backing up Mysql Databases and tables. One question kind of struck me and I did come up with a little python script if anyone is interested that is able to backup and/or restore the entire Mysql set of Databases. This is of course dependent up the creation of Tables of type MyIsam and as far as creating the necessary direcories in the target area, it would be required that you had root access. As far as recovering, it does prompt if you want to restore mysql and midgard since those are pretty much system databases? Also, in order to restore, the user would have to have create/alter access:-) At this point in time, the script is fairly basic, tho I do plan to add a few options to it in the near future. (selective backup/restore, logging capabilities, etc). Also, there is no Gui for it right now, but it runs great via crontab for nightly mysql backups:-) (Just wish I would have put this together before I lost most of my data:-( I went thru a bit of a hassle getting most of it back, (am still rebuilding the kmysql forms). But by use of the init_db script, I at least could get mysql back online, and then the rest was (is) just a matter of data entry. At any rate, thought I would post this just in case someone would be interested:-) -- cya l8r Leon D. McClatchey mailto:[EMAIL PROTECTED] ICQ:#112341159 Consultants are mystical people who ask a company for a number and then give it back to them. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
