Tech Wordpress sites backups - GoFuckYourself.com

Denny · 10-05-2016, 11:31 AM

Guys, I have a network of about 80 WP sites spread over 10 different hosts. What would be the best way to backup them (files+DBs) regularly? Doing it manually is a pain.

Thanks for your advices.

lordaRaG0n · 10-05-2016, 01:07 PM

I'm using InfiniteWP to manage the Wordpress sites in bulk and it also has backup features.

just a punk · 10-05-2016, 01:12 PM

WP-DBManager WordPress Plugins

robwod · 10-05-2016, 01:23 PM

Denny, the easiest, most reliable way to do this is via simple automation.

Create a folder on your server called "backups".
If you have bash/shell access, create a simple text file and name it backups.sh
In this file, use mysqldump to dump all of your databases to sql files. Also, you can add tar commands to backup each domain's files as well.
Upload this file, backups.sh to your server and then set a cron job to execute this file every night.
Use rsync to sftp to them any server you want, or even to connect to your own home cloud drive, such as WDMyCloud or your own home ftp server.

If you do not have the ability to create a bash file, then you can do it all via a series of cronjobs, though that's a little less efficient I think.

If you don't know how to do this type of thing, just shoot me a PM and I can explain it in detail specific to your needs.

HostedinVegas · 10-05-2016, 02:22 PM

Another plugin that is both free and paid is UpdraftPlus, it allows you to backup to like 15 different backup/storage options, plus it allows you to send the backups several different ones for double/triple the backups.

TheDA · 10-05-2016, 03:40 PM

Quote:

Originally Posted by HostedinVegas

Another plugin that is both free and paid is UpdraftPlus, it allows you to backup to like 15 different backup/storage options, plus it allows you to send the backups several different ones for double/triple the backups.

hdbuilder · 10-05-2016, 04:38 PM

Yeah me too I use WP-DBManager WordPress Plugins, it can send the backup to your email too...

myleene · 10-05-2016, 06:33 PM

Quote:

Originally Posted by robwod

Denny, the easiest, most reliable way to do this is via simple automation.

Create a folder on your server called "backups".
If you have bash/shell access, create a simple text file and name it backups.sh
In this file, use mysqldump to dump all of your databases to sql files. Also, you can add tar commands to backup each domain's files as well.
Upload this file, backups.sh to your server and then set a cron job to execute this file every night.
Use rsync to sftp to them any server you want, or even to connect to your own home cloud drive, such as WDMyCloud or your own home ftp server.

If you do not have the ability to create a bash file, then you can do it all via a series of cronjobs, though that's a little less efficient I think.

If you don't know how to do this type of thing, just shoot me a PM and I can explain it in detail specific to your needs.

+1

A remote server with OpenStack is perfect for this.

That's what I have. Once setup and tested (untested backups aren't better than bricks), It's awesome.

Denny · 10-06-2016, 04:30 AM

Thanks guys

avx · 10-06-2016, 05:10 AM

Quote:

Originally Posted by HostedinVegas

Another plugin that is both free and paid is UpdraftPlus, it allows you to backup to like 15 different backup/storage options, plus it allows you to send the backups several different ones for double/triple the backups.

I use UpdraftPlus too, great plugin. You can schedule backups every 4, 8, 12, daily, weekly or monthly backups. You may back up DB and files separatly + nice other features and that's only the free version.

druid66 · 10-06-2016, 07:36 AM

Quote:

Originally Posted by CyberSEO

WP-DBManager WordPress Plugins

does it backup everything, like html/php structure of the site + all posts, images on the galleries, tags, categories?
so for example i can ftp upload backup on fresh domain and have my old site with all goodies running?

HowlingWulf · 10-06-2016, 09:10 AM

I use an FTP program that I can script automatic backups over any number of servers and sites.

MakeMeGrrrrowl · 10-06-2016, 09:26 AM

Quote:

Originally Posted by avx

I use UpdraftPlus too, great plugin. You can schedule backups every 4, 8, 12, daily, weekly or monthly backups. You may back up DB and files separatly + nice other features and that's only the free version.

I third this option.

robwod · 10-06-2016, 10:41 AM

The problem with plugins is that they create a dependency on a third party -- OFTEN by authors doing it for a hobby or for free. And then you now rely said third party author to keep their plugins current. Plugins are likely the #1 reason for problems with Wordpress sites during an upgrade, themes are probably second. Not to mention that every plugin you use -- even those not activated -- add to a server overhead and external calls (such as checking them for upgrades).

Thus, for anyone with the ability to do so, removing as much reliance on third parties to make your site work is not a bad thing. Certainly for something as simple as backups, database dumps, and rsyncs, using native command line tools like tar, mysqldump, and shell ftp, would be more efficient overall.

just a punk · 10-06-2016, 11:10 AM

Quote:

Originally Posted by druid66

does it backup everything, like html/php structure of the site + all posts, images on the galleries, tags, categories?
so for example i can ftp upload backup on fresh domain and have my old site with all goodies running?

It backups MySQL databases only (all posts, pages and the whole site structure). It does not backup any files however (e.g. images, videos etc).

j3rkules · 10-06-2016, 11:53 AM

I am using WP-DBManager plugin. Works flawlessly.

druid66 · 10-06-2016, 12:05 PM

Quote:

Originally Posted by CyberSEO

It backups MySQL databases only (all posts, pages and the whole site structure). It does not backup any files however (e.g. images, videos etc).

Thanks Cyber, can you advice me how to backup whole site with images from galleries as well in maximum easy way?

just a punk · 10-06-2016, 12:34 PM

Quote:

Originally Posted by druid66

Thanks Cyber, can you advice me how to backup whole site with images from galleries as well in maximum easy way?

I don't know about a universal solution. I do backup databases and files with separate scripts. Actually it's not a big deal to write a script which will do both things simultaneously and perhaps it already exists somewhere..

robwod · 10-06-2016, 02:02 PM

Quote:

Originally Posted by CyberSEO

I don't know about a universal solution. I do backup databases and files with separate scripts. Actually it's not a big deal to write a script which will do both things simultaneously and perhaps it already exists somewhere..

Yes, a simple bash script. In a simple text editor, a person could enter the following and save it as backups.sh

Code:

# ##########################################################
# DUMP DATABASE(S)
# ##########################################################

mysqldump --user=root --password='whatever' --host=localhost databasename > databasename.sql

# ##########################################################
# TAR WEBSITE(S)
# ##########################################################

tar -cpf domainname.tar /path/to/domainname.com

# ##########################################################
# MOVE FILES TO BACKUP FOLDER
# ##########################################################

mv databasename.sql /path/to/backups/
mv domainnanme.tar /path/to/backups/

You could of course, dump/tar and move at one time, but this just explains it relatively easy.

All one needs to do then is to add a cron job to execute backups.sh nightly.

Code:

0 0 * * * /bin/bash /path/to/backups.sh > /dev/null

That's it, now your databases and all files for the specified domain are backed up every night at midnight. If you want to store them on a separate server, rsync will let you connect to any of your other hosts and you can transfer them in similar fashion, through a simple bash script and a cronjob.

And these command line instructions remove any dependency on a third party plugin and are included with any basic *nix server.

rastan · 10-06-2016, 03:45 PM

Quote:

Originally Posted by HostedinVegas

Another plugin that is both free and paid is UpdraftPlus, it allows you to backup to like 15 different backup/storage options, plus it allows you to send the backups several different ones for double/triple the backups.

^^^ This. Excellent tool

Kafka · 10-06-2016, 03:45 PM

Quote:

Originally Posted by robwod

Yes, a simple bash script. In a simple text editor, a person could enter the following and save it as backups.sh

Code:

# ##########################################################
# DUMP DATABASE(S)
# ##########################################################

mysqldump --user=root --password='whatever' --host=localhost databasename > databasename.sql

# ##########################################################
# TAR WEBSITE(S)
# ##########################################################

tar -cpf domainname.tar /path/to/domainname.com

# ##########################################################
# MOVE FILES TO BACKUP FOLDER
# ##########################################################

mv databasename.sql /path/to/backups/
mv domainnanme.tar /path/to/backups/

You could of course, dump/tar and move at one time, but this just explains it relatively easy.

All one needs to do then is to add a cron job to execute backups.sh nightly.

Code:

0 0 * * * /bin/bash /path/to/backups.sh > /dev/null

That's it, now your databases and all files for the specified domain are backed up every night at midnight. If you want to store them on a separate server, rsync will let you connect to any of your other hosts and you can transfer them in similar fashion, through a simple bash script and a cronjob.

