How to restore movies database MySQL dump

Asked By 70 points N/A Posted on -
qa-featured

 

I have been manning a Movie Database for over a year now using MySQL. Now I am planning to make a new database with more movies. So before I can do this, I want to back up MySQL database. I started backing it up last night and from what I know of is that by simply copying files from this to that may lead to its corruption but it seemed to be the best option I found so far. So I started backing it up last night and made a complete wipeout of the database since I tried one file and it didn’t have any problems. When I checked on them this morning, almost 50% of the files were corrupted and I can’t help but panic because I wiped-out my whole database last night. Is there anyone who has an idea on how to reverse movies database mysql dump?

SHARE
Best Answer by Edmund Joseph
Answered By 0 points N/A #151647

How to restore movies database MySQL dump

qa-featured

It's extremely easy to do backup I'm MySQL with he help of  mySQLdump. In a case of database backup you just have to complete the following:

single database   mysqldump–user=…–password=…databases_name>your_database_name.sql

for multiple databases   mysqldump–user=…password=…–databases db1 db2> backup.sql

for all the databases   mysqldump–user=…password=…–all databases>backup.sql

Restoring as usual is done this way    mysql-u root-p[password] restoredbname<dbname_backup.sql

Best Answer
Best Answer
Answered By 0 points N/A #151648

How to restore movies database MySQL dump

qa-featured

 

Hi there user:

Here’s how to restore your MySQL database. But first, I need to know if your database was removed (totally) already. If not, remove it now because you cannot restore your database using the code below if your database still exists. mysql – u user_name –p your_password database_name < file_name.sql And all is well!

Thank you for asking here at techyv.com. Feel free to post your queries.

Best regards,

  

Login/Register to Answer

Related Questions