Sean Behan's Blog

Output .sql file for MySQL but without the drop table syntax before table name use the –skip-add-drop-table flag

mysqldump -u root -p database_name --skip-add-drop-table --skip-lock-tables > database_name.sql

Related posts:

1. Sample Rails Database Config for MySQL
2. Quick Syntax to Pipe an SQL Query Directly to a file
3. Managing Timestamps in MySQL with a Trigger
4. Fixing MySQL for Rails 2.2 Development on Mac OS X
5. mysql on rails 2.3.2