September 10th, 1999, 09:57 AM
Is there a script out there that can read the table schemas in a database and generate the ddl statements (create table ...)??
September 10th, 1999, 01:12 PM
Check out mysqldump (included in your mysql distribution). It dumps a db into a text file with the table create statements and inserts to recreate a table. Check mysqldump help to see if you can have it only dump the table create statements (I think you can) if not, it shouldn't be too big of a hassle to strip out the inserts.