Open Thinkering

Menu

Tag: teaching.mrbelshaw.co.uk

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! πŸ™‚

The very best of teaching.mrbelshaw.co.uk

A couple of private messages and a comment on a previous post on this blog made me realise something the other day. Here I am assuming that readers of dougbelshaw.com are aware that I blogged for two years solely on teaching and education-related stuff at teaching.mrbelshaw.co.uk. It would appear that this is not the case. And why should it be? After all, I make very little mention of it here.

So what follows is a roundup of what you missed between 2005 and the end of 2007. Hope you find something useful! πŸ˜€

According to the Most Popular Posts plugin still installed at teaching.mrbelshaw.co.uk, the most visited posts are (in order) :

  1. How to write an application letter for a teaching-related job
  2. Online Storage
  3. I can’t teach properly
  4. 20 Ideas: Getting students to use their mobile phones as learning tools
  5. Interesting Desktop Backgrounds
  6. 10 Top Behaviour Management Tips
  7. WikiMapia.org
  8. 8 things that irritate me with edublogs
  9. Weekly Roundup (3 September 2006) – 1 – Theory
  10. Using Twitter with your students

There’s a few posts in there – numbers 2, 5 and 7, for example – that are there because of general Internet searches unrelated to education. Most of the rest in this list gained some traction due to being referenced on one or more sites with a larger number of readers! :-p

My all-time Top 10

1. The kind of school in which I want to work…

I referenced this post recently. In it, I attempt to explain the type of education system and school I want to be a part of. I compare teachers to being like ‘lifeguards’. Creating the graphics for this post and coming up with the metaphor helped clarify my thinking a great deal!

2. I can’t teach properly

I spend a lot of my time frustrated in life, but I’ve learned to live with it. In this post, I poured out this frustration in a way that seemed to strike a chord with quite a few other educators (judging by the comments!).

3. 5 reasons why I love teaching

Despite being frequently frustrated, I do actually love teaching. Most of the time, it doesn’t even feel like a job. Before we had Ben a couple of years ago, I would frequently tell Hannah (my wife) that I’d do it for free! That’s obviously changed a bit now that I have dependents, but the actual interfacing with young people, their enthusiasm and lack of fear to ask questions, is so refreshing. πŸ™‚

4. 1 year on… How has blogging affected my life as a teacher?

I started blogging in 2005 after having read the blogs of other educators for a good while and commenting on them. My blogging regularly – usually every day – began when I was off work at my previous school due to stress. Connecting with educators worldwide made such a difference, and 2006 ended up being a great year. πŸ˜€

5. Infectious Learning: Teachers as Lifelong Learners

I’m a firm believer in teachers being allowed the time to be learners too. In fact, I think it’s essential to prevent stagnation. This post was sparked from an exchange during an interview in which the Head of a school I shall not name stated he was ‘somewhat suspicious’ that I’d remained in full-time education (when I did my MA in Modern History) ‘longer than I had needed to’. The post outlines four reasons why teachers need to be effective learners.

6. Digital Natives, Mountain Men and Pioneers

During 2006 I became increasingly tired of seeing both in blog posts and ‘academic’ research the terms ‘digital immigrant’ and ‘digital native’. This post was a follow-up to an earlier post in which I called the dichotomy a false one and suggested an alternative.

7. Do textbooks hamper 21st-century learning?

This post was in response to a call by Wes Fryer for a moratorium on the purchase of new textbooks. Others, such as Stephen Downes and Vicki Davis had joined in the debate. I looked at the ins-and-outs of textbook usage, adding that I managed to burn myself out during my first year and-a-bit of teaching by seeing textbooks as evil things that should be avoided. A blended approach is a much better option… πŸ™‚

8. The 7 Habits of Highly Effective Teachers

There’s nothing like a good-old ‘list’ post! This one goes through, unsurprisingly, the seven ‘habits’ I believe teachers I would class as ‘effective’ and – dare I say it – inspirational teachers possess.

9. Homework-casting using del.icio.us

I don’t think I would have included this post in my Top 10 was it not for a conversation during last week’s EdTechRoundup FlashMeeting. I suggested a couple of years ago a possible method for automatic resource-delivery to students via RSS of homework/coursework materials. Theoretically, you should be able to deliver any type of file via RSS – not just audio, video and PDFs. Unfortunately, I’m still not aware of any program that allows the automatic downloading of any type of file enclosed in the RSS feed. πŸ™

10. Yearly Roundup – The 20 best edublog posts of 2006

I used to really enjoy doing my weekly, monthly and yearly roundups of the edublogosphere. There’s two reasons why I can’t do that any more. First, I have less time these days – what with my son, working for educational publishers in my ‘spare’ time, and an additional role in school. Second, the edublogosphere has (happily) expanded greatly in the last couple of years. It’s just impossible to keep up… πŸ˜‰

What are YOUR favourite posts on your blog(s)?

Reblog this post [with Zemanta]

I’ll tell you this for free…

…put yer money away!*

This post was prompted, in part, by a wonderful recent presentation by Merlin Mann’s entitled How To Blog and its horror-inducing first few slides.

I’ve been contacted in the past week by two separate individuals who wanted to place paid advertisements on my sites. The first offered $150 for 6 text-link ads at the end of blog posts on the now-defunct teaching.mrbelshaw.co.uk. I presume this is because these appear near the top of Google search rankings for certain keywords. The second was simply exploring the possibility of paid adverts on this blog.

I said no to both on principle. You may find that strange, as I’ve had Google and iTunes ads on my sites before.** Well, yes, but I’ve realised the error of my ways! As has been pointed out to me by several people, adverts on a personal blog make people question your impartiality and just don’t look very professional. I’ve taken these points on board. The only advertising on my sites now can be found at historyshareforum.com to help cover hosting and bandwidth costs. :-p

So you can be sure that when I recommend certain products and services, I’m not being paid the individuals or companies behind them. Transparency is key.

The only thing I’m now struggling with now is revealing which school I work at. In the past I’ve made sure I don’t say where I work to keep the professional and personal completely separate. In a connected online world, however, this is becoming increasingly difficult. Take elearnr, for example. This is a blog I’ve set up to share links, resources and guides I create in my new role as E-Learning Staff Tutor. Whilst I mention names of members of staff on there, I haven’t – as yet – said which school I’m talking about. I’m torn between what it will mean for this blog, and being completely transparent with the other.

I’d appreciate your thoughts and comments. πŸ™‚

*Watch this YouTube video clip of Peter Kay if you don’t get what I’m talking about…

** I apologise you can see an iTunes ad in the sidebar, I’ve tried several times to get rid of it using K2’s sidebar manager, but it just won’t budge! πŸ™

(image by Joseph Robertson @ Flickr)

css.php