unable to add posts to a phpbb table after moving servers.

[tanny]

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 --

[ruskin]

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 --

[wow]

if you are using Linux box or mac ox or any machine support unix
you can do it using terminal. do the instruction below;

~ urname$ mysql -u root -p yourdatabase <--- to mysql
Enter password: ******* <--- your password

and then type the following mysql load data command

mysql> Load data infile '/phpbb_posts_text.tab' into table phpbb_posts_text fields terminated by '\t' lines terminated by '\n';




You can also do it from any windows machine as well, from the command prompt or from the run prompt. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[pablovagne]

Sideshow Collectibles had an impressive line of Spider-Man 3-related busts and models on display at Toy Fair 2007.
These included cool Spider-Man and Venom mini-busts which will retail for $45 when they become available in the 2nd
Quarter of '07, an even wilder posed Venom statue that will be available in the 3rd Quarter for roughly $190 and a
giant Symbiote Spider-Man Bust that will also be available in the 3rd Quarter for twice that amount. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --