WordPress SEO
December 11th, 2008Tips…
Monitor All SQL Queries in MySQL
December 4th, 2008Helpful guide to enable dynamic logging of SQL queries on MySQL (xampp). Link
Using the New MySQL Query Profiler
December 3rd, 2008To enable Profiling on MySQL:
mysql> set profiling=1;
Query OK, 0 rows affected (0.00 sec)
To view SQL Profiles:
mysql> show profiles;
For additional instructions, go to: http://dev.mysql.com/tech-resources/articles/using-new-query-profiler.html
How to access MySQL from Windows Command Prompt
December 3rd, 2008Steps:
1. Run ‘Command Prompt’
Start > Run > Type ‘cmd’ then click ‘Ok’
2. Go to MySQL bin folder
Type “cd c:\xampp\mysql\bin
3. Then, type ‘mysql -u root -p’
For additional instructions, go to this site: http://www.makeyougohmm.com/20040609/806/
Installing MSDE
November 23rd, 2008A strong SA password is required for security reasons. Please use SAPWD …
Installation instructions can solved this: Strong SA password required
The one I did was…
Start > Run > then type path to setup.exe then type
SAPWD=”what_ever_you_want _for_your_PW”
So it should look like this.setup.exe sapwd=”PW”
Use of Power Schemes
November 13th, 2008Configuring an Internal Server
November 12th, 2008CONFIGURING AN INTERNAL DNS SERVER.
(WINDOWS SERVER 2003)
About DNS (Domain Name System).
This tutorial documents the steps needed to create an internal DNS Server that will allow you to use “friendly” names within your LAN (Local Area Network) or provide a platform for Host Headers to be used within your IIS (Internet Information Services) configuration.
Service: To manually delete MySQL
November 12th, 2008Run Regedit or regedt32 in the WINDOWS directory.
Find the registry entry called
HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services
There should be a MySQL service listed which can be deleted. Have a look at
the keys and see what files the service was using and perhaps delete them
also.
Then reboot.
Show/Hide Div
November 4th, 2008function ShowHideLayer(divID) {
var box = document.getElementById(divID);
if(box.style.display == "none" || box.style.display=="") {
box.style.display = "block";
}
else {
box.style.display = "none";
}
}