Hi Manish,

The error says that the socket file /tmp/mysql.sock does not exist. To
recreate the socket, simply restart the mysql server.

Once this socket is made, your backup will start running again.

The location of this socket file can be edited in /etc/my.cnf

Regards

Subhasis

On 4/21/06, Manish Popli <[EMAIL PROTECTED]> wrote:
>
> Hi All,
>
> I m using myql on linux box and used to run it through
>
> #cd /usr/local/mysql/bin
>
> #./safe_mysqld --max_allowed_packet=32M &
>
> and for backup i used to run this command
>
> [EMAIL PROTECTED] bin]# /usr/local/mysql/bin/mysqldump bugs -uroot  >
> /home/manish/bug_bkp.sql
>
> Earlier it was working fine but now its give such error..
>
> /usr/local/mysql/bin/mysqldump: Got error: 2002: Can't connect to local
> MySQL server through socket '/tmp/mysql.sock' (111) when trying to connect
>
> How can i retrive my backup...
>
>
>
> --
> Manish Popli
> _______________________________________________
> ilugd mailinglist -- ilugd@lists.linux-delhi.org
> http://frodo.hserus.net/mailman/listinfo/ilugd
> Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi
> http://www.mail-archive.com/ilugd@lists.linux-delhi.org/
>
>
_______________________________________________
ilugd mailinglist -- ilugd@lists.linux-delhi.org
http://frodo.hserus.net/mailman/listinfo/ilugd
Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi 
http://www.mail-archive.com/ilugd@lists.linux-delhi.org/

Reply via email to