Wordpress database backup

does anyone know of a good way to automatically backup databases used for wordpress blogs? Preferably a way of getting the backup emailed as a .zip file to the admin user so they can be stored remotely?

FTP configuration for WordPress

I've installed a WordPress instance on a Linux server, and I need to give it FTP access in order to install plugins and execute automatic backup/restores. I've just installed vsftpd, and started...

Attempting to mute sound on YouTube video playlist autoplay

I'm trying to embed a YouTube playlist on a site and have it autoplay with the sound muted. I found this code to do that: <script src="http://www.google.com/jsapi"></script> <script...

Uploading to subversion repo via FTP or syncing with web server

I have a bunch of WordPress sites that I am managing. I am tasked with regularly backing them up to the companies subversion server. I have found a centralized tool where I can administer, update,...

A hook that let `pull` from VPS when I `push` to Bitbucket

I'm managing my wordpress template in Bitbucket. Each time I push the theme, I must log in my VPS server and pull the repo. I want to do it automatically. I found a solution if I run git deamon...

Can't access Wordpress admin login page (redirect error)

I’m working on a wordpress site, it’s almost finished. Left it lying on the server for a few weeks after the launch to gather user feedback, and now ready to make some minute adjustments. Loe...

Can Wordpress automatic update harm my website?

Recently I got to know that my Wordpress site is automatically updating itself when a new version of Wordpress is available. I know that this automatic feature is available in Wordpress since...

mysqldump - select table if it contains a specific string

I have a pretty big local WordPress Multisite installation, and this is mirrored on a live server, so I can develop a site locally and upload it for a client to see (it's sub-domain based). I...

Wordpress installed with Elastick BeanStalk overwrites uploaded images

I have Wordpress instance on Amazon Elastic BeanStalk. When I upload instance with EB scripts, the whole page is being replaced, also uploaded images which can be attached to posts. And after such...

Backing up my GCE instance

I'm finding what I'm trying to do so difficult, I simply must be going about it all wrong. I've got a Compute instance with just the root persistent disk. I'm just running a little Wordpress...

mod_rewrite, Centos and WordPress

I recently installed wordpress with my old backup and from another host on my VPS, centos 6 64 bits The problem is permalinks, mod_rewrite is enabled, and this is the only website on my VPS, which...

How to limit a directory to keep a certain amount of files in it

I'm am dumping a mysql wordpress database everyday as a backup. Since i don't want to end up with 365 .sql files after a year, i figured it would be decent only to keep the last 30 days of dump...

Wordpress - Is there a way to recover the table wp_term_relationships?

I'm trying to help a Non-Profit Organization with their site (which is built with Wordpress) that suddenly became "buggy"/odd: menus were missing, categories were empty, etc. I'm no expert around...

Backup a wordpress instance with Raspberry Pi

I have a Wordpress site on an external third-party-server. I am currently backing manually using FileZilla and phpMyAdmin. I have a Raspberry Pi which I want to use to make automatic backups of my...

How to Restore wordpress website from “domain_date_time.tar” backup file from hosting’s ‘application_backup’ folder?

How to Restore wordpress website from domain_date_time.tar backup file from hosting’s application_backup folder? Is there any method to bring back complete website back to live state this...

PHPMyAdmin database exports always cause MySQL #1231 error

I backup (export) Wordpress databases from production and import them into a development environment on a semi-daily basis. I use PHPMyAdmin to accomplish that and am forever haunted by this one...

How do i do a Heroku Jawsdb InnoDB database restore?

I am a hobbyist. Basically i'm playing with a heroku app-->php--> wordpress multisite-->JawsDB with innoDB/mysql. I didn't realise that the free database limit is only 5MB. (yes i know, i've...

How to handle wordpress database failure by connecting to backup database automatically

I have database back-up kept in 3 different servers. Whenever a database failure happens in the currently connected database server, I want my site to connect to the next specified database server...

Wordpress plugin - how to disable plugin automatic updates

I am using the wordpress plugin "WooCommerce Product Sort and Display LITE", where I have made few modifications to suit my site, but unfortunately my site crashes every night due to plugin...

deploy wordpress to bitbucket

I should need a automatic backup for my wordpress sites. I thought about bitbucket but is it possible to automate a deploy to my website from wordpress to bitbucket every N minutes/hours? I have...

Wordpress Error: "an error occurred while processing this directive". Debug.log output available

Hope someone might be able to shed some light on this one. The error is very generic and seems quite unpredictable. Happens on some page loads, not others, and when it does, if you refresh a few...

Secure, https When Live, Website Will Not Open Copy in XAMPP as http

I downloaded a backup copy of a Wordpress website to use in my xampp server. That website has an SSL certificate on the live server and the prefix to the domain name is https//. When I try to open...

Cant SSH to my Google Cloud VM instance anymore

Hoping someone can help me with this. The title says it all, I cant SSH to my VM instance. What I am seeing: 1 . If I try to SSH normally, the process just loops endlessly (I actually think the...