Winanjaya wrote:
Dear MySQL Experts,
I am using MySQL 4.1, I have a database with more than 100 tables inside, is
there any 3rd party tools that can help me to create a SQL statement of
"CREATE TABLE blah blah blah" for each table in my DB . please advise
Regards
Winanjaya
mysqldump -d --add-drop-table=0 -n -u USERNAME -p DATABASE
Replace USERNAME & DATABASE with your actual values.
For more options see: mysqldump --help
HTH,
Wolfram
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
