Skip to content

Instantly share code, notes, and snippets.

@kimcoleman

kimcoleman/export_settings_wp_database_backup.txt

Created November 16, 2017 16:05
Show Gist options
  • Save kimcoleman/09b5bec3877c19dadb688081fb1a9297 to your computer and use it in GitHub Desktop.
Save kimcoleman/09b5bec3877c19dadb688081fb1a9297 to your computer and use it in GitHub Desktop.
Download ZIP
Recommended export settings for your WordPress MySQL database via phpMyAdmin
Raw
export_settings_wp_database_backup.txt
* Select All Tables
* Select "SQL" format
* Include "Structure" and the following settings:
** 'Add DROP TABLE / VIEW / PROCEDURE / FUNCTION'
** 'Add IF NOT EXISTS'
** 'Add AUTO_INCREMENT' and
** 'Enclose table and field names with backquotes'
* Save as File (we select 'gzipped' to compress the backup file size)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment