Results 1 to 3 of 3

Thread: clone database

  1. #1
    Join Date
    Apr 2014
    Location
    coimbatore
    Posts
    5

    Unanswered: clone database

    Dear friends,
    I am using mysql workbench 6.0.Now i wanna copy one database and its all objects without its data into newly created database.

    so please tell how to resolve this problem using mysql query or stored procedure.

    Thanks in advance.

  2. #2
    Join Date
    Apr 2014
    Posts
    1
    is there any export option if yes than through this you can save your database..

    click through the following article
    Last edited by rickeysanderson; 04-28-14 at 00:05.

  3. #3
    Join Date
    Feb 2012
    Posts
    44
    you can do this easy on CLI with mysqldump

    The --no-data option tells mysqldump not to dump table data, resulting in the dump file containing only statements to create the tables.

    example:

    Code:
    mysqldump --no-data test > dump-defs.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
  •