You can use the WP-CLI command wp db export <filename>
Run the command from within the home directory for the install.
Now, you have a database included in your files. Zip up the directory and move it aside. Now you can perform the upgrade, and if something breaks, replace with the old site and import the old database. voila, previously working site restored.
Related Posts:
- Postgresql 9.2 pg_dump version mismatch
- What is a better way to backup files than FTP?
- What is the best method to export local WordPress installation and import to live server?
- How to Add Back Buttons to Web Pages [closed]
- How to backup and restore configurations
- WordPress Admin Interface not styled properly
- Is it possible to create a WordPress backup by simply copying it?
- Updating to new 3.0.5
- Managing Backups: Space Issues [closed]
- WordPress staging environment that syncs everything except posts?
- Which Blog Client for Windows/Linux has the best support for backing/restoring your posts?
- WordPress manual restore not completely successful
- Backup custom table
- Backup localhost (wamp) database (phpmyadmin) from harddrive files on windows? For WordPress?
- Restored my site using a backup. Seems to be OK but the posts are empty?
- Backing up WordPress before an update, what’s the easiest way to do this?
- Restoring backup of wordpress website on LAMP
- Recover wordpress by replace file manually
- Restore large number of permanently deleted posts
- Can I Restore My Website Pages Without mySQL Database?
- How can I make revisions more extensive?
- what to backup (for partial restore)??
- Backing up an old version of WP before upgrading
- How to restore all items from trash
- BackupBuddy, for backups, backups in general etc, any good?
- How do you “test-restore” a backup?
- How to fully backup a WordPress site?
- How do I passively back-up my WordPress websites on a frequent basis? [closed]
- How to setup a wordpress backup in localhost?
- How to completely save my wordpress data?
- Can I delete .git folder in a completed WP project?
- Auomated crash recovery?
- back up fully Customized WordPress theme [closed]
- WPCLI search and replace in a particlar site dir effect another site-dir
- Restoring from a old local copy of xampp folder where the project was stored
- WP was redirecting to install.php, I installed again and replaced old files with new one but lost all data
- Can I roll back WP Install but keep my newer database?
- How to Backup and Transfer Everything to Another WordPress Site?
- Duplicated WordPress Site STILL Linked to Old Site
- Backup wordpress installation on shared hosting
- Using database in new instalation
- How to copy a WP website to new domain name?
- Why is RAID not a backup?
- GIT as a backup tool
- How to backup 20+TB of data?
- How to keep the full path with rsync?
- How to backup my plugin database [closed]
- WP-CLI not recognizing commercial plugin updates
- Why is it important to deactivate a plugin before deleting it?
- WP-CLI get all posts from certain post type and taxonomy term
- Is it possible just by using wp-cli to migrate one multisite instance to single site?
- Revert WordPress default options after a PHPUnit test has run
- Can I create multiple pages at once using WP-CLI?
- How do I set and list page_template with wpcli?
- What is the best WordPress plugin for Amazon s3 backups? [closed]
- Does WordPress Import/Export tool actually exports media (images) as well?
- Wp-cli-ssh global installation problem [closed]
- WPCLI search and replace variants for all tables
- Allow download_url for lan addresses
- Recover from failed multisite conversion
- How to change a post attribute to homepage using WP CLI?
- Unable to install plugins from wp-cli
- WP CLI Get all Enqueued Scripts and Styles
- How to use wp db export and import together?
- Edit page’s “Restore the backup” link does nothing
- Local WordPress installs don’t verfiy against wp-cli checksum check and how to fix that issue.
- WP CLI not finding plugin commands
- Specify custom php.ini to use with WP-CLI
- WP CLI Core install – blank database
- Is resetting post data necessary with custom WP_CLI commands?
- Do all WordPress installations include WP CLI by default
- A shorter way to automatically update WordPress?
- UpdraftPlus installed malware – scared to download or update plugins now! [closed]
- wp-cli for Creating page-template
- WP-CLI unable to recongnise PHP server / environment variables on Ubuntu
- How best to keep my localhost on Http while my Remote production is on Https
- Can’t Connect to MySQL Database using WP CLI and MAMP on a macOS Catalina, using Oh My Zsh
- How do I deactivate widgets by name?
- Automate WordPress website setup with prefilled data
- Do I need a backup plugin if I’m already backing up via cPanel?
- How to remove symlink from folder
- What user should I use for wp-cli on Ubuntu VPS [closed]
- WordPress Import (CLI) returns Error Establishing a database connection
- Working with CLI and missing my namespace classes inside
- wp-cli error: “Term is missing a parent”
- call to undefined function mysql_connect
- Migrate site from local to local via a backup
- Can you Recover a WordPress User from a Backup
- wp-config.php not affecting my site
- WP CLI: critical error on your website
- Creating a subcommand for custom wp-cli command
- How can I export data without using any import/export plugin
- blank page after update my theme
- WP-CLI wp theme install url PCLZIP_ERR_BAD_FORMAT (-10) : Unable to find End of Central Dir Record signature
- How to update WP-CLI on Windows via Composer?
- how to restore wordpress backup(.rar) manually?
- protocol version mismatch — is your shell clean?
- restore backup full content or just specific folders
- Why not attaching images after impoting using wp cli
- Batch Replace URLs in WordPress Database