restore from backup.sql

[rchee69]

sorry to bother you guys again, hehe. yet another stupid question. i did a backup of all databases using mysqldump --all-databases > /home/user/backup.sql

now i'm trying to restore, but it's giving me problems. i'm trying mysql -u root -p < /home/user/backup.sql but it keeps telling me some tables already exists. how do i tell it to overwrite what is already there if anything? the databases that are existing need to be overwritten since they contain old data. i've gotten this to work before, but of course i can't remember exactly what i typed in, argh!!!!!!!!. sure i'm just missing something stupid.

thanks all for your help

back to mysql man page - zzzzzzzzzzzzzzzzzzzzzz

[mikeatrpi]

Next time on the backup use --opt as well to add Drop statements. You need to log in and drop the old stuff.

DROP dbname;

to do it in one fell swoop, or per table:

DROP tablename;