|
|
Sunday Morning - Install MySQL!12:20.57 - Sunday 20th November 2005 (Link to this Entry)The problem I have is that I am using the MySQL databases located on the webserver. I have the necessary permissions set up so there's no problem there, but for whatever reason the server keeps lockingme out for a few minutes at a time if I do too much with a connection to it. For example, if I check my email, do a large MySQL query and FTP something all within the space of a few minutes, I get blocked. I've checked the scan protection on the server and even put my IP address in the 'Never block this address' list but all to no avail - I guess it could be the router, but I also reasoned that I really sholdn't be working with live data anyway, hence the install. Another reason for the local install is that every query has to go over the Internet. While it's OK with one or two, I have one script that checks all the days in a month for due draws and included results, so there's a lotta lotto queries flying. When querying localhost (ie online, when I've uploaded it) it postively flies, but when every query has to go over the net it crawls like a dirty low-down dawg. Edit: What's most frustrating is that HTTP isn't blocked, but HTTP to the server admin is, so I can't even see what hte hell's going on while I'm blocked out. Gah. Edit 2 Well that was a non-event! Seems the installation of MySQL 5 has greatly improved, and it's now as easy as any other program. Excellent stuff. The only problem I had was with the passwords being in the old format, giving me the old 'Client does not support authentication protocol' error, promptly fixed with:
Links: |
Older Posts
20-11-05 Sunday Morning - Install MySQL! 19-11-05 Lottery Site Updated - Getting near to launch! 17-11-05 Website Tweaks and Additions 08-11-05 Mobile Message Mayhem 03-11-05 Tab into SELECT list Problem with Safari on Apple Powerbook 31-10-05 TFT Monitor Burn-in Panic 26-10-05 The Big Spam Switch-Off 24-10-05 My Folding@Home Stats Super Random Number Picker 18-10-05 Where's all the Duos at, bitches? 14-10-05 Geeky JavaScript Clock - update Ja Da / Trazan & Banarne 09-10-05 Geeky JavaScript Binary Clock 08-10-05 Super Soupy George Lyrics 01-10-05 Minor Lotto Site update... |
