Can anyone tell me why i am getting this error whilst trying to restore this database from my old site to a new site?
Did you try to read the error? It says table calendarmoderator already exists. First delete this table from the database and then try again to restore the database. Before deleting the table, make sure you don't need its data.