Weird error when moving to another location

[utw-Mephisto]

Ok,

I was getting a dump file from the complete database via phpmyadmin.
As the database is quite big I got a lot of erros like

"ERROR 1153 at line 6441: Got a packet bigger than 'max_allowed_packet'"

After I increased the max_allowed_packet to 16MB instead of 1MB, I could insert the dump file via ssh almost without problems.

Now I have two questions :

1. When importing the dump file into the database, I get this error :

Query OK, 9 rows affected (0,00 sec)
Records: 9  Duplicates: 0  Warnings: 0
Query OK, 0 rows affected, 1 warning (0,01 sec)
Query OK, 0 rows affected, 1 warning (0,00 sec)
Query OK, 0 rows affected, 1 warning (0,00 sec)
Query OK, 0 rows affected, 1 warning (0,00 sec)
Query OK, 0 rows affected, 1 warning (0,00 sec)
Query OK, 79 rows affected (0,00 sec)
Records: 79  Duplicates: 0  Warnings: 0

Unfortunately it does not say what kind of error. Is there any log I can check ? I don't see any problems on the board so far, but warning is warning imho.

2. When exporting the dumpfile using phpmyadmin, which options do I use ?



like extended etc. ?

[Marco van Herwaarden]

You problem is that some information was already inserted into the database the first time. When you tried again with SSH, there where duplicate rows.

You should start with an empty database, or select 'Add DROP TABLE' when creating the export.

[utw-Mephisto]

1. What do I have to chose in the data section ? Complete inserts or extended >?

2. I DID use an empty database. I just created the database a step before the import