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
We need your assistance to stay live
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 |
- Fedora 21 Scheduled For Release In October : For Fedora users, just keep calm and use Fedora 20 for now. Fedora Developers has announced that F...1 comment |
- 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 |
- Install LAMP Server (Apache, MySQL or MariaDB, PHP) On Ubuntu 13.10 : Updated January 12, 2014 LAMP is a combination of operating system and open-source software stack. ...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 |
- How to Install uTorrent Client on Ubuntu/Debian/Linux Mint : uTorrent is a lightweight and efficient BitTorrent client for Linux, Windows OS and Mac OS. The inst...0 comments |
- Fedora 21 Scheduled For Release In October
- Install Uget Download Manager In Ubuntu, Fedora, Debian
- Download Elementary OS ‘Luna’ Official Wallpapers
- Install Power Commands 0.1.5 On Ubuntu 14.04/13.10/12.10/12.04
- 5 Android Apps that’s Going to Make Running Your Business Less Stressful
- Puppet agent Install Using Script
- Install Corosync and Pacemaker On CentOS 6.5
- Install Fail2Ban On Ubuntu Server 13.04/13.10
- How To Install Google Chrome in Fedora 20, 19, 18
- How to surf using Tor Browser Bundle
This work by unixmen.com is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License.
Copyright © 2008-2013 Unixmen.com .