brian habbe | window to my world

August 29, 2009

Heart Worms

About a week ago at the dog park I found some worms in Coopers’ stool. A trip to the vet the following day confirmed they were whip worms. While there they asked if I wanted to do a heart worm test, I couldn’t remember the last time Copper had one so I said “sure”. That test came back positive.

The vet started treatment that day and we’d be back to pick him up two days later. When picking Cooper up we took Roscoe along to have him tested as well, he came back positive too. Roscoes’ treatment was only half what Coopers was. Roscoe has a few challenges when it comes to “drugs” and temperature so we opted to do half now then go back for another round in four weeks. It has been an interesting the first week to say the least.

Cooper has been running a tempature, 103 this morning, so I had the vet check him and picked up some drugs in hopes it would get it under control. He hasn’t been eating very well so getting that back to normal is key. Roscoe on the other hand had a couple rough days but he’s back to his old go go go self. Unlike Cooper he’d prefer walks or the park to hanging out on the deck all day. They are opposites in many ways.

The coming weeks will be a challenge, balancing limited activity the medicine needs to kill off the heart worms but still keeping the boys from being restless. Time will tell and we’ll hope for the best.

Filed under: Personal
Tags:  

August 4, 2009

Server move

Use at your own risk and always backup your data

The site moved to a new server today and I had to scramble a little, I thought they would just increase my disk space not put me on a new server. I was able to grab Kay’s mail, backup the WordPress database and site files before the dns propagated. Putting files back in place would be easy but I wasn’t sure about restoring the database. The main reason was they gave me a different admin login which means the database would be owned by a different user and table prefixes would change. But as always there should be a way, and there was.

I had to do something similar years ago for some reason I don’t remember so I set out to do a little searching. First stop was the Word Press page for moving a site. That led me to restoring your database from a backup and then on to something with pictures.

I followed the directions but had to add my own twist since the new database would be named different than the old one. Unfortunately that was out of my control.

    Again that was due to the provider giving me a different admin login than what I had for the old server.

Since I had backups of my database, specifically a .sql backup, I opened it in a text editor (gedit) to review. I didn’t have to look hard to see anywhere I saw the old name I could replace it with the new one. After making a copy of the original, always make a copy, I did a simple Search Replace and save. Following the instructions I then “dropped” the existing database … but there was nothing it is since is was fresh from an install so no harm no foul, then imported the .sql file using phpMyAdmin. There I ran into a small problem. The .sql file had a statement in it to create a database, but in my case it already existed. Easy enough, comment out the CREATE.

/*CREATE DATABASE `<database name>` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `<database name>`;
*/

With that out of the way import again and success !! I go to the site and all is well, nice. The internet does it again, a wealth of information at your finger tips…. and a little bit of logic.

Note: Standard changes to wp-config.php apply, if necessary. Since I dropped the database created on the new server and imported my old one my password did not change.

Filed under: Personal
Tags:  

Powered by WordPress