We have 2 servers, one of which is a Master and the other which is a Slave. We tell the Master that it should keep a log of every action performed on it. We tell the slave server that it should look at this log on the Master and whenever something new happens, it should do the same thing.
You should follow the instructions below with two console windows open - one for the Master and one for the Slave.
Step 1:
First of all, we need to create a user on the Master server that the Slave will connect as. Say 'slave_user'....
Friday, October 22, 2010
Show databases
in MySQL
Here we will discuss how to show databases from command prompt.
Here is the syntax.
mysql> show databases;
+--------------------+| Database |+--------------------+| information_schema || mysql || test || wordpress |+--------------------+4 rows in set (0.37 sec)
mysql&g...
Friday, October 22, 2010
Login to MySQL from Command prompt
in MySQL
Here is the steps to start MySQL from command prompt in windows.1. Click on start and go to programme.2. Select MySQL and go for "MySQL command line client" under mysql <your mysql version>.3. MySQL command prompt will be open asking you for password.
4. Enter the password.5. Now you should see something like..
Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 6...
Friday, October 22, 2010
Lets start with MySQL
in MySQL
Here we will discuss about MySQL from beginning till the very complex scenarios.We are going to cover each and every aspects of MySQL in depth.
1. Data types2. MySQL Engines3. Stored procedure4. Functions5. Transactions6. Writing complex queries.7. Query optimization.8. Use of third party open source pluggin.9. Use of Popular full text search engine "Sphinx".10. Dealing with millions of data.11. Case studies.
I am looking forward for your support.'Than...
Subscribe to:
Posts (Atom)
Posts
