While the FAQ is good as far as it goes, I'm not sure that its backup/restore advice fully addresses this user's situation. And, unfortunately, when it comes to adding a large amount of
new data to a database, the potential issues are manifold.
In addition to the default PHP timeout (30 seconds) mentioned briefly in the FAQ, I've also found (after much head banging) that some service providers impose their own "unadvertised" restrictions on SQL queries, even for so-called "business package" accounts. In fact, my experience also suggests that the XOOPS module installer itself is not without a few quirks of its own when it comes to handling new SQL dB additions that are larger than "normal".
Basically, there are two "workaround" approaches. The first involves using a l-o-n-g series of single record inserts. The phpMyAdmin utility
can be made to export data that way if one unchecks its "extended" option. Alternatively, one can split the large insert into smaller "chunks". (In my own case, approximately 2000 records each seemed to satisfy the limits imposed by my service provider, but others may vary, of course.) The latter approach looks something like this:
$query = ...
(0, 2018, 'tcp', 'terminaldb', '', 0),
(0, 2018, 'udp', 'rellpack', '', 0),
(0, 2019, 'tcp', 'whosockami', '', 0);";
$result =& $dbconn->Execute($query);
$query = "INSERT INTO ".$PortsTable." VALUES
(0, 3050, 'udp', 'gds_db', 'gds_db', 0),
(0, 3051, 'tcp', 'galaxy-server', 'Galaxy Server', 0),
(0, 3051, 'udp', 'galaxy-server', 'Galaxy Server', 0),
...
$result =& $dbconn->Execute($query);
Hope that helps.
