Manish Popli 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..... > > If you ran the sql file before and it failed with some error you might want to drop and recreate the database, since an error encountered after creation of the table would have left the table created but not executed the sql file completely
Manpreet _______________________________________________ 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/