sed
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
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 wrote:
> Does your mysql sock file reside in the same location as the error?
>
>
>
> On Aug 29, 2010, at 12:20 PM,
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
MySQ
to:chen.1...@gmail.com] On Behalf Of chen jia
> Sent: Monday, April 05, 2010 11:07 AM
> To: mysql@lists.mysql.com
> Subject: Slow Union Statement
>
> Hi there,
>
> I run simple statement like this:
>
> create table c
> select * from a
> union
> select * from b;
>
Hi there,
I run simple statement like this:
create table c
select * from a
union
select * from b;
where table a has 90,402,534 rows, and table b has 33,358,725 rows.
Both tables have the same three variables.
It's taken a long time, more than half an hour now. How do I make it faster?
Best,
Ji
u, Aug 27, 2009 at 7:56 AM, Jia Chen wrote:
>>
>>
>> Chen, Did you really delete ibdata1 ?
>>
>>
>> Yes, I did.
>>
>> Best,
>> Jia
>>
>>
>> Claudio Nanni wrote:
>>
>>
>> 2009/8/26 chen jia mailto:chen.1...@gmail.com&
Hi there,
I am using MySQL on ubuntu 8.04.
I followed this link
http://www.ubuntu-howto.info/howto/how-to-move-mysql-databases-to-another-location-partition-or-hard-drive
to change the data directory of MySQL.
After stopping MySQL: sudo /etc/init.d/mysql stop
I make a new directory: sudo mkdir
