xferring data from tables with different names

Hangin' Around Joined: Aug 02, 2004 Posts: 36

Ok I have a couble different domain names, and my webhost tacks on a mandatory prefix before the database name for example

Fred_tablename and Mary_tablename

Where fred and mary would be the domain names. If I wanted to set up a nuke site for testing on one of those and then move it over to the other domain when I had it up and working, I would have to be able to load the db as well unfortunately its impossible to choose the same name due to their d***ed naming conventions. So I guess my quesition is....Can I take a nuke db named xxx_table and import it into another db named yyy_table using phpmyadmin and not have any problems?

Thanks
FuZZy

Posted: Fri Aug 13, 2004 6:54 pm

I'd make a backup of it and use a search and replace to set all the prefixes back to nuke_ or what ever and then import it to the new database so you don't run into trouble with it when it adds the new domain prefix to it.