MySQL dump plus rename tables
Posted: Thu 10. Jun 2004, 17:22
Hi
some weeks ago I did 2 pro bono web sites. To save money of the client I put both sites into one phpwcms. Now, since I learned that I can better arange that with "prepend table names" I want to do that bei prepending "et" and "vi".
For this I thought I need to export the MySQL-Database, duplicate it, prepend the table names of one copy with "et" and the tables of the other copy with "vi". Then I would import each copy to the empty database of my new installation and fine.
That's how I thought it out ( as you might have figured out allready you can't call me an MySQL-expert ). But: How do I rename the tables of my copies?
Thanks for any help or better solutions how to do that!
Macangelo
some weeks ago I did 2 pro bono web sites. To save money of the client I put both sites into one phpwcms. Now, since I learned that I can better arange that with "prepend table names" I want to do that bei prepending "et" and "vi".
For this I thought I need to export the MySQL-Database, duplicate it, prepend the table names of one copy with "et" and the tables of the other copy with "vi". Then I would import each copy to the empty database of my new installation and fine.
That's how I thought it out ( as you might have figured out allready you can't call me an MySQL-expert ). But: How do I rename the tables of my copies?
Thanks for any help or better solutions how to do that!
Macangelo