Re: Rename InnoDB database

luck. - Ding Hao/Fire9 DB Architect Emailmsngtalk: fire9di...@gmail.com My Blog:http://www.fire9.cn My Twitter: http://twitter.com/fire9 在 2009-4-7，上午12:20， Shuly Avraham 写道： Hi, I need to rename a database having InnoDB tables. MySQL

Rename InnoDB database

Hi, I need to rename a database having InnoDB tables. MySQL version is: 5.0.24-standard - so I cannot use the 'mysqladmin rename' option. What would be the best approach for doing this? Thanks, Shuly. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

mysqlimport huge table

Hi, I have a huge table with about 50 millions of rows. I dumped the table using mysqldump -T , as text dump, and now trying to import it to a database on another server, but it keeps hanging. Are there any options or server variables I can set to help out with it? Thanks, Shuly. -- MySQL

Re: mysqlimport huge table

-large-files-safely-into-innodb-with-load-data-infile/ On Tue, Feb 24, 2009 at 1:08 PM, Shuly Avraham sh...@cshl.edu wrote: Hi, I have a huge table with about 50 millions of rows. I dumped the table using mysqldump -T , as text dump, and now trying to import it to a database on another server