...

View Full Version : mysql dump



ynotlim
04-09-2007, 11:08 PM
hello,

I'm using MYSQL dump to back-up my database. What if i don't want the data inside the tables? How can i have it back up the tables but not the data?

currently i'm using:

mysqldump -h localhost -u tony -p test > test.sql

Thanks in advance

Tony

Fumigator
04-09-2007, 11:26 PM
Use --no-data. For a handy command reference, check out the manual:

http://dev.mysql.com/doc/refman/4.1/en/mysqldump.html



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum