Tag Archive for plugin

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.

vPIP Plugin

Tonight I installed the vPIP plugin so that I could start to include some video in my posts. I’ve just done a post using it, which seemed to work out well, apart from not being able to see how Thickbox works – it’s set in the Options page, and I couldn’t see anything for it in the Write Post page, but it doesn’t seem to appear on the published post. I’ll have to look into that one later.

Also of use was this little bookmarklet – Get YouTube video – which I came across thanks to Geeks are Sexy. This will now allow me to keep a local copy of the video – handy for those occasions when YouTube videos suddenly go missing, and also when I want to use a video at school as often these things are blocked.