View Single Post
  #1  
Old 08-03-2006, 03:39 PM
tanny tanny is offline
Junior Member
 
Join Date: Aug 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
tanny is on a distinguished road
Default unable to add posts to a phpbb table after moving servers.

Hi

I have moved servers and need to replace my forum posts in my phpbb table.

My host added my database with shh but missed out including the posts text.

I would like to try and do this myself.

I have copied just a couple of the first posts to see if I can do it.

I can add the table using bigdump but no posts ?
If I use the mysql import file option it times out.

Here is my code:

Code:
--
-- Table structure for table `phpbb_posts_text`
--

DROP TABLE IF EXISTS `phpbb_posts_text`;
CREATE TABLE `phpbb_posts_text` (
`post_id` mediumint(8) unsigned NOT NULL default '0',
`bbcode_uid` varchar(10) NOT NULL default '',
`post_subject` varchar(60) default NULL,
`post_text` text,
PRIMARY KEY (`post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for tabl -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote
  Webmaster Forums - View Single Post - unable to add posts to a phpbb table after moving servers.
View Single Post
  #1  
Old 08-03-2006, 03:39 PM
tanny tanny is offline
Junior Member
 
Join Date: Aug 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
tanny is on a distinguished road
Default unable to add posts to a phpbb table after moving servers.

Hi

I have moved servers and need to replace my forum posts in my phpbb table.

My host added my database with shh but missed out including the posts text.

I would like to try and do this myself.

I have copied just a couple of the first posts to see if I can do it.

I can add the table using bigdump but no posts ?
If I use the mysql import file option it times out.

Here is my code:

Code:
--
-- Table structure for table `phpbb_posts_text`
--

DROP TABLE IF EXISTS `phpbb_posts_text`;
CREATE TABLE `phpbb_posts_text` (
`post_id` mediumint(8) unsigned NOT NULL default '0',
`bbcode_uid` varchar(10) NOT NULL default '',
`post_subject` varchar(60) default NULL,
`post_text` text,
PRIMARY KEY (`post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for tabl -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote