Copying SQL tables?

[Guest_imported]

Hi im pretty new to using MySql and have edited a php module. The trouble is in order to get my module working i need to create the same MySQL fields and content in the new tables.
For example, Original table was "links_catagories" i now need to create "clubs_catagories" with ecatly the same information as in the "links_catagories" table.
At the minute I am using phpMyAdmin.
Is there a way to do what I need without going through each of the old fields manually copying them out to text and back into the database in a new section as this will take hours to do all of my tables & fields.

Thanks In Advance

Nathan Gray - JuniorRugby

 

[piti]

hi

there is such feature

description for phpMyAdmin 2.3.0-rc3

1. select you database
2. select table to copy
3. click Operations in the right pane
4. use the Copy table to (database.table) option

or phpMyAdmin 2.2.0pre5

steps 1. and 2. are the same
3. again Copy table to feature