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
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
=/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_1...@fisher.osu.edu
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,
] 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;
where table a has 90,402,534 rows, and table b has 33,358,725 rows
.
Best,
Jia
Claudio Nanni wrote:
2009/8/26 chen jia chen.1...@gmail.com 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
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