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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 mysql backup and restore
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

hanabowt
Starting Member

1 Posts

Posted - 04/25/2015 :  08:45:38  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

2780 Posts

Posted - 04/25/2015 :  09:45:21  Show Profile  Reply with Quote
wrong forum. This is for SQL Server
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2179 Posts

Posted - 04/26/2015 :  01:28:13  Show Profile  Visit jackv's Homepage  Reply with Quote
Check out : http://forums.mysql.com/

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

poalomon
Starting Member

1 Posts

Posted - 04/26/2015 :  14:45:50  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000