How to insert mysqlDB content inside another mySQLDB

[mars16]

I have searched the forums but haven't come across anything helpful.

I have a mysql database full of many sport articles that i want to copy to another mysql database on a separate website (wordpress ). I would appreciate a basic code or a link to a simple tutorial

Old databse looks like this:

Database name: sportsArticles
Table Name: footballtbl
id int(11) NOT NULL auto_increment,
date date NOT NULL default '0000-00-00',
text longtext NOT NULL,
title varchar(200) NOT NULL default '',
PRIMARY KEY (id),
KEY date (date)

inser into this new table

TABLE Name: wp_posts
ID bigint(20) unsigned NOT NULL auto_increment,
post_author bigint(20) NOT NULL default '0',
post_date datetime NOT NULL default '0000-00-00 00:00:00',
post_date_gmt datetime NOT NULL default '0000-00-00 00:00:00',
post_content longtext NOT NULL,
post_title text NOT NULL,
post_category int(4) NOT NULL default '0',

[azoundria]

That's difficult. If there are only a few entries, I would do it manually, but if there are tons you have no choice but to create a script to handle it.

First, on the server to which the database is being sent, create a script to add new rows to your table based on the input you submit. For example:

<?php
 $date = $_REQUEST['date'];
 $text = $_REQUEST['text'];
 $title = $_REQUEST['title'];

 $author = "Insert Your Name";
 $date = "?" //Convert From Old Format
 $gmt = "?" //Convert Time To GMT Here
 $category = "Insert Category #";

 //Code to Access MySQL Database Goes Here

 mysql_query("INSERT INTO wp_posts VALUES ( NULL, '" . $author . "', '" . $date . "', '", "' . $gmt . "', '" . $text . "', '" . $title . "', '" . $category . "')");

?>

And on the originating server, insert the following code:

<?php
 //Code to Access MySQL Database Goes Here

 $result = mysql_query("SELECT * FROM footballtbl");

 while ($row = mysql_fetch_assoc($result)) {
  $date = $row['date'];
  $text = $row['text'];
  $title = $row['title'];
  $nothing = file("http://yournewsite.com/scriptname.php?date=" . $date . "&text=" . $text . "&title=" . $title);
 }

?>

Please carefully look over the code and back up your database before you run it.