Aaron Stone wrote:
The command is mysqldump ;-)
mysqldump -d dbmail
to be precise.
I've attached clean table schema that do not contain any of the
redundant indexes, and add the new indexes I published here earlier.
Change all the TYPE=InnoDB into TYPE=myisam or simply remove all
TYPE=InnoDB statements if your mysql installation doesn't support innodb
tables.
Aaron
On Tue, 29 Apr 2003, Robert L. Tom wrote:
Paul,
Robert L. Tom wrote:
I applied these to my dbmail 1.1 mysql database..
alter table messages add index (unique_id); <--Got an ERROR right here
alter table messages add index (status); <-- also here.
But I got an error on the last two lines from mysql saying they
don't exists!
That shouldn't happen. Those statements are well tested on clean tables
created from the sql/mysql/create_tables* files, both the myisam and
innodb versions.
Sounds like your messages table is seriously warped. Could you send a
schema-dump ?
I am new to mysql, how do you do a schema dump?
thanks,
Robert
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
--
________________________________________________________________
Paul Stevens mailto:[EMAIL PROTECTED]
NET FACILITIES GROUP PGP: finger [EMAIL PROTECTED]
The Netherlands________________________________http://www.nfg.nl
-- MySQL dump 9.07
--
-- Host: shiko Database: dbmail
---------------------------------------------------------
-- Server version 4.0.12-log
--
-- Table structure for table 'aliases'
--
CREATE TABLE aliases (
alias_idnr bigint(21) NOT NULL auto_increment,
alias varchar(100) NOT NULL default '',
deliver_to varchar(250) NOT NULL default '',
client_idnr bigint(21) NOT NULL default '0',
PRIMARY KEY (alias_idnr),
KEY alias (alias)
) TYPE=InnoDB;
--
-- Table structure for table 'mailboxes'
--
CREATE TABLE mailboxes (
mailbox_idnr bigint(21) NOT NULL auto_increment,
owner_idnr bigint(21) NOT NULL default '0',
name varchar(100) NOT NULL default '',
seen_flag tinyint(1) NOT NULL default '0',
answered_flag tinyint(1) NOT NULL default '0',
deleted_flag tinyint(1) NOT NULL default '0',
flagged_flag tinyint(1) NOT NULL default '0',
recent_flag tinyint(1) NOT NULL default '0',
draft_flag tinyint(1) NOT NULL default '0',
no_inferiors tinyint(1) NOT NULL default '0',
no_select tinyint(1) NOT NULL default '0',
permission tinyint(1) default '2',
is_subscribed tinyint(1) NOT NULL default '0',
PRIMARY KEY (mailbox_idnr),
KEY owner_idnr (owner_idnr),
KEY name (name),
KEY is_subscribed (is_subscribed),
FOREIGN KEY (`owner_idnr`) REFERENCES `users` (`user_idnr`) ON DELETE CASCADE
) TYPE=InnoDB;
--
-- Table structure for table 'messageblks'
--
CREATE TABLE messageblks (
messageblk_idnr bigint(21) NOT NULL auto_increment,
message_idnr bigint(21) NOT NULL default '0',
messageblk longtext NOT NULL,
blocksize bigint(21) NOT NULL default '0',
PRIMARY KEY (messageblk_idnr),
KEY msg_index (message_idnr),
FOREIGN KEY (`message_idnr`) REFERENCES `messages` (`message_idnr`) ON DELETE
CASCADE
) TYPE=InnoDB;
--
-- Table structure for table 'messages'
--
CREATE TABLE messages (
message_idnr bigint(21) NOT NULL auto_increment,
mailbox_idnr bigint(21) NOT NULL default '0',
messagesize bigint(21) NOT NULL default '0',
seen_flag tinyint(1) NOT NULL default '0',
answered_flag tinyint(1) NOT NULL default '0',
deleted_flag tinyint(1) NOT NULL default '0',
flagged_flag tinyint(1) NOT NULL default '0',
recent_flag tinyint(1) NOT NULL default '0',
draft_flag tinyint(1) NOT NULL default '0',
unique_id varchar(70) NOT NULL default '',
internal_date datetime NOT NULL default '0000-00-00 00:00:00',
status tinyint(3) unsigned zerofill NOT NULL default '000',
rfcsize bigint(21) NOT NULL default '0',
PRIMARY KEY (message_idnr),
KEY mailbox_idnr (mailbox_idnr),
KEY seen_flag (seen_flag),
KEY unique_id (unique_id),
KEY status (status),
FOREIGN KEY (`mailbox_idnr`) REFERENCES `mailboxes` (`mailbox_idnr`) ON
DELETE CASCADE
) TYPE=InnoDB;
--
-- Table structure for table 'tmpmessage'
--
CREATE TABLE tmpmessage (
message_idnr bigint(21) NOT NULL auto_increment,
mailbox_idnr int(21) NOT NULL default '0',
messagesize bigint(21) NOT NULL default '0',
seen_flag tinyint(1) NOT NULL default '0',
answered_flag tinyint(1) NOT NULL default '0',
deleted_flag tinyint(1) NOT NULL default '0',
flagged_flag tinyint(1) NOT NULL default '0',
recent_flag tinyint(1) NOT NULL default '0',
draft_flag tinyint(1) NOT NULL default '0',
unique_id varchar(70) NOT NULL default '',
internal_date datetime NOT NULL default '0000-00-00 00:00:00',
status tinyint(3) unsigned zerofill NOT NULL default '000',
PRIMARY KEY (message_idnr)
) TYPE=InnoDB;
--
-- Table structure for table 'tmpmessageblk'
--
CREATE TABLE tmpmessageblk (
messageblk_idnr bigint(21) NOT NULL auto_increment,
message_idnr bigint(21) NOT NULL default '0',
messageblk longtext NOT NULL,
blocksize bigint(21) NOT NULL default '0',
PRIMARY KEY (messageblk_idnr),
KEY msg_index (message_idnr)
) TYPE=InnoDB;
--
-- Table structure for table 'users'
--
CREATE TABLE users (
user_idnr bigint(21) NOT NULL auto_increment,
userid varchar(100) NOT NULL default '',
passwd varchar(32) NOT NULL default '',
client_idnr bigint(21) NOT NULL default '0',
maxmail_size bigint(21) NOT NULL default '0',
encryption_type varchar(20) NOT NULL default '',
last_login datetime NOT NULL default '1979-11-03 22:05:58',
PRIMARY KEY (user_idnr),
UNIQUE KEY userid (userid),
UNIQUE KEY useridnr_2 (user_idnr,userid)
) TYPE=InnoDB;
