|
|||||||
| Shooting The Shit This is where the action is for all webmasters alike. Anything goes, seriously. Come meet and network with your peers, it's a fun way to take a break out of your busy day of posting at other boring forums. |
|
Welcome to the WickedFire - Affiliate Marketing Forum - Internet Marketing Webmaster SEO Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
![]() |
|
|
LinkBack | Thread Tools | Display Modes |
|
|
#1 (permalink) |
|
BuildAndEarn
|
Hey guys... last week my web server crashed, the hard drive failed and backups were corrupted. I lost everything I've done on every website since I made Internet Marketing my Full-Time job.
I want to remind everyone to put their own backup systems in place... don't put it off... you WILL regret it. Posted my story to my blog and hope you can learn from my mistakes instead of your own. My forums now appear dead and if anyone is interested in college basketball, politics or cooking I would be elated for you to come hang out at Bracketball - Powered by vBulletin, Political Fury - Political News & Discussion - Powered by vBulletin or ChefClub.net - Cooking & Recipe Community. For anyone else dealing with tough times: take a breath of fresh air, a short break, keep your head up and get back to kicking ass... things could always be worse.
__________________
BuildAndEarn.com - My Affiliate Blog Phandroid.com - Android Phones Rule AndroidForums.com - Android Forums (duh!) |
|
|
|
|
#3 (permalink) |
|
Seo Services
|
sounds really bad. I thought things were sorted out since its been almost two weeks back that you have told me abt your server crash.
__________________
:: Send FREE text message in US and Canada :: Check out WF's Best Manual submission Service Best Social bookmarking and Article submission service Contact: AIM: abbycutlet Msn: abbycutlet@hotmail.com email: chandrasekhar.g@gmail.com |
|
|
|
|
#4 (permalink) |
|
Senior Member
|
I've had a similar issue in the past. Never thought I would ever have to backup until then. It's worth it if you're in it for the long run. Also, many hosting companies provide backup services for no additional charge. Even on dedicated servers. Good luck man.
|
|
|
|
|
#5 (permalink) |
|
Pointy-Haired Boss
|
Damn man, sorry to hear that. I had something similar happen to me in March of last year, my hard drive just died and they couldn't recover it. All of my local AM work was lost, fortunately not the parts that I kept online. Ever since I've been dumping my complete hard drive with SuperDuper! and I also recently started doing hourly backups with time machine to another external hard drive. Backing it up online will have to wait until I move to my new place and get proper Internet ..
But I didn't really think about backing up my online data, will definitely have to put something in place, something happening to that would cripple my business. So thanks for reminding me. |
|
|
|
|
#8 (permalink) |
|
Banned
|
I had the same thing happen to me with a community of 5,000. I even flew down to Miami to the hosting office to get the hard drive and try to restore it myself. No luck and it was not worth paying a service to restore it all.
Keep your chin up and I hope you are feeling better. |
|
|
|
|
#9 (permalink) | ||
![]() |
Quote:
__________________
Quote:
|
||
|
|
|
|
#10 (permalink) |
|
Senior Member
|
HD failures just plain suck. I lost a drive last month and even though I had backups going but for some reason they weren't fully working as I thought. Even though I didn't lose everything even a day's worth of data loss is a huge waste of time considering how cheap storage is vs. your time. Everything from now on is raid 5 or backed up some how. I don't trust dvd's and now i'm back to looking at DLT tapes.
Another tip, even if you have backups you should really try once in a while restoring the data just to make sure they really work and how to do it. If it's really critical you should have multiple copies as a strategy. Good luck going forward... |
|
|
|
|
#11 (permalink) |
|
borrowed ladder
|
sorry to hear about the data loss - that's my nightmare. a little late now, but maybe useful still (for people with linux servers):
Backups using rsync Easy Automated Snapshot-Style Backups with Rsync |
|
|
|
|
#13 (permalink) |
|
Teh *****
|
I second this. Cant believe how many times fucking host said well this one isnt any good..and this one neither. blah
__________________
my blog bitch If your not nettin over a million a yr then signup with ads4dough or copeac and neverblueads! http://www.justinchelf.com/images/ad...te-network.gif |
|
|
|
|
#14 (permalink) | |
|
Junior Member
|
I know exactly how you feel.
Many years ago while I was writing my thesis for my Masters Degree....hmmm, think B.G. (before Google)....I lost my entire thesis on my hard drive a month out from handing it in. Needless to say, you can you suck in some deep breaths and start again which I did. Plenty of good coffee and some sleepless nights. Just like you said trigatch4 Quote:
|
|
|
|
|
|
#15 (permalink) |
|
Senior Member
|
Never trust your data to another company or hardware component. You really need to take matters into your own hand.
rsync sounds cool, I'll check that out in a minute. Your Eureka post really went into greater detail with the play by play. Anyway, go look into mysqldump. Most linux servers have that, especially if you have cpanel. Anyway, for the future, setup a cronjob on EVERY site that has databases and have it run mysqldump to a backup folder OUTSIDE of your /public_html folder. I have mine running daily on sites that have content changing daily. Other sites have it running weeky. Hell, I even have a cronjob that makes a tarball of my site once a week. I login and download weekly. I store these on my local hard disk and my Seagate external drive (FreeAgent). mysqldump method for DB backups: Code:
/usr/bin/mysqldump -hlocalhost -uUSERNAME -pPASSWORD DBNAME > /home/xxx/backup/DBNAME.`/bin/date +\%Y\%m\%d`.sql tarball backup of site files (not DBs) Code:
tar -cf backup/SITEABREV-`/bin/date +\%m\%d\%y`.tar public_html/ Contents would be all files under your /public_html/ Just remember to login once a week and download. Or else, you'll start using some serious disk space. If you have shell, login under shell and run these commands first to make sure there's no errors. I hope this helps. You guys have helped me a lot, I'm always happy to help where I can. |
|
|
|
|
#16 (permalink) |
|
BuildAndEarn
|
Thanks for everyone's consolations, well wishes and advice.
ScottDaMan: Those scripts look like they backup one site at a time since it is asking for DB name and password. What if you have 100 wordpress sites all with their own DB? I'll definitely talk this over with my host and see if they can help me put this into action... thanks dude.
__________________
BuildAndEarn.com - My Affiliate Blog Phandroid.com - Android Phones Rule AndroidForums.com - Android Forums (duh!) |
|
|
|
|
#17 (permalink) |
|
Senior Member
|
You can use mysqldump to dump all databases:
Code:
mysqldump [options] --all-databases
__________________
Vintage Domain Names: Because yesterdays domains just rank better. QAS: Quick Affiliate Stats. Easy overview of your earnings. |
|
|
|
|
#18 (permalink) |
|
Senior Member
|
trigatch,
Daily automated full backups of your web content and databases is definitely worth the effort to get going, as you've learned. I think it takes a harsh lesson to fully realize the value in it. (luckily for me, it was an employer's data rather than my own!) Anyway, you can backup all databases mysqldump via the --all-databases option. Just make sure you login as the mysql root user so that you have read access to every database. Also, pipe your mysqldump results through gzip to save disk space. Usually can compress at least 70%. As you scale up across multiple servers or are unable to login and manually retrieve your backups off of your production server for a length of time, having automated rsync and mysql replication to another server (from another provider) is well worth the effort. Also consider implementing backup rotations -- e.g. 1 week of dailys, 2 months of weeklies, 1 year of monthlies, or whatever makes sense for you. |
|
|
|
|
#20 (permalink) |
|
Senior Member
|
This would work:
Code:
/usr/bin/mysqldump --all-databases -hlocalhost -uroot -pMYSQLROOTPW | /bin/gzip -9 > /home/USERNAME/backups/XXX_alldb.`/bin/date "+%Y%m%d"`.sql.gz |
|
|
|
|
#21 (permalink) |
|
Success Depends on Focus
|
If you have something a little more complex running, these guys did a really good tutorial and discussion on potential issues.
How to: Move / Copy a live MySQL database (and what not to do) - Programming - SoftwareProjects |
|
|
|
|
#24 (permalink) |
![]() |
Ha! Backups are for weak cowards... (slinks away to copy some files)
::emp::
__________________
http://www.blindapeseo.com/ubot/ubotpromo.jpg That's because all programmers are also ninjas.(but not all ninjas are programmers) - LogicFlux Blind Ape Seo ¦ My WickedFire articles |
|
|
![]() |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| LOST Finally coming back! | PlanetAndrea | Shooting The Shit | 32 | 02-04-2008 11:08 AM |
| BREAKING NEWS: ALL ONLINE DATA LOST AFTER INTERNET CRASH | RexyWendy | Shooting The Shit | 1 | 08-31-2007 12:54 AM |
| Lost A-Team | McLOVIN | Shooting The Shit | 0 | 08-02-2007 05:48 PM |
| How much money you lost Gambling, and the story.. | darkdrift | Shooting The Shit | 21 | 05-20-2007 07:33 PM |
| LOST arbitrage? | Jack Swift | Affiliate Marketing | 11 | 10-14-2006 05:57 PM |