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.

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

Windows XP on a mac for NCARB practice software

So, unlike options for  Microsoft windows, I don’t know of any free virtual machine software packages for the mac to run windows XP on. There are some relatively inexpensive ones though… I use Parallels, its popular, has a bunch of features I use for other stuff, and is what this tutorial covers.

The tutorial is two parts… 1. getting / downloading the software and 2. installing everything

Click the More link below to see the steps involved in both parts.

Continue reading “Windows XP on a mac for NCARB practice software”

Stop SOPA

If your unfamiliar with SOPA, your can find out more about it here… but essentially it is a bill currently being discussed that is supposed to protect itelectual properties from being pirated illigally on the internet… such as movies and music. However this bill would cause more damage than good… First of all i doubt it would seriously stop online piracy… however it would swing the pendulum over way to the other side and make it way to easy for various parties to limit information that passes through the internet…

Essentially this would fatally damage the way the internet is free and open to all information, and these types of bills could make it way too easy for someone to control what information is passed through the internet… making search engines, money transaction sites, information sites like Wikipedia, and other major information avenues of the internet stop showing results from sites they deam to be “illegal”. These types of bills would be the start of a major censorship of what Americans see on the internet, defeating the main reason behind the internet, which is sharing of information… any information… the point is we currently decide what to believe and what to discard… we should not let someone else decide what we see and what we should not…lets keep that right… contact your representatives… call them if you can… it’s more powerful than an email… but of you can only do one at least email them… you can find out who your reps are through this link on Wikipedia… which blacked out its entire site today (2012.01.18) in protest of this bill. I did both… if your looking for what words to say in your email to your rep… this is what I wrote to help in your inspiration, or if you just want to copy and paste… go for it… the point is to let our congress people know what we want.

I am writing you today to let you know my family and I are against the SOPA act, PIPA, and similar legislation. Although I understand online piracy is an issue, I strongly believe these types of legislation would not stop piracy, and would in fact cause serious damage to the free and open Internet. I hope you will (or do) understand the ramifications of a bill that would allow any party to manipulate any DNS information, as well as other issues these bills would cause to limiting the “passing on” of information for future generations. my fear is that this type of bill will give to much power and control of limiting a currently free information highway, and could easily be taken advantage of to prevent freedom of free speech, freedom of information, and other freedoms that every united states citizen currently has a right to. I hope you consider my words here and vote in opposition of SOPA, PIPA, and similar legistlation.