Backup / Restore Options

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
wimagine7
Posts: 4
Joined: Tue 18 Feb 2014 17:06

Backup / Restore Options

Post by wimagine7 » Wed 16 Jul 2014 05:19

I am backing up (and then restoring) a database that contains approximately 100 tables. There are 5-10 tables for which I only want to backup the structure (table definition). The remainder of the tables I wish to backup / restore the structure AND data. Can I do this in one step, or do I need to perform 2 backups / restores (one for structure only tables) and one for the structure AND data tables? Thanks in advance, Doug

alexa

Re: Backup / Restore Options

Post by alexa » Wed 16 Jul 2014 14:36

Unfortunately, this can't be done in one step. You need to make 2 backups, 1 for schema and the other one for data.

Nevertheless, you can add a suggestion on our UserVoice forum where other users can vote for it http://devart.uservoice.com/forums/7729 ... -for-mysql

We collect and analyze the information from this forum in order to make a proper roadmap for future product releases.

Post Reply