TheGoldenAura

Archive for April, 2013

I want this at home :) huffingtonpost.fr/mobileweb/2013…

Tuesday, April 30th, 2013

I want this at home :) huffingtonpost.fr/mobileweb/2013…

@ownClouders e.g. Speed of webinterface and sync with sync-clients (move is a move and not a copy-paste)

Saturday, April 27th, 2013

@ownClouders e.g. Speed of webinterface and sync with sync-clients (move is a move and not a copy-paste)

After testing both Owncloud 5 and Seafile 1.6.0… the winner is #seafile (IMPOV of Dropbox alternative)

Wednesday, April 24th, 2013

After testing both Owncloud 5 and Seafile 1.6.0… the winner is #seafile (IMPOV of Dropbox alternative)

Flipboard(ing) TweetBot’s new “media timeline”.

Wednesday, April 24th, 2013

Flipboard(ing) TweetBot’s new “media timeline”.

Installed #owncloud 5 on my dedicated server. Testing and comparing it with #seafile.

Monday, April 22nd, 2013

Installed #owncloud 5 on my dedicated server. Testing and comparing it with #seafile.

…riodismoalternativoblog.wordpress.com/2013/04/19/per…

Sunday, April 21st, 2013

…riodismoalternativoblog.wordpress.com/2013/04/19/per…

Code Dependency (by @marksiegal in @TheMagazineApp) the-magazine.org/14/code-depend…

Sunday, April 21st, 2013

Code Dependency (by @marksiegal in @TheMagazineApp) the-magazine.org/14/code-depend…

m.slashdot.org/story/185041

Sunday, April 21st, 2013

m.slashdot.org/story/185041

kickstarter.com/projects/clint…

Saturday, April 20th, 2013

kickstarter.com/projects/clint…

Most Projects On GitHub Aren’t Open Source Licensed flip.it/MVmkz

Thursday, April 18th, 2013

Most Projects On GitHub Aren’t Open Source Licensed flip.it/MVmkz

“Alemanha tem que decidir se quer sair do euro”, diz George Soros flip.it/Ar69e

Monday, April 15th, 2013

“Alemanha tem que decidir se quer sair do euro”, diz George Soros flip.it/Ar69e

A Good Death flip.it/9RgRB

Sunday, April 14th, 2013

A Good Death flip.it/9RgRB

Easily installed Debian “squeeze” on old iBookG4 and using it as a home server. Cool ;)

Sunday, April 14th, 2013

Easily installed Debian “squeeze” on old iBookG4 and using it as a home server. Cool ;)

I’m at Wolfisberg (Carouge, GE) 4sq.com/XJ7pWr

Saturday, April 13th, 2013

I’m at Wolfisberg (Carouge, GE) 4sq.com/XJ7pWr

I’m at Marché de Carouge (Carouge, GE) 4sq.com/10XkAkT

Saturday, April 13th, 2013

I’m at Marché de Carouge (Carouge, GE) 4sq.com/10XkAkT

WordPress Backup with: Database backup + files backup + remote ftp upload

Saturday, April 13th, 2013

Hard Disk Drive

These last years, I have been using WordPress to create different kind of sites and hosting them on my dedicated server. Despite all kinds of security strategies with data replication on the hosting machine it is an obligation to maintain a good remote backup system.

I have been using different WordPress backup plugins and most of them run fine with small sites. However, it can be really painful to do backups with the available plugins (including both free and commercial ones) when you have big sites, I mean bigger than 8GB data per site. This is just my personal experience, but I have used “commercial paid pro versions” plugins like BackupBuddy, Simple Backup Ultra, BackWPup… and always had problems.

This week, I got a really scary server crash and… I realise I have “insufficient” backups…

So I decided to stop being lazy and to create a very simple shell script to do exactly what I need.

It is a very simple script that backups the WordPress database, backups all site files, creates a tar with all this data, uploads to a remote destination by ftp, keeping backups from the last 30 days. Feel free to reuse it:

 

#!/bin/sh
#
# Script for backup of WP sites (WPsite001, WPsite002, WPsite003…) with mysql database backup, all site files backup and ftp upload to remote destination

 

# Finds files older than 30 days and delete them find /bck/ -type f -mtime +30 -exec rm -f {} \;

 

 

