Afficher un message
Vieux 05/04/2006, 08h00   #1
Bac2Day1
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Weekly Mass Data Relocation

I've got a table located on my website and localhost. The table
maintains a size of about 200MB. The table holds a running 4 weeks of
data (50MB/week). I have a winapp that updates my localhost db each
week and currently, I run a backup on the table using the MySql
Administrator... then I run restore on my website's mysql server.
This deletes the whole table and reinserts each row. This isn't needed
and is a long process.
Is there a way to select a range of rows from the localhost table and
"migrate" those rows to my website's mysql server without following the
process I just described? Thanks in advance!

Greg

  Réponse avec citation
 
Page generated in 0,06042 seconds with 9 queries