Hi i am able to use mysqldump as mysqldump --opt xyz >xyz.sql
i got the file xyz.sql. i put that file in 4.0.17 directory and ran bin/mysql -e "source path/xyz.sql" then it say's ' ERROR 1049: Unknown database 'xyz' if i try to create this database and try to run the command bin/mysql -e "source path/xyz.sql" xyz then error says cannot create table <table name> etc.with ERROR number 1005. what could be the reason for it with regards Naveen