Hi,

I have been trying to make a back-up of my sites on my pc on Xampp (latest version).
It's easy moving the site files to htdocs (the folder for php files), but the problem is with the db.
The db back up made using cpanel is around 1.8MB and compressed as GZ. Trying to import it using phpmyadmin as GZ or uncompressed to sql takes way too long & leads to time-outs.

From what I read about Bigdump, itz supposed to address this problem, but even here, it took in one case about 1 hour & when I stopped it, it had just imported 39 of about 320 tables.

Is that normal taking so much time for just 1.8MB g-zipped/around 8MB unzipped db? During the time, my old PC with RAM of 512MB, the usage was 100%. Has it got to do with the PC?

Actually before that I had tried to import a 20.4MB GZipped db file (unzipped several dozen MB) of a growing adp database and because phpmyadmin complained about the size exceeded the set maximum size of around 16MB (I think). I was advised to split the db file and that is how I came to bigdump, which is supposed to do just that only that after waiting for close to one hour, I interrupted the process.

Is this normal and if not, is there a quicker way of importing db files into phpmyadmin into Xampp/phpmyadmin? I'm just wondering if 1.8MB can be so troublesome, what about the 20.4Mb or much bigger files if the directory db or drupal site grows much bigger?

I think however there's a solution...

I have used bigdump quite a few times and it worked flawlessly for me... Although it did not take an hour for me to import, but that may have been due to a smaller file size. There are many variables which affect the importing, proc speed, memory, connection speed etc.

Your best bet is to use bigdump, so try it again if you have the time.

Ok ...
I will see if it makes sense to try again or make sure I have much more time, as I dont see much to change or do differently on the my PC at the time. May be it has something to do with the 512MB memory, because some of the trials took place after a fresh installation of XP & with no other programs running at the time. The problem turned up both in IE 7 & FF. The connection speed in this case I think does not count, since I was trying to import the db files saved on the pc to a locally installed phpmyadmin in Xampp.

Thanks

Even with 512MB of ram, it really should not take that long. 20MB of text to a local computer is really not very much. Try it again and see what happens.