I had to do a BigDump

My readers probably don’t want to, or even need to, know this, but tonight I had to do a BigDump. On the backend of course… This is how it happened…

I decided to move where this site was hosted. Part of that process required me to backup the database that runs the whole site – it has all the info about the posts I’ve written, the comments people have left, and the settings to make the frontend (what you guys see) look the way it does. So I backed up the database and ended up with a file 63 Mb in size!! I did think this was mighty large, compared to some of the other sites I’m running, but nevertheless continued.

I then informed the website host to make changed to the DNS to point to my new hosting account. I then set about importing the database into this new account. When I saw the message on PHPMyAdmin which said you could only import a database up to 51Mb in size I started to panic. I tried anyway, and of course failed. Thankfully, phpMyAdmin gave me a link to a help file for when “I cannot upload big dump files.” This led me to BigDump – a site with a php script available for download which allows a big dump file to be imported in segments. Just what I needed. I was a little nervous about running this script on my site, as I was trusting that the author of the script hadn’t written something which would totally destroy the whole site. I didn’t need to be nervous – it imported the file in a flash, and didn’t cause any other problems.

I also discovered the reason for the large database file – it had saved a tonne of info from some old plugins I had used, so some time in the future I will go and delete all that data that I no longer need.

2 Comments so far »

  1. Wendy said,

    Wrote on January 14, 2009 @ 10:49 am

    Blah de blah de blah de blah – now what I need to understand is – How does this affect me????

  2. Paul said,

    Wrote on January 14, 2009 @ 3:34 pm

    Wendy, you don’t need to do a thing!! It just means that this site will continue to look and feel the same way it always has. I just needed to write about it so that if I needed to do it in the future, I wouldn’t have to spend hours researching on the ‘net how to do it again.

    Rest assured that there will be more posts relevant to you very shortly. 🙂

Comment RSS · TrackBack URI

Leave a Comment

Name: (Required)

E-mail: (Required)