I am new to MySQL and I have some questions. I was able to make a backup of the
database using this command

mysqldump --opt --all-databases > backup.sql

Is this the correct way to backup all the databases? It does backup the database but it also gives me this error MYSQLDUMP: got error 1064 : you have an error in your SQL syntax near `` at line
1. Why?

Now I deleted one of the databases from MySQL using mysqladmin drop
<databasename>. Now I wanted to restore my backup to see if this works so I
tried

mysql < backup.sql

but this failed because some of the other tables / databases existed.

If you were going to just restore one database, could you delete all the other
database information out of that backup file and then just restore that?

Thanks Gretchen