Does your mysql sock file reside in the same location as the error?
On Aug 29, 2010, at 12:20 PM, chen jia <chen_1...@fisher.osu.edu> wrote: > Hi there, > > I install ubuntu 10.04 (64bit) on my desktop and try to move my > existing MySQL data over. > > I first install MySQL on the new machine, and it can start and stop > fine. I decide to change the data folder from the default > (/var/lib/mysql) to /home/MyAccount/MySQLdata and move my existing > MySQL data to that directory. > > Because I used to use MySQL on my laptop and set the data directory on > a USB drive, my existing data is on the USB drive. I connect the USB > drive to the desktop and copy the old data folder to the new data > folder by using > sudo rsync -av /media/USBdrive/MySQLdata/ /home/MyAccount/MySQLdata. > > Then, I change the ownership of the new folder by using sudo chown > mysql:mysql /home/MyAccount/MySQLdata. > > Next, I edit /etc/mysql/my.conf and update the "datadir" to my new > directory. I also update /etc/apparmor.d/usr.sbin.mysql so that lines > with /var/lib/mysql are commented out and news lines with > /home/MyAccount/MySQLdata are added. I reload the apparmor by using > sudo /etc/init.d/apparmor reload. > > However, when I try to start mysql with sudo start mysql, it hangs. > When I try sudo mysqld and connect to mysql by using mysql -u root -p, > it complains: ERROR 2002 (HY000): Can't connect to local MySQL server > through socket '/var/run/mysqld/mysqld.sock' (111) > > Do you have any idea what I need to test and/or do to fix this problem? > Thanks. > > Best, > Jia > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=sabika.makhd...@gmail.com > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
