How to restore movies database MySQL dump

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?

• Status: Open
• Question Views: 1111
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MySQL Server

Best Answer by Edmund Joseph

Go To Solution

Answered By Daniella Vylegzhanina 0 points N/A #151647

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

About Daniella Vylegzhanina

Questions
0

Answers
26

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 12/11/2012
• Question Category: MySQL Server

Best Answer

Best Answer

Answered By Edmund Joseph 5 points N/A #151648

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,

  

About Edmund Joseph

Questions
3

Answers
376

Best Answers
166

• Vote Up 0 Vote Down

• Posted on - 12/15/2012
• Question Category: MySQL Server