# These lines create the backups folders, dumps mysql databases, copy wordpress files and create a tar

# WPsite001

mkdir /bck/mysql/ mkdir /bck/backup/

mysqldump -umysqluser -pmysqlpassword site001databasename > /bck/mysql/site001databasename.sql

mv /bck/mysql/ /bck/backup/mysql/

cp -r /wpsite001-rootfolder/ /bck/backup/

cd /bck/

tar -cvf backup-wpsite001.$(date +%Y%m%d-%H%M%S).tar /bck/backup/ rm -R /bck/backup/

 

# WPsite002

mkdir /bck/mysql/ mkdir /bck/backup/

mysqldump -umysqluser -pmysqlpassword site002databasename > /bck/mysql/site002databasename.sql

mv /bck/mysql/ /bck/backup/mysql/

cp -r /wpsite001-rootfolder/ /bck/backup/

cd /bck/

tar -cvf backup-wpsite001.$(date +%Y%m%d-%H%M%S).tar /bck/backup/ rm -R /bck/backup/

 

#
# Uploads (resuming) files to FTP server machine
#
ncftpput -u user -p password -R -z remote-adress /remotefolder/ /bck/
#

Œuf et vin (@ Gusto E Sole) 4sq.com/ZKYyoz

Thursday, April 11th, 2013

Œuf et vin (@ Gusto E Sole) 4sq.com/ZKYyoz

Intel wants to kill the traditional server rack with 100Gbps links flip.it/ebF0s

Wednesday, April 10th, 2013

Intel wants to kill the traditional server rack with 100Gbps links flip.it/ebF0s

Goodbye Nice #epa2013 (@ Nice Airport Terminal 2 Lounge) 4sq.com/10S7Adt

Wednesday, April 10th, 2013

Goodbye Nice #epa2013 (@ Nice Airport Terminal 2 Lounge) 4sq.com/10S7Adt

Flight delayed, another night at Nice… WTF easyJet!!!

Tuesday, April 9th, 2013

Flight delayed, another night at Nice… WTF easyJet!!!

I’m at Le Marche (Nice, France) 4sq.com/10PFuPO

Tuesday, April 9th, 2013

I’m at Le Marche (Nice, France) 4sq.com/10PFuPO

RT @briansuda: was going to recommend Google Fusion Tables, but stopped short given it probably won’t be around in a year or two.

Tuesday, April 9th, 2013

RT @briansuda: was going to recommend Google Fusion Tables, but stopped short given it probably won’t be around in a year or two.

“The Year of the Brain – Joint Symposium with European Brain Council” starting now #epa2013

Tuesday, April 9th, 2013

“The Year of the Brain – Joint Symposium with European Brain Council” starting now #epa2013

EPA 2013 (d2) (@ Acropolis Convention Center) 4sq.com/XwPQsA

Sunday, April 7th, 2013

EPA 2013 (d2) (@ Acropolis Convention Center) 4sq.com/XwPQsA

Check out Geppetto (5 rue Gioffredo, Nice) on @foursquare: 4sq.com/Oe4zl2

Sunday, April 7th, 2013

Check out Geppetto (5 rue Gioffredo, Nice) on @foursquare: 4sq.com/Oe4zl2

Very good food and very very friendly place. (@ Geppetto) 4sq.com/10Iv2JP

Saturday, April 6th, 2013

Very good food and very very friendly place. (@ Geppetto) 4sq.com/10Iv2JP

EPA 2013 (@ Acropolis Convention Center) 4sq.com/10niwSS

Saturday, April 6th, 2013

EPA 2013 (@ Acropolis Convention Center) 4sq.com/10niwSS

After trying different bck plugins for WP, I think I finally found the right one: BackWPup. wordpress.org/extend/plugins…

Thursday, April 4th, 2013

After trying different bck plugins for WP, I think I finally found the right one: BackWPup. wordpress.org/extend/plugins…

E assim deixamos andar o nosso país. arrastao.org/2784220.html

Wednesday, April 3rd, 2013

E assim deixamos andar o nosso país. arrastao.org/2784220.html

E anda assim o nosso país. aventar.eu/2013/04/02/ah-…

Wednesday, April 3rd, 2013

E anda assim o nosso país. aventar.eu/2013/04/02/ah-…