Easiest way to move WordPress to a new linux server

So I got a new box, installed fedora 25, configured everything I wanted… but was having a pain in the ass time migrating my WordPress sites to the new one. ~Insert moving sucks joke.

 

I’m no linux expert by any stretch, but I most of the issues was with the sql databases, as I was using phpmyadmin but error’ing out due to the size of the db’s and the gui just not  doing what it was supposed to. This was the easiest way I was able to do it was in command line following these steps

  1. On the old server your moving from… export the sql database for the WordPress site your moving and also download the wp-content directory. Put these in a directory on your new server… I stuck them in /var/www/tmp/oldwordpress.sql + /var/www/tmp/wp-content_OLD
  2. On the new server Setup a new black clean WordPress install directory and attach it to a clean db. We will eventually move / delete these but I setup a clean new WordPress site to eliminate any unknown issues and know that WordPress is running correctly when installed fresh.
  3.  Ok… so now the files we need are on the new server and its just a matter of importing and placing them where they need to go. Lets create a new sql database doing the following… assuming you have an sql root password already setup… if not you can google how to set that up on most “installing WordPress” tutorials. Bold text such as mywpsite should be changed to what you want it to be named…
sudo mysqladmin create mywpsitedb -u root -p
sudo mysql -D mysql -u root -p

MariaDB [mysql]> GRANT ALL PRIVILEGES ON MYWORDPRESSDB.* TO 'SQL_USERNAME'@'localhost' IDENTIFIED BY 'PASSWORD';

MariaDB [mysql]> FLUSH PRIVILEGES;

MariaDB [mysql]> QUIT;

Ok… so now we’ve created a DB and an SQL user name and password… lets import our old sql tables by navigating to that file directory and manually importing them… remember to change bold text to your actually file names and credentials

cd /var/www/tmp
mysql -uSQL_USERNAME -pPASSWORD DATABASE < oldwordpress.sql

all your old tables should be associated with your new database now. Next step is to import all the content to the new WordPress install you have.

yes | cp -R /var/www/tmp/wp-content_OLD/* /var/www/newwordpressdir/wp-content

now edit the wp-config and change the values to point to the new database with the credentials you setup

nano /var/www/newwordpressdir/wp-config.php
// ** MySQL settings - You can get this info from your web host ** //

/** The name of the database for WordPress */

define('DB_NAME', 'MYWORDPRESSDB');

/** MySQL database username */

define('DB_USER', 'SQL_USERNAME');

/** MySQL database password */

define('DB_PASSWORD', 'PASSWORD');

last thing is to make sure you change ownership of the wp-content directory to apache if its not already.

chown apache:apache -R /var/www/newwordpressdir/wp-content

hopefully that works now, it did for me… you should be able to login and see all your plugins, themes, posts, etc working as it was on your old server.

Blinking Cursor after Fresh Win7 Install : Solved

black-screen-with-flashing-blinking-cursor

The issue was the install was not replacing the GRUB loader correctly on the HD, even though the install process should have been…. heres the story and fix.

I replaced a hard drive in a computer, and tried to install windows 7pro 64 on it. The install copied/expanded files and did its thing… however after it rebooted to finish the last piece of the install… i saw the manf. splash screen as expected, then it just went to a black screen blinking cursor… for ever

~~In before you say did you…
-made sure the DVD was out
-rebooted multiple times
-made sure bios boot order was to HD first
-reinstalled OS again, deleting partitions and fresh formatting
-tryed F8 to boot into safe mode after install… nothing

So then I figured out if I hit F12 as prompted to change the boot order I saw the HD, DVD, etc… but also windows boot manager… if I did that it finished the last leg of the install… .but upon further reboots it does the same thing… so overtime I rebooted I had to make sure I hit F12 and select windows boot manager.

Technically thats a fix, but its not very user friendly, especially when you power it up and forget to hit that.. The issue was the GRUB loader on disk was not being overwritten correctly, so I did some more digging on the inter webs and found you can manually scrub the GRUB loader during install, and that worked….

The fix required me to reinstall again… but whatever at this point… what’s one more wipe and install

