Re: Re-creating tables

2008-02-23 Thread mos
At 05:55 AM 2/23/2008, Waynn Lue wrote: I have three or four different ALTER TABLE commands I need to run on a 9 million row table (related to the previous email I sent). I've tried running it before and it just takes way too long, so I was thinking the fastest way to get this done is to create

Re-creating tables

2008-02-23 Thread Waynn Lue
I have three or four different ALTER TABLE commands I need to run on a 9 million row table (related to the previous email I sent). I've tried running it before and it just takes way too long, so I was thinking the fastest way to get this done is to create new tables with the final schema, then dro

Help with running MySQL 5 on OS X Leopard

2008-02-23 Thread Unnsse Khan
Hello there, I am running OS X Leopard on an Intel based iMac machine... Followed the instructions to a T and everything works as described in: http://hivelogic.com/articles/installing-mysql-on-mac-os-x/ Now, after running MySQL using launchd, when I try to login using: mysql -u root I get t

Help with running MySQL 5 on OS X Leopard

2008-02-23 Thread Unnsse Khan
Hello there, I am running OS X Leopard on an Intel based iMac machine... Followed the instructions to a T and everything works as described in: http://hivelogic.com/articles/installing-mysql-on-mac-os-x/ Now, after running MySQL using launchd, when I try to login using: mysql -u root I get t

Re: can't import

2008-02-23 Thread Thufir
On Mon, 16 Apr 2007 10:28:30 +1000, Chris wrote: > What did *you* do differently this time? > > Obviously the user is different, but what about permissions? What were > they before? 644 should have worked previously but since we don't know > what they were before we can't tell you. > > It has n