how to take mysql database structure backup

Answer Posted / anil alpati

mysqldump --no-data --databases <dbname> > structurebackup.sql

Is This Answer Correct ?    4 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does mysqli_fetch_assoc do?

659


How to get last inserted id after insert data from a table in mysql?

739


What are stored procedures and functions?

652


What is blob storage?

677


Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?

4395


If we use sum function in mysql, does it return sum of that row or for that column?

707


What is the difference between mysql_fetch_assoc and mysql_fetch_array?

692


How to define numeric 9(3) in db2 table without decimal point??

2601


How do I connect to mysql database?

694


What is inner join in mysql?

631


What is csv?

689


What does tinyint mean?

684


What is difference between unix timestamp and mysql timestamp?

717


What are the non-standard sql commands supported by 'mysql'?

691


What are mysql data types?

727