I cant add posts to a phpbb table after moving servers.

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.

The table has over 125,000 posts.

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:

-- 
-- 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 table `phpbb_posts_text`
-- 

INSERT INTO `phpbb_posts_text` (`post_id`, `bbcode_uid`, `post_subject`, `post_text`) VALUES (2, '83858f1cdc', 'hello welcome to your forum.', '[color=red:83858f1cdc]HI and welcome to the new message board.[/color:83858f1cdc]\r\nIf you have not joined up yet why not,this is the new  message board for the new you in 2005.\r\nwhen you join up during january you will be entered in a draw to win cash prizes of up to £50.00\r\n\r\nabout me well I am the webmistress of http://www.wiki.com/\r\nI am the original bridget jones so you will find me posting most days on the forum.\r\n\r\nwe need mods to help in all Categories so send me an e-mail if you would like to be considered or leave a message for me in the chat section.\r\nOK its your turn so join up and introduce youself and lets get this forum rocking. :D'),
(3, 'dd8f30805e', '', 'Hi, I think I am the second member, so great.  I''d like to contribute in any way I can.  I assist with running a website and am a member on a few forums.  Glad to be here.'),
(4, '0f48a4ac07', '', 'robbie welcome aboard :D \r\nyou are the first person in the £50 draw.\r\n so so far the  prize money is yours unless anybody else joins.'),

Code (markup):

And Thumbnails of my database:
[/URL][/IMG]
[/URL][/IMG]

 

Bigdump will insert all the posts. What problem are you having? Is bigdump not working for you?

If you need help, pm me, I can take a look. I've used bigdump many times to move very large databases.