1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

moving mysql (literally)

Discussion in 'Plesk for Linux - 8.x and Older' started by 1-mehmeh, Oct 29, 2007.

  1. 1-mehmeh

    1-mehmeh Guest

    0
     
    Greetings,

    I am attempting to move my MySQL database files, literally. I am not exporting my database to another server. I am moving the files themselves to another location on the same box

    I also want to change the path to mysql.sock

    Ive moved everything into /mysql and edited /etc/my.cfg accordingly.

    Unfortunately, I see two things happening.

    1. Despite the fact that I have also changed the path the mysql.sock inside the same /etc/my.cfg, certain items are still attempting to connect via the old socket location, and 2., this is occurring:


    Code:
    Starting xinetd service...  done
    Starting named service...                                            done
    Starting mysqld service...                                            done
    Starting qmail service...                                             done
    Starting courier-imap service...                                      done
    Starting postgresql service...                                        not installed
    Starting psa-spamassassin service...                               done
                                              
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    websrvmng: Unable to connect to Plesk Database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    System error 2: No such file or directory
    websrvmng: Unable to connect to Plesk Database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    System error 2: No such file or directory
    websrvmng: Unable to connect to the mysql database
    
    System error 2: No such file or directory
    websrvmng: Unable to connect to the mysql database
    
    System error 2: No such file or directory
    
    My /etc/my.cfg is edited properly, has the right paths, ..the directory that is holding the files is owned by mysql/mysql and has the proper permissions.

    Ideas?
     
  2. 1-mehmeh

    1-mehmeh Guest

    0
     
    actually, Ive tracked down the source of the file error...

    An ls-la of /var/lib/mysql shows me that the three innodb files were remade.. and because the horde and spamassasin directories were moved before, the files that would go in there cannot be remade.

    It would be immensely helpful to know EXACTLY what file is responsible for the configuration of all things Plesk.

    I should have added earlier that I did, in fact, edit /etc/psa/psa/conf and change the MySQL values:


    # MySQL
    MYSQL_VAR_D /mysql/data
    MYSQL_BIN_D /usr/bin

    and yet it remade files (in the wrong location)??

    How does one change the location of the MySQL database directory, if not through /etc/psa/psa.conf ?
     
Loading...