How do I change MySQL data folder and move data over on ubuntu 10.04?

2010-08-29 Thread chen jia
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

Re: How do I change MySQL data folder and move data over on ubuntu 10.04?

2010-08-29 Thread Sabika Gmail
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

Re: How do I change MySQL data folder and move data over on ubuntu 10.04?

2010-08-29 Thread chen jia
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

Re: How do I change MySQL data folder and move data over on ubuntu 10.04?

2010-08-29 Thread chen jia
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

Re: BLOB data gets encoded as utf8! (Anyone?)

2010-08-29 Thread Johan De Meersman
Is the code you use to get the data out in the same charset as the code you use to put the data in ? Both should ideally also match your database setting. Have you tried explicitly setting the connection to UTF8 ? Just swinging in the dark, here, really. On Sat, Aug 28, 2010 at 8:04 AM, Andreas