surefire Posted June 12, 2003 Share Posted June 12, 2003 It's a VERY good practice to backup your mysql database often. How often depends on how important your data is. On my job posting site, I'd hate to have to tell a member that their resume is gone. So I backup daily. Directions. 1- Cpanel 2- phpMyAdmin 3- Click on your database (not the tables, the actual database link above your tables) 4- in the main window, click Export 5- Choose 'Structure and Data', 'Save as File' and any other features you want 6- submit, choose the location to download and store the textfile on your computer Repeat as often as you like. Having good security measures in place is good, but there's nothing like having a solid backup of your database in case all h*ll breaks loose. Also, from experience I can tell you that the biggest threat comes from within. Backup your database before testing out that new script you wrote. I once zapped a precious table of data with one of my own scripts. And if you don't have a backup and something goes wrong, your only chance at salvation is to ask the Help Desk if they can rescue you, but you need to ask immediately. And ask nicely. Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.