I created a sql file for database sfg as follows: mysqldump -uuser -ppassword sfg > backup.sql
Then I tried to reload it in another database sfg2 mysql -uuser -ppassword sfg2 < backup.sql I get the error message saying the table already exists. I traced the error to the lines where the views have the same identifier as the tables. I don't know if it is possible to have views and tables the same identifier. I didn't create these views. Can someone please help me figure this out? Thanks Murthy __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com