Database Error
Update on this issue. I ran a "use support" command, worked fine. Database changed.
Then I ran:
mysql> source /sqldump/dwise2_ostt1.sql
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, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
ERROR 1062 (23000): Duplicate entry '1' for key 'PRIMARY'
Query OK, 0 rows affected, 1 warning (0.01 sec)
ERROR 1054 (42S22): Unknown column 'isonline' in 'field list'
Query OK, 0 rows affected, 1 warning (0.00 sec)
ERROR 1054 (42S22): Unknown column 'can_append_signature' in 'field list'
Query OK, 0 rows affected, 1 warning (0.00 sec)
ERROR 1062 (23000): Duplicate entry 'support@d-wise.com' for key 'email'
Query OK, 0 rows affected, 1 warning (0.00 sec)
ERROR 1062 (23000): Duplicate entry '1' for key 'PRIMARY'
Query OK, 0 rows affected, 1 warning (0.00 sec)
ERROR 1054 (42S22): Unknown column 'cfg_id' in 'field list'
Query OK, 0 rows affected, 1 warning (0.00 sec)
ERROR 1054 (42S22): Unknown column 'dept_access' in 'field list'
Query OK, 0 rows affected, 1 warning (0.00 sec)
ERROR 1062 (23000): Duplicate entry '7' for key 'PRIMARY'
Query OK, 0 rows affected, 1 warning (0.00 sec)
ERROR 1062 (23000): Duplicate entry '1' for key 'PRIMARY'
Query OK, 0 rows affected, 1 warning (0.00 sec)
ERROR 1054 (42S22): Unknown column 'append_signature' in 'field list'
Query OK, 0 rows affected, 1 warning (0.00 sec)
ERROR 1062 (23000): Duplicate entry '338' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '603' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1095' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1599' for key 'PRIMARY'
Query OK, 0 rows affected, 1 warning (0.00 sec)
ERROR 1054 (42S22): Unknown column 'topic' in 'field list'
ERROR 1054 (42S22): Unknown column 'topic' in 'field list'
ERROR 1054 (42S22): Unknown column 'topic' in 'field list'
ERROR 1054 (42S22): Unknown column 'topic' in 'field list'
ERROR 1054 (42S22): Unknown column 'topic' in 'field list'
ERROR 1054 (42S22): Unknown column 'topic' in 'field list'
ERROR 1054 (42S22): Unknown column 'topic' in 'field list'
Query OK, 0 rows affected, 1 warning (0.00 sec)
ERROR 1054 (42S22): Unknown column 'file_size' in 'field list'
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
ERROR 1062 (23000): Duplicate entry '1' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '138' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '305' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '482' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '675' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1013' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '955' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1082' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1195' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1274' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1352' for key 'PRIMARY'
Query OK, 0 rows affected, 1 warning (0.00 sec)
ERROR 1062 (23000): Duplicate entry '1' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '324' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '561' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '820' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1070' for key 'PRIMARY'
Query OK, 0 rows affected, 1 warning (0.00 sec)
ERROR 1062 (23000): Duplicate entry '1' for key 'PRIMARY'
Query OK, 0 rows affected, 1 warning (0.00 sec)
ERROR 1062 (23000): Duplicate entry '1' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '208' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '468' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '722' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '933' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1105' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1258' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1409' for key 'PRIMARY'
Query OK, 0 rows affected, 1 warning (0.00 sec)
ERROR 1062 (23000): Duplicate entry '1' for key 'PRIMARY'
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
This is all very cryptic to me. Can somebody give me some advice? Basic basic basic! Thanks.