Agelmar
YaBB God
Posts: 931
Takako Matsu = Goddess
|
 |
SQL Error
« on: December 23, 2001, 06:57:59 AM » |
|
Okay, I screwed up my test database, and am trying to do a restore (I did a nice big dump, with a crapload of SQL queries to restore a DB).
Anyhow, I'm trying to restore my DB, and here's what I get (at end because it's long). I'm a MS SQL person, so I'm not quite sure what's going on, but I'm assuming it's some sort of timeout. Would someone mind telling me what variable I need to change in my my.cnf file, and what to change it to? Anyhow, here's the log:
mysql> use yabbse
Database changed
mysql> \. c:/inetpub/wwwroot/scmillrep.sql
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 7 rows affected (0.02 sec)
Records: 7 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.02 sec)
Query OK, 2 rows affected (0.00 sec)
Records: 2 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.02 sec)
Query OK, 216 rows affected (0.03 sec)
Records: 216 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 20 rows affected (0.02 sec)
Records: 20 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.01 sec)
Query OK, 175 rows affected (0.01 sec)
Records: 175 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.02 sec)
Query OK, 21 rows affected (0.02 sec)
Records: 21 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.01 sec)
Query OK, 5 rows affected (0.00 sec)
Records: 5 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.02 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 45 rows affected (0.01 sec)
Records: 45 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.02 sec)
Query OK, 10 rows affected (0.02 sec)
Records: 10 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.01 sec)
Query OK, 268 rows affected (0.09 sec)
Records: 268 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.02 sec)
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 5
Current database: yabbse
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 6
Current database: yabbse
ERROR 2006: MySQL server has gone away
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 7
Current database: yabbse
Query OK, 0 rows affected (0.20 sec)
Query OK, 0 rows affected (0.02 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.02 sec)
Query OK, 11 rows affected (0.00 sec)
Records: 11 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.02 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 35 rows affected (0.00 sec)
Records: 35 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.02 sec)
Query OK, 374 rows affected (0.06 sec)
Records: 374 Duplicates: 0 Warnings: 0
mysql> quit
thanks in advance.
|
Author