Forum Restore Failing?

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
Sjwdavies
Registered User
Posts: 10
Joined: Mon Aug 25, 2008 9:38 pm

Forum Restore Failing?

Post by Sjwdavies »

I'm trying to resurrect an old forum.

I've spoken to the old owner and he's kindly sent me the backups he had.

After posting in the version 3 forum, http://www.phpbb.com/community/viewtopi ... &t=1152055, i'm posting here for help :roll:

I've downloaded and installed version 2 and have tried to backup from the .sql files I have, but when I do, the page just reads "Powered by phpBB 2.0.23 Copyright 2001 phpBB Group"...

And when checking the forum it doesn't appear to have updated.

Can anyone shed any light on my problem?

User avatar
Dog Cow
Registered User
Posts: 2495
Joined: Fri Jan 28, 2005 12:14 am
Contact:

Re: Forum Restore Failing?

Post by Dog Cow »

First of all, you have to wait awhile. But you probably already did that.

Else, you can restore the file using the mysql monitor, phpMyAdmin, or a similar Mysql utility.
Moof!
Mac GUI Vault: Retro Apple II & Macintosh computing archive.
Inside Allerton bookMac GUIMac 512K Blog

Sjwdavies
Registered User
Posts: 10
Joined: Mon Aug 25, 2008 9:38 pm

Re: Forum Restore Failing?

Post by Sjwdavies »

Cheers for the reply.

When I try updating using the MySQL GUI, it doesn't recognise the file.

When I try MySQL restore from the command prompt, it says error 1068: Multiple Primary Key... and won't progress.

Any ideas?

User avatar
ric323
Former Team Member
Posts: 22909
Joined: Tue Feb 06, 2007 12:33 am
Location: Melbourne, Australia
Name: Ric
Contact:

Re: Forum Restore Failing?

Post by ric323 »

Please post the first 50 lines of the backup file here for us to check.
Put it between "code" tags (using the "Code" button above the edit window.)
The Knowledge Base contains solutions to many common problems!
How to fix "Doesn't have a default value" and "Incorrect string value: xxx for column 'post_text' " errors.
How to do a clean re-install of the latest phpBB3 version.
Problems with permissions? Read phpBB3 Permissions

Sjwdavies
Registered User
Posts: 10
Joined: Mon Aug 25, 2008 9:38 pm

Re: Forum Restore Failing?

Post by Sjwdavies »

It's failing at line 972, do you still want me to upload the first 50 lines?

User avatar
ric323
Former Team Member
Posts: 22909
Joined: Tue Feb 06, 2007 12:33 am
Location: Melbourne, Australia
Name: Ric
Contact:

Re: Forum Restore Failing?

Post by ric323 »

The first 50, and also the one that is failing (with a few lines before and after included) please.
The Knowledge Base contains solutions to many common problems!
How to fix "Doesn't have a default value" and "Incorrect string value: xxx for column 'post_text' " errors.
How to do a clean re-install of the latest phpBB3 version.
Problems with permissions? Read phpBB3 Permissions

Sjwdavies
Registered User
Posts: 10
Joined: Mon Aug 25, 2008 9:38 pm

Re: Forum Restore Failing?

Post by Sjwdavies »

Code: Select all

-- MySQL Auto Backup 1.28
--
-- Host: 75.126.19.150
--
-- 2006-11-21 22:45:01
--
-- ------------------------------------------------------

CREATE DATABASE IF NOT EXISTS `whord_phpbb1`;

USE `whord_phpbb1`;

DROP TABLE IF EXISTS `phpbb_acronyms`;

CREATE TABLE IF NOT EXISTS `phpbb_acronyms`(`acronym_id` MEDIUMINT(9) NOT NULL AUTO_INCREMENT PRIMARY KEY, `acronym` VARCHAR(80) NOT NULL, `description` VARCHAR(255) NOT NULL)TYPE=MyISAM;

LOCK TABLES `phpbb_acronyms` WRITE;

UNLOCK TABLES;

CREATE DATABASE IF NOT EXISTS `whord_phpbb1`;

USE `whord_phpbb1`;

DROP TABLE IF EXISTS `phpbb_album`;

