Backup/Dump my Database/Table/Query/Script

Backup/Dump my Database/Table/Query/Script

Previous Top Next

To dump/backup a Database

Select your Database/Tables folder in your Folders pane, right click and then click Properties. The Information Tab will list all your database's tables, if you have the MySQL security privilege to see them. Click the Backup button. MyRun will start and create a complete Run and Backup query and script respectively. Once it has finished you can refresh your Queries and Scripts folder to view the scripts. To schedule a backup, just click the Schedule button instead to have MyCon add a new scheduled task to your Tasks folder. Remember to supply your windows username/password to the Task and setup a schedule for it.

To dump/backup a complete Table

MyCon provides you with two methods to dump tables. The easiest method, is to simply drag&drop or copy&paste your table(s) in your Folder View to your destination server's database.

Another method is to repeat the process outlined above for a whole database, but just start by selecting a specific table folder first, ex. select the Databases/Tables/MyTable folder, then click Properties' Information Tab to backup only this specific table. As is the case for a whole database, you can optionally schedule the backup as well.

To dump/backup a filtered and/or sorted and/or limited (partial) Table, or a Query or Script

To do a backup of any table which is filtered, limited (or not) or any Query or Script, follow the steps in Export Data