List:General Discussion« Previous MessageNext Message »
From:chen jia Date:August 30 2010 1:08am
Subject:Re: How do I change MySQL data folder and move data over on ubuntu 10.04?
View as plain text  
After I run sudo mysqld, I run sudo /etc/init.d/mysql start and check
the syslog by running sudo tail -f /var/log/syslog, the output is

Aug 29 21:05:42 hpdesktop kernel: [27909.007727] type=1505
audit(1283130342.751:150):  operation="profile_replace" pid=9994
name="/usr/bin/evince-previewer"
Aug 29 21:05:42 hpdesktop kernel: [27909.008358] type=1505
audit(1283130342.751:151):  operation="profile_replace" pid=9994
name="/usr/bin/evince-thumbnailer"
Aug 29 21:05:42 hpdesktop kernel: [27909.214193] type=1505
audit(1283130342.959:152):  operation="profile_replace" pid=10004
name="/usr/lib/cups/backend/cups-pdf"
Aug 29 21:05:42 hpdesktop kernel: [27909.214394] type=1505
audit(1283130342.959:153):  operation="profile_replace" pid=10004
name="/usr/sbin/cupsd"
Aug 29 21:05:43 hpdesktop kernel: [27909.277634] type=1505
audit(1283130343.018:154):  operation="profile_replace" pid=10007
name="/usr/sbin/mysqld"
Aug 29 21:05:47 hpdesktop init: mysql post-start process (9910)
terminated with status 1
Aug 29 21:05:47 hpdesktop kernel: [27914.103805] __ratelimit: 3
callbacks suppressed
Aug 29 21:05:47 hpdesktop kernel: [27914.103808] type=1505
audit(1283130347.848:156):  operation="profile_replace" pid=10043
name="/usr/sbin/mysqld"
Aug 29 21:05:48 hpdesktop init: mysql main process (10047) terminated
with status 1
Aug 29 21:05:48 hpdesktop init: mysql main process ended, respawning

Does this help? Please help me identify the problem.

Best,
Jia

On Sun, Aug 29, 2010 at 4:18 PM, chen jia <chen_1002@stripped> wrote:
> 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.makhdoom@stripped>
> 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_1002@stripped> 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=1
>>>
>>
>
Thread
How do I change MySQL data folder and move data over on ubuntu 10.04?chen jia29 Aug
  • Re: How do I change MySQL data folder and move data over on ubuntu 10.04?Sabika Gmail29 Aug
    • Re: How do I change MySQL data folder and move data over on ubuntu 10.04?chen jia29 Aug
      • Re: How do I change MySQL data folder and move data over on ubuntu 10.04?chen jia30 Aug