MariaDB - How to Restore .sql file to Database in MariaDB or MySQL

Scenario: 

In our last post we created the logical backups of a database by using mysqldump. Now we need to restore that .SQL file to database.

Solution:

Login to MariaDB or MySQL database. Create an empty Database by using "create database DatabaseName" statement. In my case I create database ABC.

Fig 1: Create database in MariaDB or MySQL

Once you exited form MariaDB or MYSQL, on Shell provide below statement to restore .sql file to database. In my case I used empty database ABC.

shell> mysql -u root -p DatabaseName< sqlfile.sql




2 comments:

  1. Annually and Private and Regular Students Participate in CG Board Examination every year more than laks of Students. CG Board 10th Exam are Conducted by Chhattisgarh Board of Secondary Education Only, Students Are you guys Searching for CG 10th important Question Paper 2023 for Hindi, English Medium Available From this Webpage, CG Board 10th Question Paper 2023 All the Students can Download Subject wise Direct Links attached at the end of the page, we had Provided all CG Board 10th Class Model Question Paper 2023 Blueprint 2023 in the PDF Format

    ReplyDelete