mysql backup and restore
Posted on 2015-02-15
I am newbie to mysql and want to clarify below on mysql backup and restore
What are the things needed to backup mysql and restore it like database name, username, password etc.
1)I have a database which need to be restored on different server so I used mysql dump command to backup the database by using username root and now during restoration on different server what is the username and password I need to use.
2)If I have created a new empty database on new server so can I restore old database on this new database.