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]
- Backup Site Data from a Bitnami WordPress instance
- Adb backup does not work
- input file appears to be a text format dump. Please use psql
- How to extract or unpack an .ab file (Android Backup file)
- UpdraftPlus WordPress plugin is not working to store Backup in the Google Drive
- How to change user password with wp-cli?
- Detect if WP is running under WP-CLI
- Running WP Cron on multisite the right way
- WP CLI “Error establishing a database connection” in localhost (MAMP)
- how to update serialized options programatically?
- What’s the simplest way to backup my WordPress database?
- How I prevent a plugin to be loaded when doing WP-CLI?
- Fastest way (least amount of steps) to locally import a remote database using WP-CLI
- WP-CLI not recognizing commercial plugin updates
- Why is it important to deactivate a plugin before deleting it?
- wp-cli Enabling Maintainance Mode
- Mysqldump add drop table?
- Is there a drush equivalent for WordPress yet?
- WP-CLI – Selecting PHP version
- How do I run a PHP script from WordPress environment, like `wp shell`?
- Using wp-cli can I not query pages by their title?
- wp-cli displays php notices when display errors off
- wp-cli 0.14.1 MySQL error
- How can I bulk delete media and attachments using WP-CLI?
- How to change user_login with wp-cli?
- How can I batch delete all unattached images with WP-CLI or other automated process?
- WP-CLI Cannot Connect to Database due to Vagrant
- Changing the WP CLI cache folder
- WordPress test environment on windows
- WP-CLI Process Killed
- Backup the Database and Restore from the Backup?
- How to use wp-cli.yml file?
- wp-cli commands do nothing, return nothing
- Does wpdb add considerable overhead on queries with large result sets?
- WP cli –path does not seem to work
- Enable Auto-updates for all plugins using wp-cli? (since wordpress 5.5)
- How do I clone or duplicate a post with the WordPress Command Line Interface WP-CLI?
- Run WP-CLI using PHP
- How to update an ‘array’ option using wp-cli [duplicate]
- How to use command ‘wp post create’ in wp-cli properly?
- How do I activate an mu-plugin with WP-CLI?
- WP-CLI get all posts from certain post type and taxonomy term
- How to create a WP-CLI command with $_POST?
- wp-cli doesn’t find and wordpress installation
- How to keep a WordPress site synchronized between two servers?
- Does wp post delete also delete metadata associated with posts?
- WP-CLI :: Cannot installing plugin as www-data
- How to reset passwords for all users on a network using wp cli
- WP-CLI methods for get_current_blog_id, get_blog_details or $wpdb->prefix
- WP-CLI Bulk delete posts from specific category
- Disable comment windows for all existing posts (pages/blogposts)
- wp media regenerate unknown –image_size parameter
- Difference between deactivating, uninstalling, and deleting plugins