Cumulus Support

Hi All,
i have monthly data back to 2009
what the best way to load it in a database?
thanks Beau

Use the ImportCumulus script?

You either have to run it manually for each month, or write a little wrapper script to loop through each monthly file in a folder.

Or use ExportMySQL from MX, which lets you upload a month at a time, but will also do all months in one go (which may take some time). The ImportCumulusFile script may well be quicker as it will typically be running on the same machine as the the MySQL server (or be very close to it with a good link, as is the case with some providers).

Mark i i did the script how long would you pause it to give the php time to run?
Beau

If you run it synchronously then there would be no need to pause. Remember though that PHP normally has a maximum default run time of 30 seconds (iirc), so if your DB is a bit slow the script may time out before all the entries are added, so keep a log and check for error messages.

I'd forgotten about Steve's new utility, that may be a better option, as Steve said possibly a bit slower, but utilmately simpler to use.

I tried ExportMySQL with mx stoped it seemed slow

Hi all here a update I have tested both options i have 77 fines in both seem to overwhelm godady msql sever
is there a easy way i can setup a mysql database on my pc fill it then export it to my host?
beau