Dump just the table structure to a file in MySQL
For this exercise, we will use the mysqldump utility the same as if we were backing up the entire database.
Syntax:
mysqldump -d -h localhost -u root -pmypassword databasename > dumpfile.sql
The only option that is different than creating an entire backup is the -d switch, which tells mysqldump not to output the data.
Example:
mysqldump -d -h localhost -u root -p2Uad7as9 database01 > dumpfile.sql
This article was originally written on 09/11/06
Daily Email Updates
You can get our how-to articles in your inbox each day for free. Just enter your name and email below:
–
–Use this to take only the Table structure of the database table in Linux –
On the terminal
[root@localhost ~]# mysqldump -uroot -proot123 -h200.200.200.12 mydatabasename tbl_mytable_name –no-data > /tmp/tbl_mytable_name_dump.sql
Remember , if u dont redirect it to a file, it will stores the dump at pwd by the name “oot”
Regards,
Girish
u can restore it in the database using ,,,,
mysql > source /path/to/a/dump/file
Thanks. It helps!
ok, say you have two dbs very similar in structure. one you use as a master template which goes through various revisions, let’s say we’re now on revision 3. but the second db is a copy of the template as it was at revision 1.
because db 2 is in use, you don’t want to drop any tables, but you do need to update the structure of the entire db to the latest version of db 1.
is there any method of doing this without having to manually go through and make all the same changes again and again (over many dbs at various versions) and without losing any of the data?