Recent content by theScien

Ok, no one at the datacenter looked at my request over night but the server has now been restarted and all is fine again, strange. So there was some down time which is unfortunate but in my quest for a fix I found this tool which allows you to restart a remote computer via FTP, if only I had it...

I can't login to my Windows 2008 R2 dedicated server through RDP, all services are down (websites, etc.) and I just want to restart the box, strangely, FTP is working, any ideas how to restart the server? Don't have a "lights out" facility and the data-center guys are probably only going to...

CutePDF installs as a printer, I see that being a problem already on most hosts, does anyone know of a free PDF on the fly creator that works in Windows Server 2003 maybe a component or script? www.mylittlehost.com

I'm also in the process of changing my current language selecting procedures, I have it setup like this; I use XML files, one xml lang per calling file or block of code, this works alright, however as you have like 10 blocks of code, it has to process 10 xml lang files, so I've been thinking in...

On the FQDN, what is that server? Is it the servername? What about the domain.com, is it the one of the webserver domains? Or is it only for servers set as domain controlers? My server is not a DC, I tried http://$serverName$.$anyWebServerDomain$.com didn't work Any advice?

Thanks, is it "skip-innodb" or "--skip-innodb" the command that goes in my.ini?

Great stuff, never tried this as it didn't appear to be correct syntax somehow. Thanks for that.

Hi guys, any way to count different distincts in one query? Sub-queries not supported in my MySQL v4.0.?? I have this: '// Count unique months and years to dimension arrays accordingly SQL = "SELECT COUNT(DISTINCT Month(Issue)) AS mm FROM tbl_Newsletters WHERE Active = 1;" Set rsNL =...

skip-innodb" is not even documented in the manual, let alone the other disabling commands, anyway, I will disable just this 2, that should do it for me, someone was also saying that by disabling innodb alone we get a small boost out of the server. If I find the other commands I'll post them...

Thanks will do that, any more skips for the other types? Do you think I will save that much memory when this types don't get loaded?

Yes, I remember reading about it, and I played with it at the time, enabling and disabling it in MySQL, no avail, anyway, I'm willing to recreate all passwords in the new version, if it lets me too. I will only bring the server down and mess with it again when I'm absolutly sure of what it is...

I only use MyISAM for all my web applications, and that should suffice for years to come, so I'm wondering how to disable all other data types from the server, so it starts as only capable of dealing with MyISAM tables. What other benefits there are in doing so, apart from perhaps a greater...

Is that what's called a sub-query? A select inside a select? If so, I can't use it, still on 4.0.?? can't upgrade as there are connection and other problems coming from the new version. Will find a better example soon.

Have you tried to restart the DNS server? That kind of thing happens to me sometimes, I just restart the DNS server and all comes back to life, still don't know what causes it.

Your explanations are the best I've seen in some time, thanks for that. Here's an example of a couple o queries I do alot; '// Count Main Menus SQL = "SELECT COUNT(Menu_Main_ID) AS countMains FROM tbl_Menu_Main;" Set rsMainMenu = Conn.Execute(SQL) countMains = rsMainMenu("countMains") '//...