I finally got around to upgrading .81 and installing it on the new server. I first did my mysqldump and installed .81 on the server without any modifications, with some minor issues got it up and running.
Now for the upgrade. I decided to start with the database upgrade, so, using the info that B0zz provided last year, I changed the following in the intranet.sql (the backup file) from:
| Code: |
CREATE TABLE `groups` (
`id` int(4) NOT NULL auto_increment,
`name` char(30) collate latin1_general_ci NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
--
-- Dumping data for table `groups`
--
LOCK TABLES `groups` WRITE;
/*!40000 ALTER TABLE `groups` DISABLE KEYS */;
INSERT INTO `groups` VALUES (0,'Administrators'),(1,'Anonymous'),(2,'File Admin');
/*!40000 ALTER TABLE `groups` ENABLE KEYS */;
UNLOCK TABLES;
|
to
| Code: |
CREATE TABLE `groups` (
`id` int(4) NOT NULL auto_increment,
`name` char(30) collate latin1_general_ci NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
--
-- Dumping data for table `groups`
--
LOCK TABLES `groups` WRITE;
/*!40000 ALTER TABLE `groups` DISABLE KEYS */;
INSERT INTO groups VALUES (0,'Administrators');
UPDATE groups set id = '0' where id='1';
INSERT INTO groups VALUES (1,'Anonymous');
INSERT INTO groups VALUES (2,'File Admin');
/*!40000 ALTER TABLE `groups` ENABLE KEYS */;
UNLOCK TABLES;
|
I dropped the intranet database in mysql, and recreated it, then moved the backup into the database:
mysql -u root -p intranet < intranet.sql
I then ran the mysql-from-0.80.sql script:
mysql -u root -p intranet < mysql-from-0.80.sql
But I get the error:
ERROR 1146 (42S02) at line 13: Table 'intranet.advanced_acl' doesn't exist
I can create a table, but don't know what to put in it.
