utw-Mephisto
09-10-2005, 12:56 AM
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 ?
http://img259.imageshack.us/img259/2622/untitled6dg.jpg
like extended etc. ?
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 ?
http://img259.imageshack.us/img259/2622/untitled6dg.jpg
like extended etc. ?