PDA

View Full Version : phpMyAdmin Question


DarkWarriorXII
02-25-2004, 08:31 PM
In phpMyAdmin, how do you change a table name?

DarkWarriorXII
02-25-2004, 09:07 PM
Well I figured out how, but there's another problem. I want to change two tables' names (_ronmembers and _scriptsmembers) to _mainmembers. But there is already a table with that name. I want all 3 tables to share the same contents. How can I make them all have _mainmembers. It's hard to explain, since I'm new at this. But I have 3 IPB forums. I want two forums (one with a _ron prefix and another with a _scripts prefix) to share the members table with the main forums (prefix _main). Someone said to: rename _scriptsmembers and _ronmembers and rename them to _mainmembers. But since _mainmembers already exists I can't change the other table names so they share the same contents. I'm so lost....

Viper007Bond
02-26-2004, 01:55 PM
Export the two tables. Open up the files and take the INSERT area(s) from one file and put it into the other.

Delete the exsisting table and then import the file that contains the data for both tables.