Random ramblings and ravings of Richy B
To extract/export just the schema/design/create tables section of a MySQL table via the command line, you need to use a command such as:
mysqldump –no-data [databasename] [optional table name] -u[user name] -p > extract.sql
(enter the [username] mysql user password)
To import it again, use:
mysql -u [username] -p [databasename] < extract.sql See also: MySQL Docs: MySQLDump.
Thinking about a recent comment I made on Utterly Boring, I thought I’d list the major UK mobile telephone (cell phone) providers coverage maps so if anybody is looking at purchasing a new mobile phone, they can see how good the signal receiption is in their area:
I just thought I’d let everybody know about the backup systems I have in place for various things – it is always good to have backups, and it’s worrying how few people actually run them….
For backing up my website(s), I’ve got a nice 20Gb of storage space from BQ Backup. This 20Gb of space (costing me $10 per month) is hosted in Lower Manhattan (New York) – so it’s the other side of the Atlantic than my UK based Memset VPS account which is in Fareham, South Hampshire and Reading, Berkshire. At the moment, I’ve got cPanel/WHM backing up to BQBackup every night via FTP – but BQBackup also supports rsync backups over SSH (but WHM isn’t too supportive of that method).
For home backups, I do occasionally (bad Richy!) backup to to CDs or DVDs or any of 12 external hard drives I’ve got connected via USB – but that doesn’t cover me in the event of a house fire. I’ve therefore just signed up with Mozy.com (which I came across via “Just A Guy Made Of Dots And Lines“). They offer 2Gb of free storage space – so it’s worth giving it a go (and if you sign up using the referal code T9RF78 or just follow this link to Mozy.com I’ll get another 256Mb of space). Their system works with Windows Vista, XP, 2000, or Mac OS X 10.4 (with a few others in Beta) and will automatically detect your Thunderbird/Outlook configuration and data files (so now more hunting down long paths) and you can setup your own configuration if you want (with your own encryption key). More (“unlimited”) space is available for $4.95 per month.
If I could afford to do so, I’d set up a secondary server somewhere and run R1Soft‘s backup system on it as it’s extremely good (I helped set it up for usage by FreeVirtualServers.com and DiYHost.co.uk) but does require it’s own server and it doesn’t work that well via NAT’ed connections (such as our home connection).
Hope this post helps someone else protect their data!
A few months back, my blog (and websites) were relocated to another server solution. Why? Well, I had originally upgraded from a Positive Internet shared hosting account to their “Dolphin” Dedicated Server as I was using up a few too many resources. I then switched to EV1Servers (now part of The Planet) as they were much cheaper (being US based). When they paid the “Linux License fee” to SCO Scum, I ditched them and went to The Planet. Once they started going downhill support wise, I then moved down to a VPS with UnixShell.
However, I had big plans for a site which I’ve now ditched and the VPS just wasn’t big enough – so I upgraded for nearly a year to a Dedicated Server with Softlayer. But that was posing too expensive for my needs (since I didn’t really need a Dual Processor 4Gb 2x250Gb machine for my sites!). So I’ve now switched to the UK VPS hosting outfit Memset on their VPS “Miniserver 512” package.
For that Xen powered VPS, I’m getting the Equivalent CPU of a Pentium 4 2.4 GHz processor, a minimum of 512Mb RAM, 40Gb disc space, 80Gb bandwidth allowance on a 10Mbps connection (I could have gone for an unmetered 5Mbps connection, but I prefer to keep an eye on my bandwidth usage), 2 IP addresses, Fedora cPanel/Fantastico for a total of £76.32 per month.
Support, when I’ve needed them (which has only been to request the secondary IP address which isn’t setup by default and to correct a licensing issue with Fantastico) has been quite responsive and good (although I do try and supply all relevant details – including error messages – when I do contact support teams as I know what it’s like to have too little information!). The VPS account seems to be reliable and (and this will make my other half happy) – they are also “Carbon Neutral”.
If you’re interested – then give them a call or email and say you were referred by user “beebwaa” and you’ll be granted a 10% discount off the Miniserver Virtual Machine or Fully Dedicated Server packages.
According to the server this blog is hosted on, there’s been 101 emails processed today with 72 (71.3%) of those being detectable spam.
It doesn’t sound a lot until you consider one of our shared hosting servers has handled 22,251 so far today with 3,001 being low scoring spam (13.5%), 11,355 (51.0%) being high scoring spam and 583 (2.6%) being viruses. That’s 67.1% of emails having to be rejected as they are spam or viruses….
And that’s just the detectable spam – imagine what it’ll be like without sites such as Spamhaus (which is currently subject to a legal battle) helping the servers detect what is spam and what isn’t. Do you really want your InBox more than doubling in size due to spam?….