homepage Welcome to WebmasterWorld Guest from 54.163.139.36
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
Forum Library, Charter, Moderators: coopster & jatar k

PHP Server Side Scripting Forum

    
db backup, a good code for mysql dump
whatson

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 4491727 posted 1:07 am on Sep 6, 2012 (gmt 0)

I want to have an easy link in my admin area, where I can just click on database backup and download my database locally. Is there some simple mysql query that can do this?

 

brotherhood of LAN

WebmasterWorld Administrator brotherhood_of_lan us a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month



 
Msg#: 4491727 posted 1:44 am on Sep 6, 2012 (gmt 0)

No script would suit all requirements, especially for very large databases. You'd want to be careful about how the data dump affects any live websites or services.

At its simplest, 2 steps
Step 1. [dev.mysql.com...]
Step 2. [hypexr.org...]

There are windows programs for SCP also, it's a very fast way to shift data between places.

incrediBILL

WebmasterWorld Administrator incredibill us a WebmasterWorld Top Contributor of All Time 5+ Year Member Top Contributors Of The Month



 
Msg#: 4491727 posted 7:07 am on Sep 6, 2012 (gmt 0)

You can backup and restore MySQL from the command line or using PHPMyAdmin

$ mysqldump --opt -u [uname] -p[pass] [dbname] > [backupfile.sql]

$ mysql -u [uname] -p[pass] [db_to_restore] < [backupfile.sql]

Additionally, if you're on a control panel like Plesk or cPanel, they typically include PHPMyAdmin by default so you can use that. They also provide some site backup facilities as well but I'm not sure if the end user can do this or just the admin as I own the server so I have full control.

I prefer the command line script options because then you can set up cron jobs to do it daily and download it locally via an FTP program with a scheduler like CuteFTP. My databases are automatically downloaded nightly to my local computer so in the event of disaster I've only got a few customers missing from the copy of the database. Use a rolling backup, 7 days should be enough, with weekly or monthly baselines to avoid real disaster as once a file gets really mangled or hacked you're backing up bad data. I've seen people using weekly rollover backups without baselines not find out their database was really messed up until it had overwritten all 7 previous copies of the file. They had to resort to their last full site backup a couple of months old, it wasn't pretty.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved