mysql data directory on windows
Mar0
for some reason i cant see the programdata folder on windows vista
i have to type the path in the address bar
thanks windows!
datadir=”C:/ProgramData/MySQL/MySQL Server 5.1/Data/”
how to forward an aliased domain
Feb0
RewriteEngine on
Options +FollowSymlinks
RewriteCond %{HTTP_HOST} cindyjimmerson.com$
RewriteRule ^(.*)$ http://leanhealthcarewest.com/$1 [R=301,L]
stop start restart apache plesk fedora core 8
Feb0
go to /etc/httpd
httpd -k start
httpd -k restart
httpd -k stop
How to find a file in unix / linux
Feb0
this will search the entire file structure for the file httpd.include
find / -name “httpd.include” -print
print to pdf
Dec0
print to pdf
download this app to add a pdf print driver. Then you can print anything as a pdf
http://www.dopdf.com/
cron job every even or odd minute
Nov0
if you need one script to go off every even minute and then anthor ever odd set your cron jobs to go off as below, good for testing tcp / udp listeners
every even minute 0-59/2 * * * *
every odd minute 1-59/2 * * * *
Mysql delete all rows and reset autoincrement
Oct0
delete all the rows of a mysql talble
delete from tablename
reset the auto increment key
ALTER TABLE tablename AUTO_INCREMENT=0
Merging Two Tables in Mysql
Oct0
Ok, I had two mailing lists I needed to add together (minus duplicates of coarse)
first make sure both talbes have the same fields (one had “last_name” and “first_name” fields while the other had just “name”)
UPDATE coo_mailing_list SET name = CONCAT(first_name, ‘ ‘, last_name);
bam!!! coo_mailing_list has a name field with first and last names in it.
Next merge the two tables into a new table
CREATE TABLE new_mailing_list SELECT DISTINCT * FROM (SELECT name, email FROM mailing_list UNION ALL SELECT name,email FROM coo_mailing_list) sq;
add a primary key field and set to auto increment and rename the old and mailing lists tables and your
your done!