Huge Data Transfer Problems

[ajna]

I am doing a major change to a databse and need to read old table info in, convert it to the new tables format and INSERT the data into the new table.

I have mysqldumped the original database to my Windows box so I don't bring my server to it's knees running this transfer on 57,000+ records.

I am running my conversion php script, but the process fails after about 200 records being transferred. A table gets missed, or something happens to stop the process.

I have found it I limit myself to 100 records at a time, all the neccessary tables are updated properly.

I am try to safe myself from a day of editing one line of code from:

... LIMIT 0,100
... LIMIT 100,100
...etc...etc...etc

Is there a simple dynamic loop I can place AROUND my FIRST SELECT loop to automatically change the starting point of my LIMIT PARAMS?

ie: LIMIT $i,100

where $i starts at 0 and increments to 100, 200, etc until all the records are finished.

Thanks,

Kev

[rayvd]

I would think you could do something like this...

while ($condition) {
  $query = sprintf('SELECT * FROM blah blah WHERE blah = blah LIMIT %d, 100', $i);
  $i += 100;
  mysql_query($query);
}

Or you don't even need to use sprintf... If you enclose your string in " " variables are parsed, so you could use $i within the string.