MySQL Database Restore
I was get shock received a call from my colleague just now (it’s midnight now). I have to work 
He told me his MySQL database table corrupted or data lost. He need my help to restore the MySQL database back urgently.
1) First I stop the MySQL services /etc/init.d/mysqld stop
Read more
Possibly Related Posts:
- Boot gOS from USB Drive Experience
- Argument list too long
- Setup a Linux Highly Availability NFS servers
- How to find empty folders on Linux
- How to create full right permission on Samba share
How’s to Replicate MySQL
I’m creating “How’s to Replicate MySQL using master and slave in Linux” after successful implement on my server recently. I have existing MySQL running on port 3306 and the new copy of MySQL running on port 3307 with replicate master and slave
Introduction to Replication
MySQL features support for one-way, asynchronous replication, in which one server acts as the master, while one or more other servers act as slaves. This is in contrast to the synchronous replication which is a characteristic of MySQL Cluster
In single-master replication, the master server writes updates to its binary log files and maintains an index of those files to keep track of log rotation. The binary log files serve as a record of updates to be sent to any slave servers. When a slave connects to its master, it informs the master of the position up to which the slave read the logs at its last successful update. The slave receives any updates that have taken place since that time, and then blocks and waits for the master to notify it of new updates.
Read more
Possibly Related Posts:
- Boot gOS from USB Drive Experience
- Argument list too long
- Setup a Linux Highly Availability NFS servers
- How to find empty folders on Linux
- How to create full right permission on Samba share
SVN Manager
I believe a lot of people start using Subversion now a day. Do you have any problem for manage more that 1000 people or more using subversion? I suggest you try SVNManager (web based).
SVNManager is a web based tool to administer a Unix/Linux Apache WebDAV Subversion repository server.
With SVNManager, you can remotely:
- Create, remove, load and dump repositories
- Manage user accounts for access to the repositories
- Manage groups for acces to the repositories
- Invite users by email to create an account on the server
- Requirements:
- Windows or *nix Operation System
- Apache 2
- Subversion
- PHP 5 + Pear + VersionControl_SVN
- MySQL/SQLlite
Possibly Related Posts:
- Boot gOS from USB Drive Experience
- Argument list too long
- Setup a Linux Highly Availability NFS servers
- How to find empty folders on Linux
- How to create full right permission on Samba share