CREATE TABLE IF NOT EXISTS `phpbb_album`(`pic_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, `pic_filename` VARCHAR(255) NOT NULL, `pic_thumbnail` VARCHAR(255) NULL, `pic_title` VARCHAR(255) NOT NULL, `pic_desc` TEXT NULL, `pic_user_id` MEDIUMINT(8) NOT NULL DEFAULT 0, `pic_username` VARCHAR(32) NULL, `pic_user_ip` VARCHAR(8) NOT NULL DEFAULT '0', `pic_time` INT(11) UNSIGNED NOT NULL DEFAULT 0, `pic_cat_id` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 1, `pic_view_count` INT(11) UNSIGNED NOT NULL DEFAULT 0, `pic_lock` TINYINT(3) NOT NULL DEFAULT 0, `pic_approval` TINYINT(3) NOT NULL DEFAULT 1)TYPE=MyISAM;

LOCK TABLES `phpbb_album` WRITE;

INSERT INTO `phpbb_album` VALUES (1, '468a74ffbf0d056bbe54d3fe60bbbe55.jpg', '468a74ffbf0d056bbe54d3fe60bbbe55.jpg', 'Corsa', 'Vauxhall Corsa', 1, 'Damon', '516a18c4', 1148498282, 0, 15, 0, 1);

INSERT INTO `phpbb_album` VALUES (2, '53529adc120181b6048c8f987bfe166a.jpg', '53529adc120181b6048c8f987bfe166a.jpg', 'Blackpool Cruise 001', '', 1, 'Damon', '516a18c4', 1148503623, 1, 4, 0, 1);

INSERT INTO `phpbb_album` VALUES (3, '22a6019f398c0a80ea8cb72ed7e8445a.jpg', '22a6019f398c0a80ea8cb72ed7e8445a.jpg', 'Blackpool Cruise 002', '', 1, 'Damon', '516a18c4', 1148503670, 1, 2, 0, 1);

INSERT INTO `phpbb_album` VALUES (4, '25efe757c84086300b29508ba05e3fa2.jpg', '25efe757c84086300b29508ba05e3fa2.jpg', 'Blackpool Cruise 003', '', 1, 'Damon', '516a18c4', 1148503698, 1, 4, 0, 1);

INSERT INTO `phpbb_album` VALUES (5, '564213a6f49177124a31160cfed9f2dc.jpg', '564213a6f49177124a31160cfed9f2dc.jpg', 'Blackpool Cruise 004', '', 1, 'Damon', '516a18c4', 1148503714, 1, 1, 0, 1);

INSERT INTO `phpbb_album` VALUES (6, '10b33a12e7abe7d9b31ebffb4f986fe7.jpg', '10b33a12e7abe7d9b31ebffb4f986fe7.jpg', 'Blackpool Cruise 005', '', 1, 'Damon', '516a18c4', 1148503732, 1, 3, 0, 1);

INSERT INTO `phpbb_album` VALUES (7, 'f399b6d484f08495de3cb2fc62722d6f.jpg', 'f399b6d484f08495de3cb2fc62722d6f.jpg', 'Blackpool Cruise 006', '', 1, 'Damon', '516a18c4', 1148503755, 1, 5, 0, 1);

INSERT INTO `phpbb_album` VALUES (8, '20ac90f2ac05110d2dd6ee61c8a28d11.jpg', '20ac90f2ac05110d2dd6ee61c8a28d11.jpg', 'Blackpool Cruise 007', '', 1, 'Damon', '516a18c4', 1148503774, 1, 1, 0, 1);

INSERT INTO `phpbb_album` VALUES (9, '5319cc130a824a11600b8ca89ee701f3.jpg', '5319cc130a824a11600b8ca89ee701f3.jpg', 'Blackpool Cruise 008', '', 1, 'Damon', '516a18c4', 1148503827, 1, 12, 0, 1);

INSERT INTO `phpbb_album` VALUES (10, 'a204464af95505c8fae15e7c0e0ce781.jpg', 'a204464af95505c8fae15e7c0e0ce781.jpg', 'Blackpool Cruise 009', '', 1, 'Damon', '516a18c4', 1148503845, 1, 15, 0, 1);

INSERT INTO `phpbb_album` VALUES (11, 'ec61cd2f263779a4452effbf1210027c.jpg', 'ec61cd2f263779a4452effbf1210027c.jpg', 'Blackpool Cruise 011', '', 1, 'Damon', '516a18c4', 1148503873, 1, 11, 0, 1);

INSERT INTO `phpbb_album` VALUES (12, 'a97cdb6b8f10e3a94d3d9f5f631a1d1a.jpg', 'a97cdb6b8f10e3a94d3d9f5f631a1d1a.jpg', 'Blackpool Cruise 012', '', 1, 'Damon', '516a18c4', 1148503890, 1, 4, 0, 1);

INSERT INTO `phpbb_album` VALUES (13, 'be799250acebb1acebdb923bb7e01b2b.jpg', 'be799250acebb1acebdb923bb7e01b2b.jpg', 'Blackpool Cruise 013', '', 1, 'Damon', '516a18c4', 1148503917, 1, 10, 0, 1);

INSERT INTO `phpbb_album` VALUES (14, '1764476116ac7e18f3b9a5accb5ba832.jpg', '1764476116ac7e18f3b9a5accb5ba832.jpg', 'Blackpool Cruise 014', '', 1, 'Damon', '516a18c4', 1148576104, 1, 6, 0, 1);

Here's lines 972:

Code: Select all

CREATE DATABASE IF NOT EXISTS `whord_phpbb1`;

USE `whord_phpbb1`;

DROP TABLE IF EXISTS `phpbb_confirm`;

972: CREATE TABLE IF NOT EXISTS `phpbb_confirm`(`confirm_id` CHAR(32) NOT NULL PRIMARY KEY, `session_id` CHAR(32) NOT NULL PRIMARY KEY, `code` CHAR(6) NOT NULL)TYPE=MyISAM;

LOCK TABLES `phpbb_confirm` WRITE;

UNLOCK TABLES;

CREATE DATABASE IF NOT EXISTS `whord_phpbb1`;

USE `whord_phpbb1`;

DROP TABLE IF EXISTS `phpbb_ct_filter`;

CREATE TABLE IF NOT EXISTS `phpbb_ct_filter`(`id` MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, `list` VARCHAR(250) NULL)TYPE=MyISAM;

LOCK TABLES `phpbb_ct_filter` WRITE;

INSERT INTO `phpbb_ct_filter` VALUES (1, 'WebStripper');

INSERT INTO `phpbb_ct_filter` VALUES (2, 'NetMechanic');

INSERT INTO `phpbb_ct_filter` VALUES (3, 'CherryPicker');

INSERT INTO `phpbb_ct_filter` VALUES (4, 'EmailCollector');

User avatar
Lumpy Burgertushie
Registered User
Posts: 67048
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Forum Restore Failing?

Post by Lumpy Burgertushie »

you are going to have to clean up that backup file.

you need to remove all of the lines that start with CREATE DATABASE

you need to remove all of the lines that say anything about LOCK etc.


here is just the basic part of a backup file that does the standard categories table. ( fogger would be replaced with your table prefix.)

Code: Select all

-- 
-- Table structure for table `flogger_categories`
-- 

DROP TABLE IF EXISTS `flogger_categories`;
CREATE TABLE `flogger_categories` (
  `cat_id` mediumint(8) unsigned NOT NULL auto_increment,
  `cat_title` varchar(100) default NULL,
  `cat_order` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`cat_id`),
  KEY `cat_order` (`cat_order`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `flogger_categories`
-- 

INSERT INTO `flogger_categories` (`cat_id`, `cat_title`, `cat_order`) VALUES (1, 'Test category 1', 10);
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.3 Styles by PlanetStyles.net

If a tree falls in the forest and nobody is there, does it make a sound?

Sjwdavies
Registered User
Posts: 10
Joined: Mon Aug 25, 2008 9:38 pm

Re: Forum Restore Failing?

Post by Sjwdavies »

Hi,

Thanks for the replies.

The file is 20mb big and some 500,000 lines....

Is this as simple as doing a find & replace?

User avatar
Lumpy Burgertushie
Registered User
Posts: 67048
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Forum Restore Failing?

Post by Lumpy Burgertushie »

Sjwdavies wrote:Hi,

Thanks for the replies.

The file is 20mb big and some 500,000 lines....

Is this as simple as doing a find & replace?
that is not very big so it should not be a problem.
yes it will be simple search and replace with nothing.

however, you do have to be very precise, the slightest mistake will get errors .

also, you will need a good text editor. wordpad or notepad will not work.

If you would like to zip it up and PM me a link to it, I would be happy to do it for you.

robert
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.3 Styles by PlanetStyles.net

If a tree falls in the forest and nobody is there, does it make a sound?

Locked

Return to “2.0.x Support Forum”