How to Restore MySQL Database from Backup File

Asked 3 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 3 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 1 year ago (Aug 20, 2023) in the field of Linux by Elizabeth Nikel

Score

Answer

1002

Visit

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

Score

Answer

817

Visit

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

Score

Answer

799

Visit

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

Score

Answer

782

Visit

Ask Question