Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • How to export Schema without data in MySQL?

    • 0
    • 1
    • 0
    • 1
    • 0
    • 0
    • 0
    • 0
    • 277
    Comment on it

    Sometimes we need to export Schema without data means table structure only. We can do this easily by providing "--no-data" option in mysqldump command.

    Command:

    mysqldump -u root -p --no-data database_name > database.sql
    

    Example:

    mysqldump -u root -p --no-data jeeyoh > jeeyoh.sql
    

    by running above command we'll get flippadoo.sql which contains only table structures (without data).

    Hope this will help you :)

 0 Comment(s)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: