Re: Trying to open a big sql script

[Duncan Hill]

On Thursday 19 April 2007 15:53:54 molemenacer wrote:
> I am trying to change all the names of the database from mthosp to another
> name, is this possible?

Assuming you mean tables, not database (as mysqldump doesn't store the 
database name in the dump file [or at least never has for me]):

sed -e 's/mthosp/another_name/' < source.sql > dest.sql

mysql> rename table mthosp_1 to another_name_1, mthosp_2 to another_name_2
(Check the manual for syntax)