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

How to get MySQL Table Storage Sizes

Getting MySQL Database Storage Sizes If you’...

Read more

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

There are 0 comments