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.
| 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 restoreWhat 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 |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
|
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 |
|
|
|
|
|
|
mysql backup and restore