|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
copying tables from a database
hi all,
i am not too sure if i should post this question here but anyway, here goes. in phpmyadmin, i have two databases with database 1 and database 2. now database 1 has a tblmembers that would be needed in database 2. how do i copy that tblmembers from database 1 to database 2 with the exact fields that tblmembers have in database 1? i was told of a GUI that can do that. or is by code?can some one pls help.thank you. |
|
#2
|
|||
|
|||
|
RE: copying tables from a database
You can do this in the phpmyadmin.
Select the table you want to copy. Then click on export link. Export SQL, check both complete and extended inserts. Now click on Go button and you will get a new page with all data from your table. Copy this, change you databases, click on SQL and paste it into the field. That's all. If you have a shell access then it is possible to copy the table files and then type phpadmin flush-tables... |
|
#3
|
|||
|
|||
|
RE: copying tables from a database
There is an easier way to do it, if you go to the db that holds the table you want to move, and view the structure of that table, you will see a tab at the top called 'Operations' select that tab and a few lines down you will see 'Copy Table to (database.Table). Select the database you want to copy to in the dropdown, type in a table name, then select the Structure and Data radio button. Click Go and the table will be copied to the selected DB.
|
|
#4
|
|||
|
|||
|
RE: copying tables from a database
It seems there is always an easier way to do things.
|
|
#5
|
|||
|
|||
|
problem resolved
thank you ashkan and blindeddie...it worked...
|
![]() |
| Viewing: Codewalkers Forums > Other Technologies > Database Help > copying tables from a database |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|