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 is the use of mysqli_fetch_array?

484


How to get a list of columns in an existing table?

500


Can you tell the difference between mysql_connect and mysql_pconnect? : Mysql dba

495


What is the size of mysql database?

495


How can I remotely connect to mysql database?

452






How can you count the total number of records of any table?

508


How MySQL Optimizes DISTINCT?

617


What data structure does mysql use?

585


How many rows can mysql handle?

510


Is sqlite faster than mysql?

496


Explain triggers and stored procedures?

500


how we will Show selected records sorted in an ascending (asc) or descending (desc).

551


What is the innodb in mysql?

508


How does mysql store data?

523


How do I disable mysql?

507