Re: SQL Update 2.6.0 -> 2.6.1
Murray, SM,
Perfect time for backup/restore training :-)
mysql> use opendkim
Database changed
mysql> ALTER TABLE messages ADD KEY(msgtime);
Query OK, 268 rows affected (0,11 sec)
Records: 268 Duplicates: 0 Warnings: 0
- looks goood
- drop database opendkim
- mysql -p < backup
- database restore is really simple :-)
mysql> use opendkim
Database changed
mysql> ALTER TABLE messages DROP PRIMARY KEY, ADD PRIMARY KEY(reporter,jobid, msgtime);
ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be
defined as a key
The winner is MURRAY!
Andreas
Received on Thu Jun 28 2012 - 05:12:15 PST
This archive was generated by hypermail 2.3.0
: Mon Oct 29 2012 - 23:20:40 PST