Posts Tagged 'sql'

Get me out of here!

Amazing Stories February 1952 Classic Vintage Science Fiction Sci Fi Pulp Book

How to back up or migrate your blog.

The internet is not safe. If you have your data on a webhost, anywhere, it’s probably not safe. If you have a security specialist on your team (and none of us here do), then maybe it’s somewhat safe from malicious attacks, but even then, it’s still vulnerable to plain old hardware failure and general cockups. And the most vulnerable data of all is the data that is hosted on bottom-end hosts like Dreamhost where potentially hundreds of other people are sharing disk space and server resources with you, and as with everywhere on the internet, a sizable proportion of them are guaranteed to be some combination of incompetent and malicious. It’s only a matter of time before one of them accidentally or deliberately brings the server down, accidentally corrupts your files, or breaks in to your filespace and uses it to subsidise their pornography business. It’s happened to me, more than once. Moreover, as I’ve said before, if you are using FTP instead of SFTP, it means that you don’t really care about your data anyway, and pretty much anyone with enough dedication can come along and steal your password and make free with your files if they try hard enough. Continue reading ‘Get me out of here!’

A quick look behind the curtain

what makes it go

So, we’re going to dive into dreamhost, which is the essentially arbitrary webhost we chose for this project.

You will each have been given, soon enough, a dizzying number of “FTP usernames”, “shell useranmes”, “MySQL usernames” and “Account usernames”. It’s annoying how many usernames we had to dole out. But don’t panic if you don’t know what they all mean. The key one to remember is your Account username. If you keep that one, you can log in an out of the control panel (which is here: and from there you can create and change all types of other users… most importantly SFTP users, which are the usernames that actually do all the work (the ones you use to upload files, for example). You can also do other fun stuff like managing the sites you are hosting and the databases you ahve and all kinds of stuff like that. So keep the account username and password, and then you can use it to reset all the other ones. Continue reading ‘A quick look behind the curtain’