MySQL Replication
Page moved to ,
MySQL DUMP
Command to backup all the MySQL database in single shot is ,
$mysqldump -u root -p –all-databases > alldatabases.sql
Command to restore the MySQL database is ,
( Please make sure that you have database created before you can restore the data )
$mysql -u root -p database_to_restore < alldatabases.sql
About Me
Dev
MCP , CCNA , RHCE , OCP , OCE ( RAC + Linux ) , SCSA
London
27-AUG-2008
My passion to Oracle started when i joined Oracle Corporation 3 years back.It was really great period of my life.It was pretty challenging for a person to learn Oracle without having knowledge of any RDBMS system but i started slowly and finally i got declared as Oracle DBA after 3 year of tenure with Oracle Corporation.
I consider my self as a learner and always thirsty to know more. Knowledge is one thing that excites me and I feel that it increases by sharing. So here is my blogs, dedicated to my friends across the globe, with whom I would like to share my experiences, and expects the same from them (Please give your comments !!!!). I promise that this blog is not just some cut and paste job and will always be based on my practical experiences.
-
Recent
- Data Guard Auto startup
- Alert.log Monitoring.
- Tier1 Rule Changes
- Menu Driver ORAENV
- HOW TO APPLY CPU JAN 2009
- Trouble shoot Out Of Memory Error for Oracle
- Users to roles and system privileges
- Enterprise Manager Grid Control ( OMS Problem )
- Data Guard Diagnostic Scripts
- NetApp Too many users logged in! Please try again later.
- MySQL Replication
- Data Guard Broker Setup for MAA Architecture
-
Links
-
Archives
- June 2009 (1)
- March 2009 (2)
- January 2009 (3)
- December 2008 (4)
- November 2008 (4)
- October 2008 (6)
- September 2008 (35)
- August 2008 (3)
-
Categories
-
RSS
Entries RSS
Comments RSS
