MySQL Forums
Forum List  »  Newbie

A question about backup DB and restore it on other machine.
Posted by: Jason Long
Date: May 26, 2019 09:44AM

Hello.
I created a backup from my database by "sqldump" command and I like to restore it on another machine. I have some questions:
1- The suffix of DB must be .sql?
2- If on machine 1, the DB name is "mydb" and I created a backup from it then on machine 2 for restore it, first of all I should create an empty DB with the name "mydb" and then import my backup or it is not needed?

Thank you.

Options: ReplyQuote


Subject
Written By
Posted
A question about backup DB and restore it on other machine.
May 26, 2019 09:44AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.