Title: Mysql backup
Last modified: August 18, 2016

---

# Mysql backup

 *  [knotty](https://wordpress.org/support/users/knotty/)
 * (@knotty)
 * [20 years, 6 months ago](https://wordpress.org/support/topic/mysql-backup/)
 * An article on my webhost on backing up mysql with phpmyadmin, says it’s best 
   to first optimize the db.
 * Then, download the structure only.
    Then, download the data only.
 * Is there some advantage to doing it this way?
 * Thanks.

Viewing 3 replies - 1 through 3 (of 3 total)

 *  [Cypher](https://wordpress.org/support/users/cypher/)
 * (@cypher)
 * [20 years, 6 months ago](https://wordpress.org/support/topic/mysql-backup/#post-275860)
 * The advantages of optimizing the DB before downloading are self-evident.
 * The reasons for downloading the structure and data seperately would be if you
   wish to create an empty database with a given structure and fill in the data 
   without another blog.
 * But in praticality wise, it’s easier to just grab the structure and data together.
 * Regards
 *  [MichaelH](https://wordpress.org/support/users/michaelh/)
 * (@michaelh)
 * [20 years, 6 months ago](https://wordpress.org/support/topic/mysql-backup/#post-275865)
 * Just FYI:
 * Scott ‘Skippy’ Merrill has a plugin for backup: at: [http://www.skippy.net/blog/category/wordpress/plugins/wp-db-backup/](http://www.skippy.net/blog/category/wordpress/plugins/wp-db-backup/)
 * Lester ‘GaMerZ’ Chan has a plugin for backup:
    This Plugin does a backup and 
   has an optimization option but is a little trickier to install: [http://www.lesterchan.net/others/downloads.php?id=15](http://www.lesterchan.net/others/downloads.php?id=15)
 *  Thread Starter [knotty](https://wordpress.org/support/users/knotty/)
 * (@knotty)
 * [20 years, 6 months ago](https://wordpress.org/support/topic/mysql-backup/#post-275872)
 * Ok, got it. Yes, I have the backup plugin installed but for learning and familiarity
   purposes, I generally go the extra rigor, phpmyadmin route.
 * Thanks..

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Mysql backup’ is closed to new replies.

 * In: [Everything else WordPress](https://wordpress.org/support/forum/miscellaneous/)
 * 3 replies
 * 3 participants
 * Last reply from: [knotty](https://wordpress.org/support/users/knotty/)
 * Last activity: [20 years, 6 months ago](https://wordpress.org/support/topic/mysql-backup/#post-275872)
 * Status: not a support question

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics