Question Details

Browse

How to fasten restoring large mysql dump?

By dhandapani k - Oct. 04, 2008

I have 13GB size dump with me. It took almost 5 days to restore into my database. Is there any way to make it more efficient?


Answers

Add Answer

  1. By an anonymous user on Oct. 06, 2008

    Wow! 5 days?! That's crazy!


    How did you take the dump? Using mysqldump? And how were you restoring?


    You might want to throw hardware at the problem.


    0 Votes
    Report this

  2. By dhandapani k on Oct. 08, 2008

    I am using 7GB RAM, 750GM hard disk with Ubuntu OS. Teh dump was take by my client with mysql version 4.1 using mysqldump. I restored in mysql 5.1.22 using the command mysql -uroot dbname


    0 Votes
    Report this

  3. By jack tm on Oct. 15, 2008

    did you dump on db server?


    0 Votes
    Report this

  4. By qingzhu kong on Oct. 16, 2008

    5 days？maybe you could change the store method.


    1 Votes
    Report this

  5. By kernal kong on Oct. 16, 2008

    cool。so Large


    0 Votes
    Report this

  6. By Neptune Chin on Oct. 19, 2008

    get


    0 Votes
    Report this
Share your knowledge

Related Questions

Browse Get answers and share your expertise.