2
Try exporting your MySql database tables into Excel.csv then reformat the the csv such that it conforms to the XOOPS DB table requirements. Once you do that import the revised csv into your XOOPS db.
Another option is to write SQL script to import from old to new db.