Asked By
ave broers
70 points
N/A
Posted on - 11/30/2012
Â
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?
How to restore movies database MySQL dump
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
How to restore movies database MySQL dump
Â
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,
 Â