And these command line instructions remove any dependency on a third party plugin and are included with any basic *nix server.

The user should not be root but the user who is admin of that particular database.

robwod · 10-06-2016, 05:10 PM

Quote:

Originally Posted by Kafka

The user should not be root but the user who is admin of that particular database.

Good catch.

10-05-2016, 01:07 PM	#2
lordaRaG0n Confirmed User Industry Role: Join Date: Nov 2013 Posts: 93	I'm using InfiniteWP to manage the Wordpress sites in bulk and it also has backup features. __________________

10-05-2016, 01:12 PM	#3
just a punk So fuckin' bored Industry Role: Join Date: Jun 2003 Posts: 32,386	WP-DBManager WordPress Plugins __________________ Obey the Cowgod

10-05-2016, 01:23 PM	#4
robwod Confirmed User Industry Role: Join Date: Nov 2005 Posts: 2,539	Denny, the easiest, most reliable way to do this is via simple automation. Create a folder on your server called "backups". If you have bash/shell access, create a simple text file and name it backups.sh In this file, use mysqldump to dump all of your databases to sql files. Also, you can add tar commands to backup each domain's files as well. Upload this file, backups.sh to your server and then set a cron job to execute this file every night. Use rsync to sftp to them any server you want, or even to connect to your own home cloud drive, such as WDMyCloud or your own home ftp server. If you do not have the ability to create a bash file, then you can do it all via a series of cronjobs, though that's a little less efficient I think. If you don't know how to do this type of thing, just shoot me a PM and I can explain it in detail specific to your needs. __________________ NSFW

10-05-2016, 04:38 PM	#7
hdbuilder Confirmed User Industry Role: Join Date: Jun 2012 Location: Canada Posts: 1,338	Yeah me too I use WP-DBManager WordPress Plugins, it can send the backup to your email too... __________________ ROBO SCRIPTS \| WP CAM PLUGIN - Scripts To Promote Cam Sites - Chaturbate, BongaCams, Streamate, LiveJasmin, Stripchat... The Cam Site Builder, The Cam Multi Site Builder -> MULTIPLE CAM SITES IN ONE

10-06-2016, 04:30 AM	#9
Denny Too lazy to set a custom title Industry Role: Join Date: Feb 2005 Posts: 17,301	Thanks guys __________________

10-05-2016, 11:31 AM	#1
Denny Too lazy to set a custom title Industry Role: Join Date: Feb 2005 Posts: 17,301	Wordpress sites backups Guys, I have a network of about 80 WP sites spread over 10 different hosts. What would be the best way to backup them (files+DBs) regularly? Doing it manually is a pain. Thanks for your advices. __________________

10-05-2016, 02:22 PM	#5
HostedinVegas Confirmed User Industry Role: Join Date: Feb 2011 Posts: 110	Another plugin that is both free and paid is UpdraftPlus, it allows you to backup to like 15 different backup/storage options, plus it allows you to send the backups several different ones for double/triple the backups.

10-06-2016, 09:10 AM	#12
HowlingWulf Confirmed User Join Date: Nov 2001 Posts: 1,662	I use an FTP program that I can script automatic backups over any number of servers and sites. __________________ WP Porn directory/review theme Maddos $35. webmaster AT howling-wulf.com

10-06-2016, 10:41 AM	#14
robwod Confirmed User Industry Role: Join Date: Nov 2005 Posts: 2,539	The problem with plugins is that they create a dependency on a third party -- OFTEN by authors doing it for a hobby or for free. And then you now rely said third party author to keep their plugins current. Plugins are likely the #1 reason for problems with Wordpress sites during an upgrade, themes are probably second. Not to mention that every plugin you use -- even those not activated -- add to a server overhead and external calls (such as checking them for upgrades). Thus, for anyone with the ability to do so, removing as much reliance on third parties to make your site work is not a bad thing. Certainly for something as simple as backups, database dumps, and rsyncs, using native command line tools like tar, mysqldump, and shell ftp, would be more efficient overall. __________________ NSFW

10-06-2016, 11:53 AM	#16
j3rkules VIP Industry Role: Join Date: Jul 2013 Posts: 22,111	I am using WP-DBManager plugin. Works flawlessly. __________________ How To Build A Porn Site And Make Money \| My Best $$$ Cam Sponsor \| New Webcam Script 3 Top Adult Hosting Providers