How to Backup and Restore MySQL Database’s Using MySQL Workbench
MySQL Workbench is a graphical design tool for MySQL databases. It is used for database server administration, database design, creation, security management and server as well as database maintenance.
Install MySQL Workbench on Ubuntu:
sk@sk:~$ sudo apt-get install mysql-workbench
Add Database Server connection
Now open MySQL Workbench from Menu or Dash. The main page of MySQL Workbench will look as shown below.
Click on ‘New Server Instance’. Enter remote hostname or IP Address.
Now enter the Connection Name to easily identify your database, Select TCP/IP from connection method, hostname and port number and finally enter the database name in the default schema column. Click Next.
Enter the database user password. In my case its centos.
Select Do not use Remote Management and Click Next.
Enter Server Instance Name to easily identify your database being backup. Click Finish.
Now the remote database connection has been made successfully.
Click on Manage Import / Export. It will ask your database user password. Enter the password and click OK.
Navigate to Data Export in the Left pane. Select the database to be exported. In my case, i select testdb. Select the tables and define the location where you want to save the database backup. Then click Start Export.
It will ask the database user password. Enter the password and click OK.
Now the database backup has been created.
Click on Manage Import / Export in the MySQL workbench Main window. Enter the database user password. Navigate to Data Import/Restore under DATA EXPORT /RESTORE section.
Browse to the folder where you have stored the backup file.
Enter the database user password and click Start Import.
It will ask the database user password again. Enter the password and you’re done. It will take a while depending upon your database size.
You have successfully restored your database backup.
Like us on Facebook
This week Top Posts
- Top Things To Do After Installing Ubuntu 13.10 'Saucy Salamander' : Ubuntu 13.10 Saucy Salamander will be released on coming October 17th with many new salient featur...0 comments |
- How To Install Netflix In Ubuntu : Hi unixmen readers! How are you? In this article we will teach you how to install the desktop vers...1 comment |
- How To Configure Linux Clients To Authenticate Using OpenLDAP : This is the continuation of our previous tutorial. In our previous tutorial we learned how to instal...2 comments |
- How To Upgrade From Ubuntu 13.04 Raring To Ubuntu 13.10 Saucy Salamander : Ubuntu 13.10 Saucy will be released on October 17th. Hope it will come with lot of improvements and ...0 comments |
- Setup IT And Asset Management System With GLPI On Debian/Ubuntu : GLPI is the Information Resource-Manager with an additional Administration Interface. You can use it...0 comments |
- Install lamp with 1 command in Ubuntu 12.10, 13.04 Raring Ringtail & LinuxMint13 : Updated: 10/09/2012 :LAMP (Linux, Apache, MySQL and PHP) is an open source Web development platform ...0 comments |
- Manage Databases And Hosted Servers Remotely With DbNinja
- Install FrostWire 5.6.9 In Elementary OS ‘Luna’/ Ubuntu / Linux Mint
- Setup IT And Asset Management System With GLPI On Debian/Ubuntu
- How To Configure Linux Clients To Authenticate Using OpenLDAP
- How To Install Netflix In Ubuntu
- cowsay And fortune Combined Together
- How To Show Username On Panel In Ubuntu 13.04/13.10
- Setup DNS Server On openSUSE 13.1
- TeamViewer 9 Final Has Been Released!
- Twelve Vulnerabilities Have Been Fixed In Ubuntu 12.04, Time To Update
This work by unixmen.com is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License.
Copyright © 2008-2013 Unixmen.com .