Hi there, there are a lot of ways to do it
so i am assuming that the mysql database and the phpbb from your old machine is just simply copied to the new one.
Here's one of teh method
first - add your phpbb_posts_text table without any rows or record.
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;
second - export the records from your old mysql machine
(my suggestion is export it using CVS data - fields terminated by '\t' and lines terminated by '\n' - used phpmyadmin)
and offcourse your record exported will be inserted to your new database to your new machine.
To import using phpmyadmin
-- This message may have been cut off and the rest will only be shown to members. To become a member, click here --