I've exported the database from MySQL 5.0 using the
mysqldump tool with
--compatible=mysql40. Interestingly it didn't export the
charset as
character set - it doesn't mention anywhere to use UTF8 but
that
shouldn't be too hard to fix.
One error did crop up:
ERROR 1074: Too big column length for column
'plugin_value' (max = 255).
Use BLOB instead
ERROR 1146: Table 'blojsom.plugin' doesn't exist
ERROR 1146: Table 'blojsom.plugin' doesn't exist
ERROR 1146: Table 'blojsom.plugin' doesn't exist
Not being to au fair about the plugin architecture but does
plugin_value
it need 4kb? Can it be reduced to 255?
I've attached the output (but you should be able to run it
yourself with
no problems (don't forget the --compatible=mysql40 switch).
Thanks, G.
-- MySQL dump 10.10
--
-- Host: localhost Database: blojsom
-- ------------------------------------------------------
-- Server version 5.0.18-nt
/*!40103 SET  OLD_TIME_ZONE=TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET OLD_UNIQUE_CHECKS=UNIQUE_CHECKS,
UNIQUE_CHECKS=0 */;
/*!40014 SET OLD_FOREIGN_KEY_CHECKS=FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET OLD_SQL_MODE=SQL_MODE,
SQL_MODE='NO_AUTO_VALUE_ON_ZERO,MYSQL40' */;
/*!40111 SET OLD_SQL_NOTES=SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `blog`
--
DROP TABLE IF EXISTS `blog`;
CREATE TABLE `blog` (
`blog_id` varchar(50) NOT NULL,
PRIMARY KEY (`blog_id`)
) TYPE=InnoDB;
--
-- Dumping data for table `blog`
--
/*!40000 ALTER TABLE `blog` DISABLE KEYS */;
LOCK TABLES `blog` WRITE;
INSERT INTO `blog` VALUES ('default');
UNLOCK TABLES;
/*!40000 ALTER TABLE `blog` ENABLE KEYS */;
--
-- Table structure for table `category`
--
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
`category_id` int(11) NOT NULL,
`blog_id` varchar(50) NOT NULL,
`parent_category_id` int(11) default NULL,
`name` text NOT NULL,
`description` text,
PRIMARY KEY (`category_id`),
KEY `category_blog_blogidfk` (`blog_id`),
CONSTRAINT `category_blog_blogidfk` FOREIGN KEY
(`blog_id`) REFERENCES `blog` (`blog_id`) ON DELETE CASCADE
) TYPE=InnoDB;
--
-- Dumping data for table `category`
--
/*!40000 ALTER TABLE `category` DISABLE KEYS */;
LOCK TABLES `category` WRITE;
INSERT INTO `category` VALUES
(1,'default',NULL,'/uncategorized/','Uncategorized');
UNLOCK TABLES;
/*!40000 ALTER TABLE `category` ENABLE KEYS */;
--
-- Table structure for table `categorymetadata`
--
DROP TABLE IF EXISTS `categorymetadata`;
CREATE TABLE `categorymetadata` (
`category_id` int(11) NOT NULL,
`metadata_key` text NOT NULL,
`metadata_value` text,
KEY `categorymetadata_category_categoryidfk`
(`category_id`),
CONSTRAINT `categorymetadata_category_categoryidfk`
FOREIGN KEY (`category_id`) REFERENCES `category`
(`category_id`) ON DELETE CASCADE
) TYPE=InnoDB;
--
-- Dumping data for table `categorymetadata`
--
/*!40000 ALTER TABLE `categorymetadata` DISABLE KEYS */;
LOCK TABLES `categorymetadata` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `categorymetadata` ENABLE KEYS */;
--
-- Table structure for table `comment`
--
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment` (
`comment_id` int(11) NOT NULL,
`entry_id` int(11) NOT NULL,
`author` text,
`author_url` text,
`author_email` text,
`comment` text,
`date` datetime NOT NULL,
`ip` varchar(100) default NULL,
`status` varchar(255) default NULL,
`comment_parent` int(11) default NULL,
`blog_id` varchar(50) NOT NULL,
PRIMARY KEY (`comment_id`),
KEY `comment_blog_blogidfk` (`blog_id`),
CONSTRAINT `comment_blog_blogidfk` FOREIGN KEY (`blog_id`)
REFERENCES `blog` (`blog_id`) ON DELETE CASCADE
) TYPE=InnoDB;
--
-- Dumping data for table `comment`
--
/*!40000 ALTER TABLE `comment` DISABLE KEYS */;
LOCK TABLES `comment` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `comment` ENABLE KEYS */;
--
-- Table structure for table `commentmetadata`
--
DROP TABLE IF EXISTS `commentmetadata`;
CREATE TABLE `commentmetadata` (
`comment_id` int(11) NOT NULL,
`metadata_key` text NOT NULL,
`metadata_value` text,
KEY `commentmetadata_comment_commentidfk` (`comment_id`),
CONSTRAINT `commentmetadata_comment_commentidfk` FOREIGN
KEY (`comment_id`) REFERENCES `comment` (`comment_id`) ON
DELETE CASCADE
) TYPE=InnoDB;
--
-- Dumping data for table `commentmetadata`
--
/*!40000 ALTER TABLE `commentmetadata` DISABLE KEYS */;
LOCK TABLES `commentmetadata` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `commentmetadata` ENABLE KEYS */;
--
-- Table structure for table `dbuser`
--
DROP TABLE IF EXISTS `dbuser`;
CREATE TABLE `dbuser` (
`user_id` int(11) NOT NULL,
`user_login` varchar(50) NOT NULL,
`user_password` varchar(64) NOT NULL,
`user_name` varchar(250) NOT NULL,
`user_email` varchar(100) NOT NULL,
`user_registered` datetime NOT NULL,
`user_status` varchar(64) NOT NULL,
`blog_id` varchar(50) NOT NULL,
PRIMARY KEY (`user_id`),
KEY `user_blog_blogidfk` (`blog_id`),
CONSTRAINT `user_blog_blogidfk` FOREIGN KEY (`blog_id`)
REFERENCES `blog` (`blog_id`) ON DELETE CASCADE
) TYPE=InnoDB;
--
-- Dumping data for table `dbuser`
--
/*!40000 ALTER TABLE `dbuser` DISABLE KEYS */;
LOCK TABLES `dbuser` WRITE;
INSERT INTO `dbuser` VALUES
(1,'default','default','Default
User','default_owneremail.com','2006-06-14
21:50:36','','default');
UNLOCK TABLES;
/*!40000 ALTER TABLE `dbuser` ENABLE KEYS */;
--
-- Table structure for table `dbusermetadata`
--
DROP TABLE IF EXISTS `dbusermetadata`;
CREATE TABLE `dbusermetadata` (
`user_metadata_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`metadata_key` varchar(255) NOT NULL,
`metadata_value` text,
PRIMARY KEY (`user_metadata_id`),
KEY `usermetadata_user_useridfk` (`user_id`),
CONSTRAINT `usermetadata_user_useridfk` FOREIGN KEY
(`user_id`) REFERENCES `dbuser` (`user_id`) ON DELETE
CASCADE
) TYPE=InnoDB;
--
-- Dumping data for table `dbusermetadata`
--
/*!40000 ALTER TABLE `dbusermetadata` DISABLE KEYS */;
LOCK TABLES `dbusermetadata` WRITE;
INSERT INTO `dbusermetadata` VALUES
(1,1,'all_permissions_permission','true');
UNLOCK TABLES;
/*!40000 ALTER TABLE `dbusermetadata` ENABLE KEYS */;
--
-- Table structure for table `entry`
--
DROP TABLE IF EXISTS `entry`;
CREATE TABLE `entry` (
`entry_id` int(11) NOT NULL,
`blog_id` varchar(50) NOT NULL,
`title` text,
`description` text,
`entry_date` datetime NOT NULL,
`blog_category_id` int(11) NOT NULL,
`status` text,
`author` text,
`allow_comments` int(11) default '1',
`allow_trackbacks` int(11) default '1',
`allow_pingbacks` int(11) default '1',
`post_slug` text NOT NULL,
`modified_date` datetime NOT NULL,
PRIMARY KEY (`entry_id`),
KEY `entry_blog_blogidfk` (`blog_id`),
KEY `entry_category_categoryidfk` (`blog_category_id`),
CONSTRAINT `entry_blog_blogidfk` FOREIGN KEY (`blog_id`)
REFERENCES `blog` (`blog_id`) ON DELETE CASCADE,
CONSTRAINT `entry_category_categoryidfk` FOREIGN KEY
(`blog_category_id`) REFERENCES `category` (`category_id`)
ON DELETE CASCADE
) TYPE=InnoDB;
--
-- Dumping data for table `entry`
--
/*!40000 ALTER TABLE `entry` DISABLE KEYS */;
LOCK TABLES `entry` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `entry` ENABLE KEYS */;
--
-- Table structure for table `entrymetadata`
--
DROP TABLE IF EXISTS `entrymetadata`;
CREATE TABLE `entrymetadata` (
`entry_id` int(11) NOT NULL,
`metadata_key` text NOT NULL,
`metadata_value` text,
KEY `entrymetadata_entry_entryidfk` (`entry_id`),
CONSTRAINT `entrymetadata_entry_entryidfk` FOREIGN KEY
(`entry_id`) REFERENCES `entry` (`entry_id`) ON DELETE
CASCADE
) TYPE=InnoDB;
--
-- Dumping data for table `entrymetadata`
--
/*!40000 ALTER TABLE `entrymetadata` DISABLE KEYS */;
LOCK TABLES `entrymetadata` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `entrymetadata` ENABLE KEYS */;
--
-- Table structure for table `pingback`
--
DROP TABLE IF EXISTS `pingback`;
CREATE TABLE `pingback` (
`pingback_id` int(11) NOT NULL,
`entry_id` int(11) NOT NULL,
`title` text,
`excerpt` text,
`url` text,
`blog_name` text,
`trackback_date` datetime NOT NULL,
`blog_id` varchar(50) NOT NULL,
`ip` varchar(100) default NULL,
`status` varchar(255) default NULL,
`source_uri` text NOT NULL,
`target_uri` text NOT NULL,
PRIMARY KEY (`pingback_id`),
KEY `pingback_blog_blogidfk` (`blog_id`),
CONSTRAINT `pingback_blog_blogidfk` FOREIGN KEY
(`blog_id`) REFERENCES `blog` (`blog_id`) ON DELETE CASCADE
) TYPE=InnoDB;
--
-- Dumping data for table `pingback`
--
/*!40000 ALTER TABLE `pingback` DISABLE KEYS */;
LOCK TABLES `pingback` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `pingback` ENABLE KEYS */;
--
-- Table structure for table `pingbackmetadata`
--
DROP TABLE IF EXISTS `pingbackmetadata`;
CREATE TABLE `pingbackmetadata` (
`pingback_id` int(11) NOT NULL,
`metadata_key` text NOT NULL,
`metadata_value` text,
KEY `pingbackmetadata_pingback_pingbackidfk`
(`pingback_id`),
CONSTRAINT `pingbackmetadata_pingback_pingbackidfk`
FOREIGN KEY (`pingback_id`) REFERENCES `pingback`
(`pingback_id`) ON DELETE CASCADE
) TYPE=InnoDB;
--
-- Dumping data for table `pingbackmetadata`
--
/*!40000 ALTER TABLE `pingbackmetadata` DISABLE KEYS */;
LOCK TABLES `pingbackmetadata` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `pingbackmetadata` ENABLE KEYS */;
--
-- Table structure for table `plugin`
--
DROP TABLE IF EXISTS `plugin`;
CREATE TABLE `plugin` (
`blog_id` varchar(50) NOT NULL,
`plugin_flavor` varchar(50) NOT NULL,
`plugin_value` varchar(4096) default NULL,
KEY `plugin_blog_blogidfk` (`blog_id`),
CONSTRAINT `plugin_blog_blogidfk` FOREIGN KEY (`blog_id`)
REFERENCES `blog` (`blog_id`) ON DELETE CASCADE
) TYPE=InnoDB;
--
-- Dumping data for table `plugin`
--
/*!40000 ALTER TABLE `plugin` DISABLE KEYS */;
LOCK TABLES `plugin` WRITE;
INSERT INTO `plugin` VALUES ('default','html','meta,
tag-cloud, date-format, referer-log, calendar-gui,
calendar-filter, comment, trackback, simple-search,
emoticons, macro-expansion, days-since-posted, word-count,
simple-obfuscation, nofollow, rss-enclosure,
technorati-tags'),('default','default','conditional-ge
t, meta, nofollow,
rss-enclosure'),('default','admin','admin');
UNLOCK TABLES;
/*!40000 ALTER TABLE `plugin` ENABLE KEYS */;
--
-- Table structure for table `properties`
--
DROP TABLE IF EXISTS `properties`;
CREATE TABLE `properties` (
`blog_id` varchar(50) NOT NULL,
`property_name` varchar(255) NOT NULL,
`property_value` longtext,
KEY `properties_blog_blogidfk` (`blog_id`),
CONSTRAINT `properties_blog_blogidfk` FOREIGN KEY
(`blog_id`) REFERENCES `blog` (`blog_id`) ON DELETE CASCADE
) TYPE=InnoDB;
--
-- Dumping data for table `properties`
--
/*!40000 ALTER TABLE `properties` DISABLE KEYS */;
LOCK TABLES `properties` WRITE;
INSERT INTO `properties` VALUES
('default','blog-url','http://loc
alhost:8080/blojsom/blog/default'),('default','blog-
admin-url','http://loc
alhost:8080/blojsom/blog/default'),('default','blog-
base-url','http://localhost:8080/b
lojsom'),('default','blog-language','en'),('defa
ult','blog-name','NAME YOUR
BLOG'),('default','blog-description','DESCRIBE YOUR
BLOG'),('default','blog-entries-display','15'),('def
ault','blog-owner','Default
Owner'),('default','blog-owner-email','default_owneremail.com'),('default','blog-comments-enabled',
'true'),('default','blog-trackbacks-enabled','true'),
('default','blog-email-enabled','true'),('default',
'blog-default-flavor','html'),('default','plugin-comme
nt-autoformat','true'),('default','linear-navigation-e
nabled','true'),('default','comment-moderation-enabled
','true'),('default','trackback-moderation-enabled',
'true'),('default','blog-ping-urls','http://rpc.pingomatic.com'),('default','blojsom-extension-metaweblog-accepted-t
ypes','image/jpeg, image/gif, image/png,
img'),('default','xmlrpc-enabled','true'),('default
','blog-pingbacks-enabled','true');
UNLOCK TABLES;
/*!40000 ALTER TABLE `properties` ENABLE KEYS */;
--
-- Table structure for table `template`
--
DROP TABLE IF EXISTS `template`;
CREATE TABLE `template` (
`blog_id` varchar(50) NOT NULL,
`template_flavor` varchar(50) NOT NULL,
`template_value` varchar(255) default NULL,
KEY `template_blog_blogidfk` (`blog_id`),
CONSTRAINT `template_blog_blogidfk` FOREIGN KEY
(`blog_id`) REFERENCES `blog` (`blog_id`) ON DELETE CASCADE
) TYPE=InnoDB;
--
-- Dumping data for table `template`
--
/*!40000 ALTER TABLE `template` DISABLE KEYS */;
LOCK TABLES `template` WRITE;
INSERT INTO `template` VALUES ('default','rss','rss.vm,
text/xml;charset=UTF-8'),('default','rsd','rsd.vm,
application/rsd+xml;charset=UTF-8'),('default','html',
'asual.vm,
text/html;charset=UTF-8'),('default','atom','atom.vm,
application/atom+xml;charset=UTF-8'),('default','rss2',
'rss2.vm,
text/xml;charset=UTF-8'),('default','rdf','rdf.vm,
text/xml;charset=UTF-8'),('default','admin','org/blojs
om/plugin/admin/templates/admin.vm,
text/html;charset=UTF-8');
UNLOCK TABLES;
/*!40000 ALTER TABLE `template` ENABLE KEYS */;
--
-- Table structure for table `trackback`
--
DROP TABLE IF EXISTS `trackback`;
CREATE TABLE `trackback` (
`trackback_id` int(11) NOT NULL,
`entry_id` int(11) NOT NULL,
`title` text,
`excerpt` text,
`url` text,
`blog_name` text,
`trackback_date` datetime NOT NULL,
`blog_id` varchar(50) NOT NULL,
`ip` varchar(100) default NULL,
`status` varchar(255) default NULL,
PRIMARY KEY (`trackback_id`),
KEY `trackback_blog_blogidfk` (`blog_id`),
CONSTRAINT `trackback_blog_blogidfk` FOREIGN KEY
(`blog_id`) REFERENCES `blog` (`blog_id`) ON DELETE CASCADE
) TYPE=InnoDB;
--
-- Dumping data for table `trackback`
--
/*!40000 ALTER TABLE `trackback` DISABLE KEYS */;
LOCK TABLES `trackback` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `trackback` ENABLE KEYS */;
--
-- Table structure for table `trackbackmetadata`
--
DROP TABLE IF EXISTS `trackbackmetadata`;
CREATE TABLE `trackbackmetadata` (
`trackback_id` int(11) NOT NULL,
`metadata_key` text NOT NULL,
`metadata_value` text,
KEY `trackbackmetadata_trackback_trackbackidfk`
(`trackback_id`),
CONSTRAINT `trackbackmetadata_trackback_trackbackidfk`
FOREIGN KEY (`trackback_id`) REFERENCES `trackback`
(`trackback_id`) ON DELETE CASCADE
) TYPE=InnoDB;
--
-- Dumping data for table `trackbackmetadata`
--
/*!40000 ALTER TABLE `trackbackmetadata` DISABLE KEYS */;
LOCK TABLES `trackbackmetadata` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `trackbackmetadata` ENABLE KEYS */;
/*!40103 SET TIME_ZONE=OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=OLD_SQL_NOTES */;
_______________________________________________
Blojsom-users mailing list
Blojsom-userslists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/blojsom-u
sers
|