How to grab a tables structure in php?

[benj0323]

Firstly, thanks for your help.

Basically what I need to do is copy tables using my php file. So is there a way to grab the table structure and then put that structure in a mysql command and create the table?

Thanks a lot for your help.

[jatar_k]

are you just copying a single table at any given time or dumping the whole db?

I think both can be accomplished using mysqldump [dev.mysql.com]

I don't often dump individual tables but I was looking at --tables and it might do it. You would really have to look at all the options available to get the output you want.