tom_b Posted March 2, 2007 Share Posted March 2, 2007 Hi!! I've been doing some research and, as usual, came up with LOTS of information!! I'm wondering if there is a preferred way of backing up data in a Mysql database. I don't have a ton of data, but I'd like to be able to do a backup maybe once a week. I'd apprectate any suggestions!!!!! Thanks, Tom Quote Link to comment Share on other sites More sharing options...
effigy Posted March 2, 2007 Share Posted March 2, 2007 I'm still studying this myself. It depends on the table types you're using. If you cannot shutdown MySQL, you'll need to use a "hot" backup program (the one for InnoDB is not free), or mysqldump, which can be used with InnoDB tables when performed in a single transaction. If you can, I would recommend making a text backup via mysqldump, and a binary backup. To my knowledge, these programs do not backup your functions and procedures. Quote Link to comment Share on other sites More sharing options...
tom_b Posted March 2, 2007 Author Share Posted March 2, 2007 Hi!! And thanks for the info, it's a good start. At this point all I really care about is the data, so maybe I can use one of your suggestions, thanks again!! Tom Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.