Hi all, I don't know if this is a bug in mysqldump but it behaves in a strange way. I tried to use mysqldump to dump out the data and structure of a small database in order to populate another database but not all records are dumped. I tried to flush the tables from mysql server using FLUSH TABLES and also use mysqlamdin to refresh the database(by flushing tables & the log files) but records are still missing from the dumped file. I have tried to shutdown and restart the database server but that didn't help. Is this a bug in mysqldump or there is some other things I have to do to get mysqldump dumps out the entire database with DDL & DML statements? Thank you very much for your help. --Regards, Huy. __________________________________________________ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php