Calash
6-15-05, 03:21 PM
I am having a bit of a problem with backing up and then restoring my database. The primary problem are with the table that holds the text for the stories on my site.
For reference, I am using the backup script at the link below.
http://forum.powweb.com/showthread.php?t=20022
What is happening is that it is splitting the story_text into 4 insert statements. The problem is that each insert is too big to run on it’s own, and times out phpmyadmin and the restore script. Also bogs down my machine when I try to copy and paste them.
Is there a way to have the backup script break these up into small INSERT statements?
For reference, I am using the backup script at the link below.
http://forum.powweb.com/showthread.php?t=20022
What is happening is that it is splitting the story_text into 4 insert statements. The problem is that each insert is too big to run on it’s own, and times out phpmyadmin and the restore script. Also bogs down my machine when I try to copy and paste them.
Is there a way to have the backup script break these up into small INSERT statements?