Renaming db and schema?

[John Lester]

Ok so we're not supposed to use the rename command (I get errors anyways :D ) so how do you rename the db and schema from an old host to conform with the new host?

IE old host db name = forum new host = example1_dbnamehere

[Lynne]

Just import the old database contents into a new database that you named yourself?

[John Lester]

Yea supposed to go that way, but the target db retains the paths of the source db (which of course are different since the hosts are different).

I can manually change the paths ... that's a low priority ooopsie compared to the others :(