September 22, 201015 yr 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! :
September 23, 201015 yr 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.
September 23, 201015 yr Author Unfortunately I can't do it... my host doesn't allow external access to their MySQL servers. Otherwise this wouldn't be an issue...
Create an account or sign in to comment