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)

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.