search

fourcodes-org / proof-of-concepts

2 stars 1 forks source link

103. How can we restore the database when it is required? #134

Closed four-codes closed 7 months ago

fourtimes commented 11 months ago

Restore the database when it is required

  1. create the database inside the specific user 
    CREATE DATABASE testing;
  2. check the backup file - testing.sql
  3. Restore the backup data with newly created database. 
    mysql -u root -p --one-database testing < testing.sql

    OUTPUT

    Image