Export data from one database to another

[darubillah]

hi,

 

I am new to PHP,

 

i wanna ask that is their any free script available through which I can export data from one db to another

 

I want export from wordpress db

 

from table wp_post from colom post_content & post_title

 

to

 

table entitles to colom description & title respectively

 

any help will be appreciated

 

Thanks

Shayan Abbas

[dgoosens]

phpMyAdmin should be able to help you out:

http://www.phpmyadmin.net/home_page/index.php

[darubillah]

acctually I am looking for a PHP script which can do that for me

[darubillah]

please help me

[gevensen]

you have to write one, heres something to get the old noggin stirred

 

for example

 

$result=mysql_query("SELECT * FROM `table1` ");

if($result)

{

while($row=mysql_fetch_array($result);

{

mysql_query("INSERT INTO `table2` ........ "); // not actual command but select the data you want to take from one table to another

}

}

[fenway]

acctually I am looking for a PHP script which can do that for me

Then you've come to the wrong place/forum.