Thursday, January 26, 2012

HOW TO CONFIGURE FTP IN WINDOWS XP ?

Built-in FTP service doesn't install by default in Windows XP but for installation of FTP Service perform the following steps:
1.            Click the Start button àControl Panel à Add or Remove Programs.
2.            Click Add/Remove Windows Components.
3.            Select Internet Information Services (IIS) and then click Details.
4.            In the Internet Information Services (IIS) dialog box, select the File Transfer Protocol (FTP) Service check box and click OK.
5.            In the Windows Components Wizard dialog box, click Next. It prompts, insert your Windows CD. When the installation process is finished, you can use the FTP service with IIS.
Note:   i).         By default, the FTP server will have a root folder with the following path: C:\inetpub\ftproot.
            ii)         The FTP root folder acts as the root for your FTP server in the same way that C:\inetpub\wwwroot is the root for your Web server.

Tuesday, January 24, 2012

ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log

For resolving the problems follow below steps:

1.       Stop & Reset slave

mysql> stop slave;
mysql> reset slave;

2.       Change log position & master log file name

mysql> CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.0000xx', MASTER_LOG_POS=xxxx;

3.       Start slave

mysql> start slave;

4.       Check slave status

mysql> show slave status\G;

Output include below output:

Slave_IO_Running: Yes
Slave_SQL_Running: Yes