In this post I will describe a database backup solution that I’ve been using for some time. Here’s what happens: this PHP script calls mysql to do a db_dump — this gets dumped to a text file — then it zips all this information up as a gunzzip file, then it emails the txt.gz file as an attachment to a gmail account (where you have unlimited storage). Easy!
» More: PHP: MYSQL Database Backup Email Attachment Solution
Archive for the ‘Computer Science’ Category
PHP: MYSQL Database Backup Email Attachment Solution
August 3rd, 2008PHP: A script to increase a stat counter…
August 3rd, 2008So, let’s say you have a stat counter on your website from Let’s say — sitedesigner.safesecureweb.com…. Or any other free web page counter for that matter…
Regardless, you will have a link to your counter that looks something like this:
http://sitedesigner.safesecureweb.com/servlet/CounterServer?_patternID=12&_userID=22533&_pageID=1
Now, we can dissect this link down and find the “userID” section of the URL or URI, whatever you fancy calling it. Regardless — notice the “22533″ — Now, I don’t know who owns this counter, nor do I care — I’m just showing you a proof of concept. For various reasons I created a little web form that would allow you to smack this counter (ie, make the hit # increase) N number of times, where N is a variable determined by the end user.
PHP posts coming soon
July 15th, 2008DB backup
Authentication
Cookies
Look for em ~ (:
Howto: Multiple Desktop Wallpapers
June 18th, 2008Hey,
So, one of my favorite wallpaper sites –> http://www.mandolux.com always has these great multi-monitor wallpapers. For years I’ve only been using one of them, when I could have been using two!
This is on Windows XP.
First, get your two images — say via mandolux ~~ great site, again.
Now, Right click on desktop -> Properties
Set your regular desktop to “(None)”
Click Customize Desktop
Click on the Web tab up top.
Click “New…”
Click “Browse” and find your first image.
repeat and find your second image
Make sure they’re both checked, and then say “ok”
When you say “ok” from the Display Properties, you will see 2 images on your screen.
Move the right one to the right monitor by clicking around on it till a grey bar comes up.
Once you have it to the right monitor, click the black arrow on the top of the grey box and say “cover screen”
then move the other image to the other monitor and repeat the process.
Viola!
I’ve included a screenshot so you can see how it works!
Good luck!
PS: if your two images don’t line up, you should put your taskbar on auto-hide. You can do this from right clicking it, unlocking it if it’s locked, and then going to properties. There is a checkbox for auto-hide. Enjoy!
Niiiiiice linux question/answer
January 14th, 2008So, I was looking how to reload my .bashrc to update the aliases I had just created and I stumbled upon this great resource:
I will probably add a lot of these to my page in case this ever goes down.
Anyway, here it is: http://www.ftlinuxcourse.com/FTLinuxCourse_Complete-2004/FTLinuxCourse/en/sysadm/appendix_p.html
Resize Digital Camera Pictures Using Only MSPaint
December 30th, 2007I’m going to go over a quick and easy way to resize your digital camera images to something more manageable so that you’ll be able to post them online, email them, send them over im, and whatever else you want to do with them. This technique is a quick way to resize a few images, up to about 4-5 I would say before this technique is not useful and there is a better approach.
Knock on Wood!
December 26th, 2007I think I got it!
I completely disassembled pwroftwo all the way down to the last screw. I set the motherboard up on my desk with just it, the CPU’s, the Video Card, RAM, and power. Surprisingly — it didn’t cut off! It ran smoothly for 20 minutes with my old power supply! Crazy, I know.
Anyways, I’ve built it back piece by piece trying to make sure there are no shorts anywhere, etc.
I’ve reinstalled Linux on it because one of the times it shut off it messed up the partition, so that went well, and I’m now about to try to install the RocketRaid drivers for my PCI-X card and then subsequently get my 2TB Raid Array up and running.
Actually.. before I do all that I’m going to let it run overnight — Let’s hope it’s still running in the morning.
New Power Supply! Yippee!!!
December 24th, 2007New power supply is installed and pwroftwo is about to be in action!~~
I’m burning it in a little bit to make sure it’s not going to die on me, and then I’ll plug in the hard drives and look at all the stuff that’s on them. Hopefully emery won’t want too much and then I can wipe it and start migrating data!
…….errrrrrrrrr in the middle of writing this it did the error beep again… gah what the hell
let’s hope that once I get this new CMOS battery I can fix it once and for all!
I Hate IXWebHosting
December 19th, 2007I hate this hosting company. It is TERRIBLE.
FTP drops every 2 minutes, I get This-Page-Has-Timed-Out errors ALL THE TIME! This is completely unacceptable.
Their service is terrible, I complain and I get nothing in return, just ‘we’ll look into it.’ Nothing ever comes of this, if you submit tickets to their help center you get responses from people who obviously do not speak English, and moreover seemingly know nothing about efficiency and web hosting basics.
It’s 11:48 on a Wednesday night and I can’t even get to my phpmyadmin, BAH! Just ridiculous.
Take my advice, DO NOT USE THEIR SERVICE! I will be moving my stuff to another host as soon as my busy season ends.
No Reboot After Updates!
December 12th, 2007Damnit Microsoft.
Fine! I will download your updates automatically. But damnit do not restart my computer without my permission!
Here’s a post about how to disable this ungodly ‘feature.’
» More: No Reboot After Updates!
