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) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]