Recently I had a situation where I needed to a full url to a relative url in the database. I just needed to remove the domain portion of the path, but I wanted to preview it live before I executed the query. Here’s the solution for the preview and for the actual update statement.
select replace(
update
where
zip -vr -9 httpdocs_06_20_2006.zip /home/user/domain.com/site -x
“/home/user/domain.com/site/excluded-dir/*”
tar -cvf httpdocs_06_20_2006.tar.gz /home/user/domain.com/site
–exclude “/home/user/domain.com/site/excluded-dir”
To generate a secure public/private key pair to log in securely, and without a password (if you want).
from the command line (on your box, not logged into ftp, and replacing “username” and “yourdomain” with yours) type:
ssh-keygen -d
hit enter three times
type:
scp ~/.ssh/id_dsa.pub username@ftp.yourdomain.com:.ssh/authorized_keys2
enter password
type:
ssh username@ftp.yourdomain.com
You’re logged in!
I’ve been getting back into some Ruby on Rails stuff and had never used MySql from the command line. Here’s enough commands to be dangerous:
mysql -u root -p
show databases;
use db_name_development;
show tables;
describe users; # where users is a table name
To tar and compress the folder:
tar -czvf mydomainarchive.tgz mydomain.com/
To untar and decompress the folder:
tar xvfz mydomainarchive.tgz
To backup the mysql database:
$ mysqldump -h localhost -u username -p database_name > dump_file
To restore the mysql database:
$ mysql -u username -p database < dump_file
Compliments of Shashi…a coworker of mine…
Go back to site and try to do your activities, if your breakpoint gets hit, it will show you the VS screen and you are good to go….
I think the fact that the DOS prompt is not resizable is a limitation. For a 19″ Dell LCD, the best settings that i’ve found are:
Screen Buffer Size:
Width: 155
Height: 9999
Window Size:
Width: 155
Height: 66
Seems to work well.
I just ran into a situation where I had a Ruby on Rails plugin (Substruct) that I am using for a site release a new version. One big disadvantage of plugins vs. gems in the rails world is versioning because you can modify plugin code. Anyhow, I needed to know what changes were made across the entire plugin directory structure, so that i could easily merge the changes I’ve made to the code changes that were released with the update.
Enter Kdiff, an Free, Open Source, Platform agnostic tool for comparing files and directories.
C:\eclipse\eclipse.exe -clean -vargs -vmargs -Xms256m -Xmx512m -XX:MaxPermSize=128m
Every once in a while i come across a pretty sweet flash/flex application…and what makes TitleViewer really cool is that it’s free and configurable.
Overview:
http://www.airtightinteractive.com/projects/tiltviewer/
Demo:
