Jump to content

Recommended Posts

Posted (edited)

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 by kingram
Posted

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...

Posted

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...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...