mysqldump -u [user] -h [host] -p [database] [table] > fixme.sql
This is for one table.As I need it for all my tables in all my databases, I'd have to write a script for that.
And as --tab uses less space, I prefer --tab option for mysqldump. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]