--one-database not working

[Alessio Vitale]

Hi all,
i tried to restore a db from a full mysqldump backup.
These is my backup command:

mysqldump -uroot -ppassword --all-databases --single-transaction --flush-logs > C:\alldb.sql

When a try to restore only a db mysql ignore this option and it restore all dbs in my dump

command:

mysql --uroot -ppassword --one-database mydbname < C:\alldb.sql

I tried this too

mysql --uroot -ppassword --database mydbname < C:\alldb.sql

or

mysql --uroot -ppassword mydbname < C:\alldb.sql


Nothing changes.

My server runs windows vista and mysql 5.1 with innodb as default storage engine.


Thank you in advance



Edited 3 time(s). Last edit at 02/11/2010 04:52PM by Alessio Vitale.