Re: Rename InnoDB database

[Shuly Avraham]

Thank you everyone for your solutions.
I have found one, which may be of use to you.
It relies on the ability to rename a table from one database to another:

mysql rename table old_db.tabname to new_db.tabname

You would first need to drop all triggers, then recreate them.

So, I placed these commands In a shell script:


old_db=$1;
new_db=$2;
mysql -B $old_db -e show tables | tail -n +2 | perl -pe s/^(.*)$/ 
rename table $old_db.\1 to $new_db.\1;\n/ |  mysql


Shuly.

On Apr 7, 2009, at 4:40 AM, Ding Hao wrote:


hi,

I have a solution. Please my blog's http://www.fire9.cn/?p=132.
good 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 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 unsubscribe:http://lists.mysql.com/mysql? 
unsub=fire9di...@gmail.com






Shuly Avraham
Gramene.org  Plantontology.org
CSHL Ware Lab
sh...@cshl.edu

___
Warelab mailing list
ware...@brie4.cshl.edu
http://brie4.cshl.edu/mailman/listinfo/warelab

Rename InnoDB database

[Shuly Avraham]

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 unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

mysqlimport huge table

[Shuly Avraham]

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 General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: mysqlimport huge table

[Shuly Avraham]

Thanks for the resource!

However, I am loading into a MyISAM table, while logging is disabled.

In a matter of fact, I was able to load the data at the end, after  
disabling the keys. But now, as I try to create the keys, it takes a  
huge amount of time. there are 250 Million rows in one of the tables.

My key_buffer_size is set to 4G, on a machine with 16G ram.

Are there any other system variable I could set in order to speed it up?

Thanks,
Shuly.

On Feb 24, 2009, at 5:17 PM, Baron Schwartz wrote:


Hello Shuly,

Try this.  http://www.mysqlperformanceblog.com/2008/07/03/how-to- 
load-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, but it keeps hanging.
Are there any options or server variables I can set to help out  
with it?


Thanks,
Shuly.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=ba...@xaprb.com






--
Baron Schwartz, Director of Consulting, Percona Inc.
Our Blog: http://www.mysqlperformanceblog.com/
Our Services: http://www.percona.com/services.html



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org