speeding up restoration

[wow]

hello mates

I've got a table with over 400,000 records. I did a mysqldump to ensure I could restore it in case of problems. Sure enough, problems arose and I needed to do a restore. The mysqldump created the usual create database, create table and one gigantic insert statement, where all 400,000+ records are inserted. I started my restore around 10pm or so yesterday and was surprised to wake up this morning and find it still running. Considering the dump itself took a couple of seconds, why is the restore taking so long? I'm building a website that's going to have tons of traffic. A database restore that's going to take multiple hours seems to be unacceptable. One way to speed up the process would have been to simply copy the actual database files and just stick them back in the data directory.

regards
wow -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[yaali]

Do you have indexes on your tables? If so then the inserts would take a long time. if you are going to do a dump of a large table drop the indexes then do the dump and restore and then add the indexes back on.

Although in this case it sounds like something else could be wrong since I don't believe indexes should slow down the inserts by that much. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --