Header Banner
gadgethacks.mark.png
Gadget Hacks ShopApple GuidesAndroid GuidesiPhone GuidesMac GuidesPixel GuidesSamsung GuidesTweaks & HacksPrivacy & SecurityProductivity HacksMovies & TVSmartphone GamingMusic & AudioTravel TipsVideography TipsChat Apps
Home
Internet

How to Restore a Backup of a MySQL Database Server

May 26, 2011 03:25 AM

In this article, i will show you how to backup/restore mysql from remote server, steps are very simple. You can just copy & paste to do your jobs. This help is on linux system with command line how to. You can do it by navicat tool or MySQL GUI, but i still like terminal command line.

You can read the dump file back into the server like this:

mysql db-name < backup-file.sql

To restore database called sales, first create the database sales:

$ mysql -u root -p

You will be asked root password of your mysql on server. Please enter root password mysql to access SQL statement.

Now create database called sales using SQL statement:

mysql> CREATE DATABASE sales;

mysql> quit;

Now restore database by using the following command:

$ mysql -u root -p sales < /path/to/sales-backup-file.sql

You will be prompted for password databases to execute the command.

That's all.

Just updated your iPhone? You'll find updated Apple Intelligence capabilities, new wallpapers, and enhancements to Calculator, PDF cropping, and Live Voicemail, among other useful features. Find out what's new and changed on your iPhone with the iOS 18.3 update.

Related Articles

Comments

No Comments Exist

Be the first, drop a comment!