Computer Help Forum

Go Back   vBulletin and Computer Help Forum > Website Support and Management > Website Administration

Website Administration Website management support for FTP access, SSH access, control panels, SEO, advertising programs and other help for web site administrators.

Reply
 
Thread Tools Display Modes
Old 01-25-2007   #41
AnthonyCea
Senior Member
 
AnthonyCea's Avatar
 
Join Date: Jul 2005
Posts: 189
That makes sense, the vB backup in ACP tells you at the end of the file that it is complete, as long as it is not large there should be no problems with it.
AnthonyCea is offline   Reply With Quote
Old 01-27-2007   #42
julia
Senior Member
 
Join Date: Dec 2006
Posts: 128
Ok, Antony just don't get mad at me.
I noticed when i was doing the back ups, that my today's file is smaller than for example from 2 days ago. I don't delete posts, i write them though, so that's strange to me.
julia is offline   Reply With Quote
Old 01-29-2007   #43
AnthonyCea
Senior Member
 
AnthonyCea's Avatar
 
Join Date: Jul 2005
Posts: 189
Could be something odd but just keep making new backups frequently!

Like I said, get a host that will make them for you automatically, this is a common service with many hosts today!
AnthonyCea is offline   Reply With Quote
Old 02-01-2007   #44
julia
Senior Member
 
Join Date: Dec 2006
Posts: 128
Are you backing up your FTP folders as well? If yes how frequently?
julia is offline   Reply With Quote
Old 02-02-2007   #45
julia
Senior Member
 
Join Date: Dec 2006
Posts: 128
One more question when you save as, do you choose SQL file?
julia is offline   Reply With Quote
Old 02-03-2007   #46
AnthonyCea
Senior Member
 
AnthonyCea's Avatar
 
Join Date: Jul 2005
Posts: 189
I just check the "all" box and save the database to hard drive, that's it!
AnthonyCea is offline   Reply With Quote
Old 01-20-2012   #47
Big Dan
Senior Member
 
Big Dan's Avatar
 
Join Date: Jul 2006
Location: New York
Posts: 259
Send a message via AIM to Big Dan Send a message via MSN to Big Dan Send a message via Yahoo to Big Dan
Nearly 6 years later this thread is still my go to guide for backup and restoring databases.
__________________
DJ Chat | Big Dan
Big Dan is offline   Reply With Quote
Old 01-21-2012   #48
Greg
Administrator
 
Greg's Avatar
 
Join Date: Feb 2003
Location: Florida
Posts: 5,193
Cool!
__________________
Computers and Accessories Computer Manuals Riderinfo Connect for Bikers
Ad Revenue - Sell link space on your website and profit.
Greg is offline   Reply With Quote
Old 01-24-2012   #49
bigH2O
Acceptably Annoying
 
bigH2O's Avatar
 
Join Date: Jun 2005
Location: North GA mountains
Posts: 1,411
I still use a shell script that I wrote years ago that dumps a db file and deletes db backups that are X days old. Completely automated, and if anything goes wrong with last night's db backup I can at worst fall back to a few days ago.

My db backup script is ran as a cron under root at the server level, so there's no need for userid or pass to get it to function properly, although variables could easily be added (or hard coded) for userid and pass if the script can't be run at the root level. It's never failed me in over five years now. The basic command I use for the db backup is basically "mysqldump --opt -Q $dbname > $actfile", of course there are variables there for the database name and file you want to save it to. My script iterates through the entire list of dbs on the server and backs them all up and then transfers them to offsite storage. It goes a bit further in scanning all web sites on the server and copying/replacing any new or changed files to offsite storage as well. It doesn't copy the entire website/board... only the new files within them, so it's extremely fast.

I have customized this script for at least a dozen customers who come to me for total server maintenance, and it's never failed once. I generally don't charge anything for the backup script, but the customers (who are usually resellers) charge big bucks to their clients for the nightly data backups and data integrity that it ensures. I don't charge for it because if something *does* go wrong, I don't want to be left with my dick swinging in the wind, but nothing has ever gone wrong to date.

I don't mind sharing a simple version of this script if anybody's interested in analyzing it and modifying it for their purposes. I don't want to post it on a public forum though, so PM me with an email address and I'll send it to you privately.
__________________
With the speed of technology advancement today, anybody who says "it can't be done" is usually interrupted by somebody who is already doing it.
bigH2O is offline   Reply With Quote
Reply

Tags
backup, cron, database, forum, mysql, mysqladmin, vbulletin

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 07:40 PM.



vBulletin 3.8.7 Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright vB and Computer Help Forum

EZ software products copyright Greg Lynch 2006-2013