I had this problem today, I wanted to create a backup before making some changes. WordPress Backup 2 Dropbox appears to only have a schedule setting. A lot of people complained in the reviews of the plugin about this and gave it low ratings.
But I discovered this functionality is actually there, it's just in a place nobody would ever think to look: Backup Log.
How To Backup Your WordPress Immediately with WordPress Backup 2 Dropbox:
1. Login to your WordPress Admin section.
2. Find WPB2D on the sidebar and click 'Backup Log'
3. Click 'Start Backup'
4. You're done!
It can take some time to generate the backup, but it seems to restart itself pretty well and get it done, eventually.
I hope this saves some WordPress Developers time in the future!
I will teach you two ways to backup/export your mysql database(s). The first option is using phpMyAdmin; phpMyAdmin is generally installed on most shared hosting and is bundled with cPanel. The second method is SSH; this requires SSH access (often found on VPS/Dedicated servers).
Backing Up Your Database With phpMyAdmin
- Login to your phpMyAdmin. If you are using cPanel, it has its own icon on the dashboard when you login.
- Click on the database you want to backup/export.
- You should see a screen like this:
- Click on the Export tab at the top.
The default options are generally good. It will save both your schema (database design) and data (database content). However, if the database is large, you probably want to choose 'Save as a File' and pick a compression type (zip/gzip). This will let you download the file and have it take less space. If it's small and you just want the code directly, don't change this.
If you want to import the data, just click the import tab (instead of export) and upload the file.
Backing Up Your Database With SSH
We are going to use mysqldump which comes with mysql.
- Login to your server via SSH.
- Type in the following command replacing YOURUSER, YOURPASSWORD and YOURDATABASE with your mysql username, mysql password and the database you want to backup. Also change /path/to/output/file.sql to the location you want to save the backup.
mysqldump –quick –user=YOURUSERNAME –password=YOURPASSWORD YOURDATABASE < /path/to/output/file.sql
If you want to backup all your databases instead of a specific database, replace YOURDATABASE with –all-databases
Once the command finishes running, your backup is in the .sql file you specified.
If you want to automate backups of your database, there is a nifty MySql backup to Amazon's S3 file storage script here: https://github.com/woxxy/MySQL-backup-to-Amazon-S3