PHP Classes

DB Dump

Recommend this page to a friend!

      pop3.class.inc  >  All threads  >  DB Dump  >  (Un) Subscribe thread alerts  
Subject:DB Dump
Summary:DB Dump
Messages:3
Author:Stefan Blum
Date:2010-02-09 09:19:37
Update:2010-02-18 10:55:40
 

  1. DB Dump   Reply   Report abuse  
Picture of Stefan Blum Stefan Blum - 2010-02-09 09:19:37
Has anybody an Dump from the msql data base?

Table 'fleetv4.messages' doesn't exist

  2. Re: DB Dump   Reply   Report abuse  
Picture of Steffen Stollfuß Steffen Stollfuß - 2010-02-18 10:52:41 - In reply to message 1 from Stefan Blum
// Create Table for Mail Header Data
$query = 'CREATE TABLE IF NOT EXISTS `'.$dir_table.'` (`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`msg_id` TEXT NOT NULL, `from` TEXT NOT NULL, `to` TEXT NOT NULL, `subject` TEXT NOT NULL,
`date` TEXT NOT NULL, `cc` TEXT, `bcc` TEXT, `content_type` TEXT, `content_encode` TEXT,
`mime_version` TEXT, `x_mailer` TEXT, `x_priority` INT( 1 ) DEFAULT \'3\', `reply_to` TEXT, `sender` TEXT,
`mail_followup_to` TEXT, `mail_reply_to` TEXT, `return_receipt_to` TEXT, `disposition_notification_to` TEXT,
`received` TEXT NOT NULL, `create` TIMESTAMP(14) NOT NULL, `read` TINYINT(1) DEFAULT \'0\' NOT NULL,
PRIMARY KEY ( `id` )) TYPE = MYISAM';

  3. Re: DB Dump   Reply   Report abuse  
Picture of Steffen Stollfuß Steffen Stollfuß - 2010-02-18 10:55:40 - In reply to message 1 from Stefan Blum
Hi,

normally the script should create the tables by them self.
Check if your mysql user has the needed rights to create tables.

Else you can use these SQL statements to create them.

// Create table for messages !!!
$query = 'CREATE TABLE IF NOT EXISTS `'.$msg_table.'` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`unique_id` VARCHAR( 255 ) NOT NULL , `linenumber` INT UNSIGNED NOT NULL , `linetext` TEXT,
PRIMARY KEY ( `id` ) ) TYPE = MYISAM ';

 
For more information send a message to info at phpclasses dot org.