I think so. When I run ls -l /var/run/mysqld/
I get total 0 srwxrwxrwx 1 mysql mysql 0 2010-08-29 14:45 mysqld.sock On Sun, Aug 29, 2010 at 4:02 PM, Sabika Gmail <sabika.makhd...@gmail.com> wrote: > 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