#1
  1. No Profile Picture
    sinha
    Guest
    Devshed Newbie (0 - 499 posts)
    Hello,

    Is there a script out there that can read the table schemas in a database and generate the ddl statements (create table ...)??

    Thanks.
  2. #2
  3. No Profile Picture
    rod k
    Guest
    Devshed Newbie (0 - 499 posts)
    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.

Similar Threads

  1. shell script that reads a file
    By chatguy2020 in forum UNIX Help
    Replies: 1
    Last Post: July 20th, 2003, 04:52 PM
  2. including an ssl perl script
    By karlos in forum Perl Programming
    Replies: 0
    Last Post: May 9th, 2003, 10:47 AM
  3. Perl script not running as cron
    By jkrew_devshed in forum Perl Programming
    Replies: 2
    Last Post: July 30th, 2002, 09:01 AM
  4. locking multiple DBs for entire execution of script
    By Matthew Doucette in forum MySQL Help
    Replies: 8
    Last Post: June 27th, 2002, 10:00 PM
  5. Advanced form processing - script required!
    By hansdampf in forum PHP Development
    Replies: 0
    Last Post: March 21st, 2001, 09:22 AM

IMN logo majestic logo threadwatch logo seochat tools logo