Configure APF Firewall (Views: 684)
A firewall is a very good idea for a server. Though many people think that a firewall is...
You must follow the steps as described below inorder to back-up the MySQL database on a Linux dedicated server using SSH.
Step 1 : First of all you must root log-in to your linux dedicated server using SSH
Step 2 : Then, enter the below command to take backup of the MySQL Database
mysqldump -h host -u<databaseuser> -p [<NameofDatabase>] > BACKUP.sql
Note : Here you must replace “[<NameofDatabase>]” with the <exact name> of your current database which you intend to backup.
With these simple steps you can easily take backup of your database, where the file created would be BackUp.sql .
Now that you have the backup file with you, you can restore it as well, whenever required.
Inorder to do so, you again need to follow few simple steps as stated below.
Step 1 : You must be logged into your dedicated hosting server as root using SSH
Step 2 : Locate the dump file of the MySQL database.
Step 3 : Once in it, you must manually enter the below command for importing it into the chosen database :
mysql -h host -u<databaseuser> -p [<NameofDatabase>] < BACKUP.sql
NOTE : Replace “[<NameofDatabase>]” with the <exact name> of the database backup file (here it is BACKUP.sql) for restoration.
It may so happen that the dump file of the database contains a “CREATE DATABASE“clause, in that case, you must erase this line from the dump file. Any text editor can be used for that purpose.
We aim to give you the lowest possible prices for your Web Hosting, Servers & VPS packages and Domain Registrations. We don't have expensive call centres, so we can pass on these savings to you - making our hosting incredibly good value!
Looking to move to Umbrella Host? Need some sales advice?
Speak to our Sales Department on 0871 8111 507*.
*Please note this line is strictly for sales NO support will be given.
We'd love to help you! Just click here to request support and we'll reply as quickly as possible.