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
MySQL dump plus rename tables
MySQL dump plus rename tables
Webdesign from Düsseldorf - made with phpwcms (most of it):
http://eyelikeit.com/index.php?de_beispiele-webdesign
http://eyelikeit.com/index.php?de_beispiele-webdesign
- Oliver Georgi
- Site Admin
- Posts: 9892
- Joined: Fri 3. Oct 2003, 22:22
- Contact:
Hi Oliver - thanks for the hope:
PHPMyAdmin is open. I have 5 Tabs: Struktur, SQL, Export, Search, Query. Where and how do I rename the tables?
Thanks a lot!
Macangelo
PHPMyAdmin is open. I have 5 Tabs: Struktur, SQL, Export, Search, Query. Where and how do I rename the tables?
Thanks a lot!
Macangelo
Webdesign from Düsseldorf - made with phpwcms (most of it):
http://eyelikeit.com/index.php?de_beispiele-webdesign
http://eyelikeit.com/index.php?de_beispiele-webdesign
Found it!
Webdesign from Düsseldorf - made with phpwcms (most of it):
http://eyelikeit.com/index.php?de_beispiele-webdesign
http://eyelikeit.com/index.php?de_beispiele-webdesign