Re: SQL Update 2.6.0 -> 2.6.1

From: Andreas Schulze <sca_at_andreasschulze.de>
Date: Thu, 28 Jun 2012 07:11:50 +0200 (CEST)

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