Coupon code copied
Server Intellect
(855) 850-HOST

Toll Free 24/7/365        (4678)

Get help from a Microsoft Certified Engineer.

Intellect Connect

Technical problem with your Windows Hosting?

Let our Microsoft Certified experts handle the problem for you.
Chat Now

How to Backup a MySQL Database

Connect to the server via RDP

Open MySQL Workbench

If there are no existing connection, connect to the server you wish to back up

Click on New Connection

Fill in the requested information

  • Connection name – The name that will be shown in MySQL Workbench (Does not affect connection)
  • Hostname – The IP address or hostname for the server
  • Port – 3306 is standard, modify if the server listens on an alternate port
  • Username – Usually root, but any account with similar privileges will work
  • The rest of the information can stay as is

Hit Test Connection

Insert the password for the account and try to connect

If your connection is successful, hit Ok

Click on Manage Import/ Export

Select the server that contains the database you wish to back up

Hit OK

Insert the password if prompted to do so

At this time a new tab will open for the database administration

Select the database you wish to export in the Select Database Objects to Export

On the Options section select Export to Self-Contained File

Change the file path to the desired location and file name

Check all the boxes so everything will be exported

Click on Start Export

You can now restore this file onto another MySQL server!

Interested in letting our experts solve your IT problems for you?
Get a free, no-obligations consultation with one of our experts today!

Call us at (855) 850-HOST

Chat Now

Start Your Order

X

This form does not accept free e-mail accounts. Please enter a business e-mail to submit it.

Submit Form Cancel

Please wait...

Submitting your info. This may take less than a minute.