Re: InnoDB doubles size when converting from MyIsam

2009-09-12 Thread Arthur Meeks Meeks
2009/9/13 Dan Nelson > In the last episode (Sep 12), Arthur Meeks Meeks said: > > I have a database with about 1000 tables and 150GB. I have done a simple > > "for f in $(cat tables); do mysql -uuser -ppassword database_name -e > > "alter table $f engine=InnoDB;" ; done > > > > I took about 3 hou

Re: InnoDB doubles size when converting from MyIsam

2009-09-12 Thread Dan Nelson
In the last episode (Sep 12), Arthur Meeks Meeks said: > I have a database with about 1000 tables and 150GB. I have done a simple > "for f in $(cat tables); do mysql -uuser -ppassword database_name -e > "alter table $f engine=InnoDB;" ; done > > I took about 3 hours and everything went fine, but I

InnoDB doubles size when converting from MyIsam

2009-09-12 Thread Arthur Meeks Meeks
Hello, I have a database with about 1000 tables and 150GB. I have done a simple "for f in $(cat tables); do mysql -uuser -ppassword database_name -e "alter table $f engine=InnoDB;" ; done I took about 3 hours and everything went fine, but I just realised that the same database in another server i

Re: database design

2009-09-12 Thread Arthur Fuller
Storing it directly will cause problems when you want to add a new Article Type. IMO it's better to have an ArticleTypes table (AutoIncrement) and store its values in the ArticleTypeID column in the Articles table. A. On Sat, Sep 12, 2009 at 1:19 AM, AndrewJames wrote: > thank you all, i think >