Open Thinkering

Menu

Tag: migration

Climate ch-ch-ch-changes

I can remember as a child my mother picking blackberries while waiting to pick me up from school. They’d appear just before ‘blackberry week’ which was literally the name people gave to October half-term.

Now, 30 years later, blackberries appear around 10 weeks earlier here, ready to be picked in mid-August. That makes for tasty summer holiday desserts, but leaves me slightly concerned about the pace of climate change.

In the last week, we’ve had scorching hot weather in the UK, followed by intense thunderstorms which led to flooding that derailed a train.

Of course, things are worse on many fronts elsewhere; there are plenty of people, especially refugees, who are desperate to seek asylum in our country. Yet, instead of thinking in a joined-up way about the global climate emergency and the effect it will have on migration over the next 30 years, the inept UK government sends in the Royal Navy.

Within my lifetime, those in charge have missed so many opportunities to steer us of disaster, meaning that now we haven’t got long to avert climate catastrophe. I just hope that elections over the next few years replace the emotional toddlers we’ve got running the show with some grown-ups committed to action.


This post is Day 31 of my #100DaysToOffload challenge. Want to get involved? Find out more at 100daystooffload.com

How to restore a very large MySQL file without errors.

File this one under ‘geeky’ and ‘stuff that took me a while to find out so I’m sharing it with others’.

I *Heart* MySQL

Image CC BY-SA Kevin Severud @ Flickr

During the couple of days I’ve been off work ill this week I’ve transferred teaching.mrbelshaw.co.uk from a UK-based webhost to Bluehost (which hosts this, among other sites). It was about time my former blog (active 2005-2007) had some TLC as it was becoming progressively broken.

I had a 42MB MySQL database backup – the file that contains all of the blog’s important information (post and comment text, etc.) – but every time I tried to import this into a new database at Bluehost I kept getting timeout errors. It was then that I remembered I’d had this problem before and I’d managed to solve it with some sort of script that breaks the file up into smaller chunks to feed to the database incrementally.

After a while searching, I came across it again. It’s called BigDump and the process, if you’re familiar with installing WordPress manually, is fairly straightforward:

  1. Go into phpMyAdmin and execute DROP_TABLES on your target database.
  2. Download bigdump.zip from http://www.ozerov.de/bigdump.php and extract the zip file.
  3. Open bigdump.php using Notepad, TextEdit, or similar. Edit the relevant lines to point towards your database, username and password.
  4. Create a folder called dump on your web server and upload both bigdump.php and your MySQL database into that folder.
  5. CHMOD the folder recursively to 777 (i.e. give read/write permissions when accessed via the web)
  6. Access the script via (e.g.) http://yourdomain.com/dump/bigdump.php
  7. Follow the instructions!

This should lead to your database backup being successfully inserted into your new database. You can then use the data in whatever web app (i.e. WordPress) that you want! 🙂

css.php