MySQL
Restore Database from backup SQL file
November 6, 2014
0
, , , ,

Terminal Window:

mysql> use databasename;
// databasename – this is the database name where you want to reload the backup.
// In MySQL, now the active selected database will be databasename

mysql> source /backup/db.sql
//backup will start from db.sql

 

About author

ZERIN

CEO & Founder (BdBooking.com - Online Hotel Booking System), CEO & Founder (TaskGum.com - Task Managment Software), CEO & Founder (InnKeyPro.com - Hotel ERP), Software Engineer & Solution Architect

Upgrading MySQL 5.6 to 5.7 – Group By Does not work anymore

Recently I have updated one of my server MySQL, th...

Read more
mariadb_mysql

MySQL how To – show open database connections

MySQL Current Connection Query Information You can...

Read more

Linux How to Find Files based on the File Size

If you want to search all the files that are more ...

Read more

There are 0 comments