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

    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
    Location
    Toronto, Canada
    Posts
    20,002
    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
    rudy.ca | @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
  •