Moving Table

[kingram]

I was trying to move a table from one of my DB to another one. but I could not find any operation section after choosing my table. can any body suggest me how to do that?!

Shahram

Edited May 8, 2005 by kingram

[TweezerMan]

I'm not sure what page you're looking at when you say "after choosing my table", so I'll start from the beginning in phpMyAdmin:

 

1) Select the database containing the table you want to move from the drop-down box on the left side of the page.

 

2) Select table you want to move by clicking its link on the left side of the page.

 

3) You should see the structure of the table you want to move, and a list of tabs going across the page above the structure. Click on the "Operations" tab.

 

4) On this page you should see "Move table to (database.table):" for the third option. Select the database you want to move the table into from the drop-down, and optionally specify a different name for the table in the new database, then click "Go".

 

Hope this helps...

[kingram]

Thank you.

I'm not sure what page you're looking at when you say "after choosing my table", so I'll start from the beginning in phpMyAdmin:

 

1) Select the database containing the table you want to move from the drop-down box on the left side of the page.

 

2) Select table you want to move by clicking its link on the left side of the page.

 

3) You should see the structure of the table you want to move, and a list of tabs going across the page above the structure.  Click on the "Operations" tab.

 

4) On this page you should see "Move table to (database.table):" for the third option.  Select the database you want to move the table into from the drop-down, and optionally specify a different name for the table in the new database, then click "Go".

 

Hope this helps...

<{POST_SNAPBACK}>