> From: Orlando Andico <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > > Define "convenience?"
'xcopy' backup of individual database and index files. With InnoDB tables you have to preallocate a single xxx MB file for all your databases. > I used to use MySQL a lot in the past, and about the only feature in MySQL > table handling that I miss is a "rename column" feature. > > But "rename column" or "drop column" usage is a symptom of bad data > design, so lack of this functionality is not a killer. Drop and rename column been available for quite some time now. I find some of the MySQL justifications for lack of certain functionality unbelievable. Using temporary tables or some of the gross hacks illustrated in the MySQL manual to make up for subselects makes your SQL code become unwieldy quickly. I can't imagine not having drop and rename column functionality either - that is so basic. > Besides, there's no point comparing Oracle and MySQL. Different > tools for different jobs. Considering Oracle keeps touting their database as web-ready, I'm not surprised why MySQL AB would want to compare the two. I've met clients who insist on using Oracle for the simplest stuff (and wasting huge amounts of money) simply because they've been bamboozled by Oracle marketing. With InnoDB, MySQL comes closer to providing what other databases have been offering for a long time already. _ Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph To leave: send "unsubscribe" in the body to [EMAIL PROTECTED] To subscribe to the Linux Newbies' List: send "subscribe" in the body to [EMAIL PROTECTED]
