Mobile app version of vmapp.org
Login or Join
Pierce454

: Is is OK to back up a WordPress installation while it is serving content? Running a LEMP stack on Ubuntu 16.04. Found plenty of great documentation for backing up WordPress: Export your database:

@Pierce454

Posted in: #Backups #Mysql #Wordpress

Running a LEMP stack on Ubuntu 16.04. Found plenty of great documentation for backing up WordPress:




Export your database:

mysqldump --add-drop-table -h mysql_hostserver -u mysql_username -p mysql_databasename

Copy the webroot where WordPress is located:

cp -a /var/www/nginx/example.com/. /home/$USER/WPBackup/



Can I backup the MySQL database and WordPress installation safely and effectively while LEMP is serving content?

It seems like it could be a bad idea to make a backup while the database and WordPress files are being accessed.

No where in the WordPress documentation do I see a mention of whether or not it is safe to backup a WordPress installation that is serving content. If I cannot serve content while I am backing up WordPress, I may have something of a problem on my hand, as any amount of downtime is bad news for myself and the clients I host websites for.

If I backup WordPress while LEMP is serving content, will the backup of my database and/or WordPress installation risk becoming corrupted while it is being created? If so, how else could I go about backup up a WordPress installation without downtime, however little, coming into the equation?

10.02% popularity Vote Up Vote Down


Login to follow query

More posts by @Pierce454

2 Comments

Sorted by latest first Latest Oldest Best

 

@Correia994

I have not looked deeply into the structure, but the only thing to worry about is if the site being edited.
Perhaps a menu referencing a page, and the inconsistency if the page was created after the page table was backed up but before the menu table was.

But that will probably never happen...

10% popularity Vote Up Vote Down


 

@Barnes591

It should be completely safe to backup WordPress during normal operations. In fact, some of the best backups available for WordPress run live on the instance and do minute to minute backups of all changes (VaultPress and similar). Invoked backups will usually just copy the WordPress database tables and also copy the wp-content folder to the indicated destination. The only thing you may notice is some performance issues on slow/shared servers but you shouldn’t see any issues on VPS or properly configured dedicated.

tl;dr Yes, it’s safe.

10% popularity Vote Up Vote Down


Back to top | Use Dark Theme