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

How does mysql clustering work?

485


How to find the unique values if the value in the column is repeated?

560


how to add a new column to an existing table?

565


How to delete a table.

518


How to rename an existing table in mysql?

540






How to delete the repeated records from a table?

507


How to Join tables on common columns.

648


Explain the storage engines in mysql?

530


What is mysql command line?

506


How many TRIGGERS are allowed in MySql table?

587


What is unique key in mysql?

515


using primary can we relate two table, with out foreign key?

2295


Why mongodb is faster than mysql?

473


Why does mysql have so many connections?

491


How do I fix a crashed mysql database?

495