Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2009

    Unanswered: Generate script for Database and tables in MySQL

    Hello there,

    How can I generate script for MySQL database and tables.
    I want to run it on another MySQL instance so that to have the same database schema.

    Do we have anything like MS SQL Server Generate Script Wizard in MySQL?

    Thank you!

  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    yeah, it's called mysqldump and it comes with the product

    alternatively, every front end app (phpmyadmin, sqlyog, hiedisql, etc.) has this functionality, usually under the Export file menu | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts