How to Restore MySQL Database from Backup File

Asked 2 years ago (Feb 23, 2022) in the field of Linux by Kalameez

Hello, I have backup MySQL Databases using the mysqldump command, how can I restore it now?

Answered 2 years ago (Feb 23, 2022) by Eldernode Staff

You can use mysql command for it. For example following command will restore all backup from mydb.sql to newdb database.

mysql -u root -p newdb < newdb.sql

mysql -u root -p < all_databases.sql

Asked 8 months ago (Aug 20, 2023) in the field of Linux by Elizabeth Nikel

Score

Answer

495

Visit

Asked 8 months ago (Aug 20, 2023) in the field of Linux by Terry Lee

Score

Answer

433

Visit

Asked 8 months ago (Aug 20, 2023) in the field of Linux by Ruth Rebecca

Score

Answer

430

Visit

Asked 8 months ago (Aug 20, 2023) in the field of Linux by William Black

Score

Answer

438

Visit

Ask Question