Results 1 to 10 of 10

Thread: Backup restore error

  1. #1
    Join Date
    Oct 2004
    Location
    Rio de Janeiro - Brasil
    Posts
    183

    Question Backup restore error

    hello,

    I get this error when I try to restore a backup in a new server:

    Domain Created Successfully

    Error connecting to MySQL: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

    any help to fix that?

    thanks!
    WebHostingTalk now in portuguese -> www.webhostingtalk.com.br venha se juntar a nossa comunidade sobre hospedagem web

  2. #2
    Join Date
    Feb 2010
    Location
    Meerlo, The Netherlands
    Posts
    295
    From SSH

    Code:
    /etc/init.d/mysqld status
    If it shows something like:

    SUCCESS! MySQL running (1070)

    MySQL is at least running, so you might want to check your mysql logs (usually in /var/log/mysqld.log).

    If it does not, you could try:

    Code:
    /etc/init.d/mysqld restart
    And try the status step again. If it shows MySQL is running, try adding the domain again.

  3. #3
    Join Date
    Oct 2004
    Location
    Rio de Janeiro - Brasil
    Posts
    183
    hello,

    [root@srv8 /]# /etc/init.d/mysqld status
    ERROR! MySQL is not running, but lock exists

    [root@srv8 /]# /etc/init.d/mysqld restart
    ERROR! MySQL manager or server PID file could not be found!
    WebHostingTalk now in portuguese -> www.webhostingtalk.com.br venha se juntar a nossa comunidade sobre hospedagem web

  4. #4
    Join Date
    Feb 2010
    Location
    Meerlo, The Netherlands
    Posts
    295
    Code:
    lsof | grep mysql
    In addition, could you post your /etc/my.cnf as an .txt attachement?

    You might also want to try and remove the lock

    Code:
    rm -rf /var/lock/subsys/mysql
    Last edited by tomtom901; 10-16-2010 at 07:08 AM.

  5. #5
    Join Date
    Oct 2004
    Location
    Rio de Janeiro - Brasil
    Posts
    183
    I just add to the /etc/my.cnf file with the following data:

    [mysqld]
    socket=/var/lib/mysql/mysql.sock

    now I get:

    [root@srv8 etc]# /etc/init.d/mysqld status
    SUCCESS! MySQL running (11425)
    WebHostingTalk now in portuguese -> www.webhostingtalk.com.br venha se juntar a nossa comunidade sobre hospedagem web

  6. #6
    Join Date
    Feb 2010
    Location
    Meerlo, The Netherlands
    Posts
    295
    That would be my next guess. So, go ahead and try to restore the backup once more.

  7. #7
    Join Date
    Oct 2004
    Location
    Rio de Janeiro - Brasil
    Posts
    183
    The User files have been restored from /home/admin/user_backups

    @tomtom901 - thank you!
    WebHostingTalk now in portuguese -> www.webhostingtalk.com.br venha se juntar a nossa comunidade sobre hospedagem web

  8. #8
    Join Date
    Feb 2010
    Location
    Meerlo, The Netherlands
    Posts
    295
    Sweet, so all is well now?

  9. #9
    Join Date
    Oct 2004
    Location
    Rio de Janeiro - Brasil
    Posts
    183
    yes, up and running
    WebHostingTalk now in portuguese -> www.webhostingtalk.com.br venha se juntar a nossa comunidade sobre hospedagem web

  10. #10
    Join Date
    Feb 2010
    Location
    Meerlo, The Netherlands
    Posts
    295
    Quote Originally Posted by winger View Post
    yes, up and running
    Very nice, good luck!

Similar Threads

  1. backup restore error
    By knorde in forum General Technical Discussion & Troubleshooting
    Replies: 3
    Last Post: 02-11-2012, 11:51 PM
  2. Backup Restore error,
    By Cyber-DL in forum System-Level Technical Discussion
    Replies: 5
    Last Post: 09-22-2009, 09:23 AM
  3. Error 1060 on backup restore
    By philmcdonnell in forum MySQL / PHP
    Replies: 6
    Last Post: 12-14-2006, 11:40 AM
  4. Backup restore error
    By ChAtEr in forum Reseller-Level Difficulties
    Replies: 3
    Last Post: 05-06-2004, 12:49 PM
  5. Backup restore error
    By ChAtEr in forum Reseller-Level Difficulties
    Replies: 2
    Last Post: 02-29-2004, 01:30 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •