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!
- Oliver Georgi
- Site Admin
- Posts: 9574
- Joined: Fri 3. Oct 2003, 22:22
- Location: Moscow, Russia
$phpwcms["db_prepend"] = "myprefix";
PHPMyAdmin is open. I have 5 Tabs: Struktur, SQL, Export, Search, Query. Where and how do I rename the tables?
Thanks a lot!