RE: MySQLDump - Command line password

2005-07-20 Thread anurag.dashputre
Hi, For confirming that password is shown or not in ps -ef, just try to connect to your server using your password ,then in a new window just do ps -ef --width 400 |grep mysql You will find the output like below which doesn't show the password -uroot -px xxx Atleast it is not showing in

RE: mysql prob.

2005-07-20 Thread anurag.dashputre
Hi Manish, How you r connecting to mysql. Just try the same way. What bugs keyword stand in the command. Perhaps you have to use mysqldump -S /tmp/mysql.sock2 -uroot Regards, Anurag -Original Message- From: Manish [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 20, 2005 12:14 PM To: mys

RE: Duplicate entry error

2005-07-02 Thread anurag.dashputre
Gleb, Thanks for your suggestions. I would like to know 1.How to send MySQL versions on master and slave. 2.Where I have to include output of 'SHOW SLAVE STATUS'. 3.How to Fix the problem if it does occurs. 4.How to restart the slave SQL thread with "SLAVE START". Thanks again for your help and c

Duplicate entry error

2005-06-30 Thread anurag.dashputre
Hi all, I am getting duplicate entry error while inserting data in the table. My table name is TEMP and it contains only one field which is primary key ,nt null as well as auto increment . 050628 16:05:00 Slave: Error 'Duplicate entry '77' for key 1' on query 'INSERT INTO TEMP VALUES ()'. Defau

RE: Could not initialize master info structure, check permisions on master.info

2005-05-30 Thread anurag.dashputre
FYI -Original Message- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: Sunday, May 29, 2005 5:18 PM To: mysql@lists.mysql.com Subject: Re: Could not initialize master info structure, check permisions on master.info Hello. Are you restoring the database on the running slave? Wha

Could not initialize master info structure, check permisions on master.info

2005-05-28 Thread anurag.dashputre
Hi Everybody, I am new to the list,infact this is my first mail to the list. Ok here goes the query :- While restoring the database from backup, I am getting the following error. " ERROR 1201 at line 1: Could not initialize master info structure, check permisions on master.info " . I am doing