Using Sqls

[soulreapor]

Can someone explain me the process of dumping an sql. I dumped the chrispee database and all that worked and i got my server running. My problem is how do you add to that database because anytime i dump additional sqls such as illidan's mall to the chrispee database i get an error message.

[Le Froid]

The message is...?

[soulreapor]

There was an error while executing a query.
The query and the error message has been logged at:
C:\Users\jhatsa\AppData\Roaming\SQLyog\sqlyog.err.
Please click on "Open Error File..." to open the error file.
When i open it says Error occured at:2007-12-23 22:19:10
Line no.:26
Error Code: 1050 - Table 'account_data' already exists

Query:
CREATE TABLE `account_data` (
and whole bunch of other errors but mainly repeats that account data already exists

also Error Code: 1109 - Unknown table 'account_data' in information_schema

[Saedusii]

Go into the SQL file, and remove all of the CREATE TABLE SQL queries and remove all of the CREATE TABLE queries, because you already have executed that query. (That is if you have somehow managed to merge two sqls. >.<)

Make sure you are actually clicking on the right .sql file.

[latruwski]

dont use dump to sql file if you wnt to add it to other DB...do "export data"
and make sure the entryIDs are not the duplicated!

grtz