So you’ve got a mysql server with an unknown number of isam tables and you need to convert them (the easy way)? Here’s how:
find /var/lib/mysql/ -name “*.ISM” -print > convert.txt
emacs convert.txt
replace: “/var/lib/mysql/” with “alter table “
replace “.ISM” with ” type = myisam;”
replace “/” with “.”
Be careful to include the spaces where I have them.
The run:
mysql -u root -p < convert.txt
So for years I’ve lived with the problem of not having my ssh key passphrase loaded when I re-attach a screen session.
Today I finally, figured out how to fix this. When you log into the new ssh session, do not enter the passphrase, just control-c out of it. Then do screen -r -d like normal, you’ll find that your key is still loaded.
