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 Link to comment https://forums.phpfreaks.com/topic/40788-solved-mysql-backup/ 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. Link to comment https://forums.phpfreaks.com/topic/40788-solved-mysql-backup/#findComment-197480 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 Link to comment https://forums.phpfreaks.com/topic/40788-solved-mysql-backup/#findComment-197511 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.