Make sure you click the option for Export to Self-Contained File and then click Start Export. If you wanted to you can choose specific tables you want to include or exclude by clicking on the database. Now to begin the backup process click on Server > Data Export to be taken to a new page.īegin by clicking the checkbox next to the database you want to backup. Go ahead and double click on your newest connection to connect to the database. If you get any errors, please double check the information you entered.Īfter that you should see something like this You can click on Test Connection or OK and it will verify the information you entered and say connection successful.
#How to backup sql server database workbench password#
This will be the password set for the database if you never set it, it will be the same as your control panel password.
Password: Click on Store in Vault and you’ll be prompted to enter a password. Username: This will be the Database User found in the same place as the last step. Hostname: This will be the Database Server found in Control Panel under MySQL | Manage for the database you want to backup. You’ll want to click on that plus sign that the red arrow is pointing to (above) and you will be prompted to enter the following info:Ĭonnection Name: Any name to identify the database. In this post, I used MySQL Workbench v8.x. So once you have Workbench installed go ahead and open up MySQL Workbench and you should see the screen below (minus the red arrow). If you don’t have it, you can get it from here: I am going to run through the process I used to get this working and hopefully this should clear up any questions and make the process less confusing.īefore we start you will need the to have MySQL Workbench installed.
We have had a couple tickets come in from customers about backing up their MySQL database and how they followed the steps in a previous blog article and ran in to some trouble.
0 kommentar(er)