-boot from DVD/CD and start reinstall of windows process.
-@ the second install window hit Shift+F10 to get cmd prompt
-type the following commands… waiting for each one to complete before you go to the next.
diskpart
list disk
select disk 0
 <– if only one drive
clean
exit
exit

I then went through the rest of the install and the fist worked.

Although, i should mention I also did not partition / format the drive this time though. The command above deletes all portions, and this time I just selected the unpartitioned space for the install and let windows auto create the portions it needed .

If your here reading this… hope the fix works for you.

Traveling the Road or Architecture

aprenti_ellia I slept on a cot in the loft of the shop, cooked on a portable burner, and walked my dirty dishes through the garden to the basement sink. Curtis Buchanan walked in at seven one morning to discover white splotches on a pair of freshly painted chairs waiting to be delivered. Oatmeal-water splotches. He tried re-oiling, steel-wooling and every trick learned in his 25-year-career.

For the unfortunate reader who has never seen Curtis’s black-on-red paint job: It is a stunningly beautiful finish. It’s also a laborious undertaking involving five coats of paint, finger-numbing rubbing with steel wool, then several coats of oil followed by rubbing, wax and more rubbing. So when Curtis said there was nothing for it – I would have to scrape the seat down to bare wood so he could repaint it – I knew how much work that meant for him. But he didn’t tell me to cook outside from now on; he never said a recriminating word.

Several years earlier Curtis had agreed to have me – a 17-year-old kid – spend a week in his Jonesborough, Tenn., Windsor chair shop. I split logs for him and he showed me a few things. I became Curtis’s sole apprentice, though my position was never formalized. Ours was a relationship built on trust, not on words or papers.

Curtis is, in 18th-century terms, my Master, but I also learned from others. With the housewrights at Colonial Williamsburg, I handplaned the doors for Payton Randolph’s purple storage shed. Arranged by Roy Underhill, that opportunity had its start years earlier:

“That’s Roy Underhill!” shouted my mother, as we walked through Colonial Williamsburg. With her more-than-slightly embarrassed son in tow, she proceeded to explain to the ever-interrupted Roy that her 8-year-old son watches “The Woodwright’s Shop” every week and loves building things. Then she asked a question no sane 20th-century mother would ask: “Where can Elia get a woodworking apprenticeship?”

Perhaps fate and mothers walk hand-in-hand. I now teach at Roy’s Woodwright’s School.

If there is one iconic tool of the chairmaker, it is the drawknife. In my youth, both Drew Langsner and John Alexander taught me the tool’s use; I had the drawknife licked – or so I thought.

In Jonesborough, Curtis effortlessly whittled a complicated chair spindle, handed me the drawknife, and told me to make him some spindles. The firewood box claimed my first three; the rest had some slight potential. Four or five years later, I was making spindles as fine as Curtis’s and I was happy.

One January I embarked on my Great Northern Tour, the ultimate goal being the Vermont home of Curtis’s mentor, Dave Sawyer. Dave is an MIT graduate who builds a chair like a Ford truck – precisely by the plans. He wanted me to carve spindles. No problem, I thought. I’ve whittled hundreds of spindles. The first took 10 minutes and landed in the wood stove; the next claimed 15 minutes with a similar end; the third took 20 minutes only to join its charred and flaming friends. Dave said, “I carve spindles – ‘whittling’ sounds rough, like a Boy Scout with a pocket-knife.”

Slowly, I realized that craftsmanship is not a destination, but a road to be traveled. Rather a pretty drive, but with detours, potholes and the occasional oatmeal splatter. PWM

Elia is a professional Windsor chairmaker who lives and works in Chatham County, N.C .

 

I came across this little essay by Ellia Bizzarri in a newsletter from popular woodworking. Now that I am a licensed architect… I thought “woodworking” could easily be replaced with “practicing architecture” as well. Anyway… I thought it was a good bit of writing and thought I would share it here on my blog.

Staff Training Mini-Site

office_training

So I’ve decided with the exuberant amount of spare time I have (that was sarcasm) I’m creating a training site for the production staff of TMS Architects, where I work as a project architect / technology manager / fantasy football commissioner / comic relief / nice guy. ( I wear many hats)

