View Single Post
  #3  
Old 08-03-2006, 03:46 PM
wow wow is offline
OSP Starters
 
Join Date: Jul 2006
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
wow is on a distinguished road
Default

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 --
Reply With Quote
  Webmaster Forums - View Single Post - unable to add posts to a phpbb table after moving servers.
View Single Post
  #3  
Old 08-03-2006, 03:46 PM
wow wow is offline
OSP Starters
 
Join Date: Jul 2006
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
wow is on a distinguished road
Default

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 --
Reply With Quote