I have an M$ Access 2K DB that contains all my data but the data is now going to be used on a linux only server.

The new database format looks like this:

CREATE TABLE _links (
lid int(11) unsigned NOT NULL auto_increment,
cid int(5) unsigned NOT NULL default '0',
title varchar(100) NOT NULL default '',
url varchar(250) NOT NULL default '',
logourl varchar(60) NOT NULL default '',
submitter int(11) unsigned NOT NULL default '0',
status tinyint(2) NOT NULL default '0',
date int(10) NOT NULL default '0',
hits int(11) unsigned NOT NULL default '0',
rating double(6,4) NOT NULL default '0.0000',
votes int(11) unsigned NOT NULL default '0',
comments int(11) unsigned NOT NULL default '0',
PRIMARY KEY (lid),
KEY cid (cid),
KEY status (status),
KEY title (title(40))
) TYPE=MyISAM AUTO_INCREMENT=13 ;


CREATE TABLE `_text` (
`lid` int(11) unsigned NOT NULL default '0',
`description` text NOT NULL,
KEY `lid` (`lid`)
) TYPE=MyISAM;

I will be using a query to format my data to be exported and added to the MySQL DB.

I know little about MySQL and a reasonable ammount about Access.

The MySQL is a live DB.

My data naturaly forms a single table and so I will have to break it into two.

How do I set my data to export and then import it without loss of referential integrity.

To further complicate matters some fields will be left null or blank (not given) for the purpose of formatting.