hi, if you open up the bug_bkp2006-03-22.sql file, you might find that there are two instances where 'create table attachments' is present. this might be causing the prob.
Manish Popli <[EMAIL PROTECTED]> wrote: I am using mysql-standard-4.0.15-pc-linux-i686 version on red hat linux-9 its totaly fresh installation and i am new for mysql.. I want to restore database but while i m running the command.. *mysql -u root -p bugs < /home/manish/bug_bkp2006-03-22.sql* i m facing the error ...ERROR 1050 at line 11: Table 'attachments' already exists Can any one help me to overcome from this..... -- Manish Popli _______________________________________________ ilugd mailinglist -- ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi http://www.mail-archive.com/ilugd@lists.linux-delhi.org/ catch ya later (Ive gotta UnWire Life!!!) shiv --------------------------------- New Yahoo! Messenger with Voice. Call regular phones from your PC for low, low rates. _______________________________________________ ilugd mailinglist -- ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi http://www.mail-archive.com/ilugd@lists.linux-delhi.org/