Exporting to 2 Files

[uemtux]

So I have an FM database of products. I export this database to an SQL file and import it into my backend via phpMyAdmin at my web host.

At a certain number of records, I started running into problems. phpMyAdmin was timing out when I tried to import my file. Eventually I solved this issue by splitting the file into 2 files.

So now I am looking for a quick and easy way to export a found set in 2 groups, to 2 separate files. I can think of a bunch of ways to do this but they all involve flagging groups of records, doing separate finds, etc... isn't there instead some way to simply manipulate the found set to get this to work?

Teach me, gurus! :

[Ocean West]

what i would do is upgrade to FM 11 and use External SQL Sources to import or loop and add records to your backend SQL files.

[uemtux]

Unfortunately I can't do it... my host doesn't allow external access to their MySQL servers. Otherwise this wouldn't be an issue...