I have Mysql database. I want to take only the skeleton of my database i.e.I want only the scripts to create Database and tables. Not the entire database back up which comes with database structure and data.
Please Help me. I Use Mysql 5.0
3 Answers
From MySql export schema without data:
You can do with the
--no-dataoption withmysqldumpcommandmysqldump -u root -p --no-data dbname > schema.sql
Jim helpfully contributes:
consider using the
--single-transactionoption if you don't want or can't do table locks.
Comments
Here is my summary about mysql dumping commands, hope to help you
backup the entire database
mysqldump -uroot -p db_name > /home/bob/my.sql
backup single table
mysqldump -uroot -p db_name table_name > /home/bob/table.sql
backup only database structure,
mysqldump -uroot -p db_name -d > /home/bob/structure.sql
backup only database data
mysqldump -uroot -p db_name -t > /home/bob/data.sql
How to execute the exported sql file? See the following
mysql -uroot -p db_name < /home/bob/my.sql
another way, Log into mysql, then
mysql> use db_name;
mysql> source /home/bob/my.sql;
