HELP!! Copying Structure and Data

[figment]

CREATE TABLE 'NewTableName' SELECT * FROM 'OtherTableName'

This works for copying data and MOST structure, but I noticed that it DOESN'T copy structure as far as which fields are primary keys, and auto-increments.. anyway to do this? Its rather important.

P.S. - I'd like to avoid using mysqldump if at all possable.

[jeremuck]

huh? why?

anyway there are php functions that will tell you what kind of field it is...

you can discover a fields property and then construct an apropriate SQL statement to create/alter a new one.

[tha_mink]

you could use mysql_hot_copy.

[figment]

what is mysql_hot_copy?

[tha_mink]

RTFM

http://www.mysql.com/doc/en/mysqlhotcopy.html