Hi, Is it OK by this? I expect that the export file will be backup.sql mysqldump --tables -u db_user_name -p db_name >> backup.sql Furthermore, is there any example for that we insert one record with one image file (from the local disk), to the DB table? Many Thanks & Best Regards, HuaMin Chen
Hi, Should be all right your command for backup. I'm using this command for backup my sql server: mysqldump --flush-logs -h %mysql_hostname% --lock-all-tables --databases --add-drop-database --user=%mysql_user_name% --password=%mysql_password% --log-error="%log_dir%\mysql_ldap.log" --dump-date mysql >"%mysql_backup_dir%\db\mysql.sql" For future information read the mysqldump documentation on mysql web site: http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html Rudolf