This project also comes with a youtube channel, where I can make tutorials and post the to the mini training website I created for my office… creatively titled www.training.tmsarchitects.com. My plan is to use the mini-site as a springboard to organize and search through the videos I’ve make and post.

That was about a year ago and I have 3 videos so far… but hey, at least its something. The videos I do have are informative though… I’m hoping some of the videos will have a broader audience and be utilized on a national planet galactic wide (english speaking of course) level that also utilize the same software packages and techniques we use in my firm. One of the first videos I created was advance in technique, and specifically on how to create a 3d eyebrow dormer in vector works… if you don’t know what an eyebrow dormer is never mind how to model one in 3d… well have a look at this vid

I don’t need no f*ckin’ case on my phone

17zsfmvps23j0jpg

Every day, I carry one of the most advance pieces of technology in the known universe. Not too long ago, people wouldn’t be able to fathom the capabilites this device can do for me . Add to this the fact that the device is so well designed and precision engineered to the micron that its able to fit in my pocket… well then… now we got something really special. So special circa 2006’s James Bond would be envious, and 1964’s Bond would think I’m from space its so far out of his league of imagination.

And I don’t have a case for this device…  Because, unlike my grandma, I don’t cover my sofas with plastic.

So I cracked….errr…. shattered my iPhone 6 like the second week I got it. The screen and digitizer were more than i liked to pay, so as self punishment I lived with it for a few months… I’ve finally ordered the new screen this week. Friends and family keep asking me though… are you going to get a case now?

F- NO

haha… this post from gizmodo pretty much sums up why. I thought it was a really good editorial tech piece of writing I thought I’d back link to it here incase anyone hasn’t read it yet.

http://gizmodo.com/5945198/you-dont-need-a-fcking-case-for-your-iphone-5

Vector works Workaround: Missing POI Glazing

vw_missing glazing

Ever have your window and door PIO in vector works mysteriously not show glazing in OpenGL… happens in VW version 2015 SP3, as well as some previous versions that I’ve noticed… for me it usually renders fine in rendtrworks  or other views… I’m not 100% positive why this happens… I used to fix this by going to the settings of an individual PIO (window or door) and not even modifying anything, just clicking ok to get out of settings and it would not only fix the problem of that particular PIO, but the rest of them in the wall that it was attached to as well… easy enough, but this sucked if you had a crap load of walls on mulitple levels…

A better work around is to simply edit the entire layer… simply change the height,  click ok, then edit it again and change it back to what it’s supposed to be… See the image in this post. You’ll have to do this to each layer, but it’s less tedious than each wall… hopefully Nemetschek fixes this bug, until then I hope this helps you if you come across this and find this post.

Vectoworks 2015 = workflow improved

I use Vectorworks by Nemetschek at work as my main CAD software for drawing (2d and 3d). I’ve been using it since 2009, and have become pretty efficient with it. Recently we upgraded to the latest software build, Vectoworks 2015, and I’ve been using it for about a month now. I must say though I could scream with joy over the ability to add 2d hatches to 3d textures, but instead will blog about it :).1_2015_noannotation hatch

It’s improved my workflow significantly.  Thanks Vectorworks crew!

Story: I kept dabbling in brining my elevation drawings to a full 3d workflow…

Continue reading “Vectoworks 2015 = workflow improved”

Hi

If you’ve been to my site before and you your like… wtf.

… well thats because my server is having hardware issues, and I’m currently in the process of transferring the various sites I host over to the new server. Hopefully things will be back to normal soon enough, so come back.

 

undercon

Cheers,

Tim

Microsoft Virtual CD Drive… it exists

Screen Shot 2014-03-02 at 3.52.50 PM

Ever download an .Iso image file of a CD… sometimes manufacturers provide these “virtual CD” files with instructions on how to pop in a blank CD so you can write the file to the CD for use…

well you actually can skip that step and mount it directly in a virtual CD drive… eliminating the time to burn and wasting a blank CD. You could always do this with virtual drives, I often used Virtual Clone Drive, but found out today that Microsoft actually makes one available as an update to the operating system of windows XP, Vista, and 7.

I haven’t used it yet personally, but found it looking for something else on Microsofts website… you can download it here… I probably will at some point.