how to take mysql database structure backup

Answer Posted / rupa bagherwal

mysqldump -uusername -ppassword databasename --no-data >
backupfilename.sql

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the functions of commit and rollback statements?

725


What is a tinyint in mysql?

673


What is the use of count function in mysql?

738


How to add a new column to an existing table in mysql?

742


What is the difference between mysql and pdo?

671


How you will Show unique records.

748


What is the data type for image?

803


What is latest version of mysql?

728


What are the different data types in mysql?

668


What is regex in mysql?

734


What is the password of mysql?

687


What is the difference between heap table and temporary table?

844


What is mysql command line?

697


How to change the database engine in mysql?

655


How many entries can mysql handle?

722