Mysql-backup

using mysqldump with the command lock-tables doesn't lead to a consistent backup with innodb databases, and just works fine with myissam databases.

this command you can use to get a consistent backup C:\DOKUME~1\Admin> mysqldump -u root -p --skip-opt --single-transaction --add-drop-table --create-option --quick --extended-insert --set-charset --disable-keys --database testdbsm > backup.sql Enter password: ******

C:\DOKUME~1\Admin>