Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 mysql backup and restore

Author  Topic 

hanabowt
Starting Member

1 Post

Posted - 2015-04-25 : 08:45:38
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.

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-04-25 : 09:45:21
wrong forum. This is for SQL Server
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2015-04-26 : 01:28:13
Check out : http://forums.mysql.com/

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

poalomon
Starting Member

1 Post

Posted - 2015-04-26 : 14:45:50
Corruption in SQL server database can happen due to any uncertain like virus attack, power failure, hardware issue, OS malfunction, and sudden system shutdown, so on. When a SQL server data file (.mdf) is corrupt then DBAs can try several methods to repair and recover data from it.

• Run DBCC CHECKDB: It checks & reports all the error message in error log, if there is any problem with the database. Try to analyze & understand the error message logged in the error log. Re-run DBCC CHECKDB with the recommended minimum repair option to repair the file.
unspammed
Go to Top of Page
   

- Advertisement -