How To Import a MySql Database

 *NOTES*: You may have to replace quotation marks entry with fresh keystrokes. Also be sure the database you are importing matches the software version you are importing into. Many errors happen from people updating and trying to import older databases.

HOW TO IMPORT MYSQL PHPBB DATABASE
(Go to SSH command screen)
(Entre location of folder with DB)

cd /home/sites/domainname/www/
(this is home directory for site on server)

MANUALLY GO TO PHPMYADMIN AND DROP DB

NOW, RECREATE SAME DATABASE NAME

(Import the backup)
mysql -u root -ppassword “dbname” < dbname.sql > /dev/null

Forums Reach One Million Mark

I was just informed my forum network hit the one million mark for queries last month. Still a fraction of our former traffic – but a very good sign considering we’re only running a portion of them. I’ve been waiting to hit that mark before expanding, so now I’m going to open up ALL former forums. All those niche subjects that many of you had a passion for will be up and running within 10 days.

After that I’ll be reformatting the ecommerce networks. Ah….life is sweet.

40,000 Spam Milepost

Here just on my personal website I have reached the 40,000 spam milepost. Over forty thousand spam comments have been filtered and deleted. Thanks to the Akismet plugin it is all automated and I don’t have to do anything. That’s one of the main reasons I chose WordPress over other blog platforms.

Network wide the spam blocks run into the tens of millions. From what I’ve read most spam is generated by a handful of people. The people that generate the spam don’t make money directly, they make money selling the service to other webmasters who think it will increase their rankings.

The recent proliferation of spam is in part from amateur spammers now using automated programs like Xrumer. My original article on Xrumer, which is quoted as a source now on Wikipedia, can be found here: Xrumer Link Scam Article.

Everyone’s tempted to make money – but do this one thing before you think about investing in an automated link spam program. Take any of the spam links you have seen generated by the program in the past and do a search on their anchor text or keywords. You’ll find they don’t rank. They are quickly banned. The money is not in the links, the money is in SELLING the service – which doesn’t work for long term SEO.

Someday I’ll post the gruesome details of my own experience and over zealous, xenophobic SEO. It doesn’t work anymore. And I’m glad it doesn’t. The web is much more useful now that most pedestrian black hat SEO has been fielded out.

I can tell you it is MUCH more enjoyable now to work on genuine service, than just trying to manipulate SERPS. It is never satisfying enough, you always need a little more. But helping people out, like this post here, is enjoyable on a minute to minute basis.

In a person’s last minutes of life, they will not think of how much money they made….

The Brilliance of Steve Buscemi

 steve-buscemi.jpg

Steve Buscemi – You know his face from nearly 100 films. One of the most recognizable faces in Hollywood. He hits the nail on the head with this excerpt from a recent interview. When working with artists, let them bring their own vision to the table first. Then tailor it as it fits the directors vision. If you don’t give them the chance to do their thing, you miss out on many golden gems.

Q: How does your background as an actor affect your directing?

BUSCEMI: Casting is everything. Getting the person that you imagined is this character and then seeing what they bring to it. That’s why you hire them, so why tell somebody first what it is you want? I’m more curious to see what they bring to it and then be inspired by it and say: “OK, what if you tried this?” or “What would happen if … ?” I guess it’s the stuff that you don’t get to say as an actor to another actor if you’re just acting in a scene. (Laughs) You cannot do that.

Network Vultures

lol.jpg

Recently we had some individuals open a site meant to be an adjunct of one of my own. Only problem is they didn’t ask me about it before they did it. Adjunct sites that spin off my network and are advertised on my network are considered spam; just as if they were a seperate site spamming links.

In fact, they ARE seperate spam sites if they are not approved. My networks have been running for over seven years now and it has been an arduous task to keep them running, many as free public services. It’s not taken kindly to glom off of my networks as jumpads for websites outside the network. Many people have done this in the past, and most claim the best of intentions. I still don’t understand how they can genuinely think it is helpful.

That’s my stance. If you had been through what I have been through the past seven years committing to these networks, I’m confident you would feel the same. For the record, the “Am” referred to in this graphic was reinstated. We have an understanding now.

One more thing. Many people that create the spinoff sites are friends, or at least were friends prior to the spinoffs. It causes hurt when they are blocked on my networks. I think it may be partly that they do not realize how large my networks really are. Everything I do has to be done in runs; it’s like herding sheep. When I make a change to one I make a change to all – so committing to changes is time intensive and something I think through at great length before doing.

In addition, many people do not realize security issues at risk with some of their requests. I do not post the details of those security issues, because (duh) it kind of defeats the purpose.

I have had the experience in my life of being on the very top, and also being on the very bottom. I have noticed that the more you move up, the more people glom off you and use you as a target. You are a target because you are noticeable. That’s just the way things are. As our networks continue to expand, things will get more complicated; not less. With increased traffic there is always increased problems.

Members banished from RD may start fresh at Life-Convicts.netÂ

Please play nice in the sandbox.

freenemvb5.png

Bye Bye Birdie – Musician Page

This is the official musician info page for META Performing Arts production of Bye Bye Birdie at McIntyre Hall, Mount Vernon, WA 2007.
NEWS
09/26/07 – Scores are in. Pick up at Mount Vernon Presbyterian Church, 15th and Broadway. 9am-4pm Mon-Fri.
BYE BYE BIRDIE ORCHESTRATION

Violins – closed RH (keys)

Cello 1 – closed Joe Bichsel
Cello 2 – closed SS

Bass – closed PB

*NOTE* – We will split reed parts up dependent on what players can double on.*

Reed Ia: Alto Saxophone – closed KM
Reed Ib: Clarinet,
Reed Ic: Flute & Piccolo – closed LS
Reed II: Alto Saxophone – Thomas Harris
Reed II: Clarinet – open
Reed III: Tenor Saxophone, Clarinet – closed MH
Reed IV: Clarinet, Bass Clarinet & Baritone Saxophone – closed RW

Horn – closed AM
Trumpets I – closed CL
Trumpet II – closed NV
Trumpet III – cut
Trombone I – RQ
Trombone II – cut

Piano – closed LL

Keyboard II – closed KK
Glockenspiel, Vibraphone, Xylophone, Chimes (from percussion part)

Percussion I: – open – MEH? unconfirmed
* Timpani (2 drums), * Tambourine, * Timbales, * Gran Cassa, * Snare Drum Case, * Suspended Cymbal, * Castanets, * Gourd, * Cowbell

Percussion II: – closed DB
* Trap drum set-
o Bass Drum
o Snare Drum & Rack Tom
o Floor Tom
o various Cymbals
+ hi-hat
+ crash
+ ride
+ finger
o Wood Blocks (2)
o Bongos
o Large Military Snare Drum
o Gong
o Gunshot
* Kazoo (or Ratchet)

Both percussion players use Piatti, Triangle and Ratchet

1 Guitar-Banjo – closed LH
(Banjo for “Overture A”; Electric Bass for “Telephone Hour” and “One Hundred Ways – Ballet” only)

A special Keyboard Synthesizer part is available, when the complete orchestration is used, at an additional charge. It may be substituted for the 3 violin and 2 cello parts.

SHOWS
McIntyre Hall – Mount Vernon, WA

Nov 16 Friday 7:30
Nov 17 Saturday 7:30
Nov 18 Sunday 2pm
Nov 23 Friday 7:30
Nov 24 Saturday 2pm and 7:30
Nov 25 Sunday 2pm

REHEARSALS
Sat Oct 13 – 2pm-5pm – Orchestra – MVPres Church
Tue Oct 16 – 9-11pm – Rhythm section only (drum, guitar, keys) – MVPres Church
Sun Oct 21 – 1pm-5pm – Orchestra – MVPres Church
Sat Oct 27 – 1pm-5pm – Orchestra – MVPres Church
Thurs Nov 1 – 6-10pm – Music only w/cast – MVPres Church – Good Shepherd Hall
Sat Nov 3 – 1pm-5pm – MVPres Church
Thurs Nov 8 – 6-10pm – Run thru w/cast – MVPres Church – Good Shepherd Hall
Wed Nov 14 – 6-11pm – Tech with Orchestra – Load in starts 5pm. McIntyre Hall.
Thurs Nov 15 – 6-11pm – Dress Rehearsal McIntyre Hall.

SCORES
Scores in 9/26 – pick up at MV Pres Church. 15th and Broadway, Mount Vernon -9am-4pm.

RHS Musician Page

This is the official page for musicians in TAG’s production of Rocky Horror Show at the Lincoln Theater, Mount Vernon, WA in 2007. All info will be updated for musicians on this page.

PHOTO SHOOT
Thursday Sept. 20 – 8pm – Mark Cook Photographics

INSTRUMENTATION

Piano/Conductor – Closed
Synthesizer – Closed
Bb Tenor Saxophone – Closed
Guitar – Closed
Bass Guitar – Closed
Drums – Closed

SCORES

08/30/07 – Scores are in. Pickup at MVPres starting Tuesday 9/4/07.

SHOWS
(All shows 8pm – call time 6:30pm ready to go. Opening night call time is 5pm).

Fri Oct 26
Sat Oct 27

Wed Oct 31 – Halloween
Thurs Nov 1
Fri Nov 2
Sat Nov 3

Thurs Nov 8
Fri Nov 9
Sat Nov 10 – Closing night *MIDNIGHT SHOW ADDED!*

REHEARSALS

Thurs Sept 20 – 9-11pm – TAG Rehearsal Space
Thurs Sept 27 – 9-11pm – TAG Rehearsal Space
Saturday Sept 29 – 10am-3pm – TAG
Saturday Oct 6 – 10am-3pm – TAG
*CHANGED* Tues Oct 9 – 6-10pm – Music w/cast – TAG
Thurs Oct 18 – 6-10pm – Run through w/cast – TAG

Wed Oct 24 – 5-11pm – Load in and tech – Lincoln Theater
Thurs Oct 25 – 5-11pm – Dress rehearsal – Lincoln Theater

Lincoln Theater Location
712 South First St. – Mount Vernon, WA.

SCORE EDITS
Sword of Damocles – Key transposed from D down to B

PRE SHOW ACT I

  1. Spooky Organ
  2. Adam’s Family Theme
  3. Munsters Theme
  4. In the Hall of the Mountain King
  5. Funky Town
  6. Deliverance – Short
  7. Haunted Mansion Theme
  8. Halloween Theme Grunge
  9. Haunted Mansion Samples til ready for PreShow
  10. BEGIN PRE SHOW – I WILL SURVIVE
  11. Viagra song (Betty) One time through only
  12. Welcome
  13. Explanation and Calling Up of Virgins
  14. Virgin Pledge – All Virgins in audience also stand up
  15. Virgin Sacrifice – Onstage virgins and audience virgins standing up
  16. Orgasm Contest
  17. Rocky Pledge of Allegiance
  18. Explanation of ROCKY Protocol, cellphones off, etc
  19. “ARE YOU READY FOR ROCKY”
  20. BAND BEGINS OVERTURE
  21. R-O-C-K-Y (In overture when solo kick drum starts)
  22. Show Begins

– http://themeparks.about.com/cs/disneyparks/a/hmsong.htm

BETTY DESIRE PRESHOW

Have someone walking through audience selling condoms, like a vintage 1920’s cabaret cigar girl.

PRE SHOW ACT II

  1. Toccatta and Fugue in D minor – organ solo
  2. Stand By Your Man – band w/Peter
  3. Hello My Darling
  4. Rainbow Connection – no band
  5. Rocky Act II Overture

VIRGIN PLEDGE:
I virgin scum,
do hereby admit,
infront of all these people (wave),
that I am a Rocky Horror Virgin.
I wish to lose all my morals
and accept decadence into my heart.

VIRGIN SACRIFICE – To sacrifice a whole theatre full of virgins. Simply have the group stand and make that stick-your-finger-in-your-mouth-and-pull-it-out, champagne-cork-popping noise. It’s a marvelous simulation of all their tender cherries popping, and truly a great effect if you can get them to all do it at the same time.

ROCKY PLEDGE OF ALLEGIANCE:
I, State Your Name,
Pledge allegiance to the lips
Of the Rocky Horror Show
And to the decadence for which it stands,
One movie, under Richard O’Brien,
With Sensuous Daydreams, Erotic Nightmares, and Sins of the Flesh for All!
And I promise to be creative and not repeat anything anyone else says.

R-O-C-K-Y – (To audience) “Give me an R!” Spell Rocky. Then show begins.

CUT ******************************

TWINKIE CONTEST – Have several virgins compete to see who can suck the filling out of a twinkie the fastest. Band play “I Dream of Jeannie” theme in background.

WHEEL OF DOOM – For the virgins and regulars. A wheel of fortune, but with embarrassing acts written upon it. Virgins spin the wheel and perform the act, and then win a prize. Wheel can have numbers or pictures of characters that correspond to envelopes which contain acts. You can have one set of easy acts for virgins – and another set of more outlandish acts for regulars. Host draq queen becomes Vanna White and band plays Wheel of Fortune theme song.

FLUFFY BUNNY FEET – For onstage virgins. Get three virgins to say “Fluffy Bunny Feet”. Insert marshmallows into their mouth (they’re not allowed to chew or swallow). Repeat above procedure until they either spray marshmallows everywhere, can’t say “Fluffy Bunny Feet any more, or you run out of all your marshmallows.

Learning Cantonese Chinese

The Cantonese language is spoken by approximately 65 million people in the southern China provinces, Hong Kong and Macao as well as other South East Asian countries like Singapore, and in the other large Chinese communities around the world.

Also called Yue, Cantonese is one of the five major languages in China. The Cantonese language is from the Sino-Tibetan family of languages.

The word “Cantonese” originates from the former English name of Guangzhou, which is considered as the area where the language was born in its purest form. The city of Hong Kong, now an autonomous province of China, is the contemporary hub of the Cantonese language and culture.

The Cantonese language is the principal language in Chinese communities abroad because most Chinese immigrants came from Hong Kong. Cantonese is the language predominantly used for business around southeast Asia.

Colloquial Cantonese language is a constantly evolving language, with a large amount of fashionable expressions and slang words. Cantonese grammar is simple, with no verbs conjugations, and no prefixes or suffixes.

Responses to the Big News

Apparently not all visitors to my website are geeks. For those people that are NOT geeks, my heart goes out to you. For ye see laddie, Geekdom is a proud place and it’s inhabitants are fiercely loyal to each other.

It has been upsetting to some that I posted my “BIG NEWS” announcement in *binary – Click Here For The Original Post.

First response received is: “I fired my tech, he can’t decipher your code” and included this image attachment:

firedmytech.jpg

Ok, that was pretty good.

Second response was: “Whad’ya suggest for those of us who ain’t got no Captain Kangaroo magic ring?” along with this beautiful picture.

yep.bmp

Third response was: “Aha girls, we did it. We cracked the code!” and included this photo:

2037joannastefmecheryl.jpg

And the fourth response was posted as a comment by Tony on the thread itself: “Congrats.” So I know I have at least one fellow geek friend out there. And that’s all I have to say about THAT.

*For non-Geeks, that’s the big hint right there. Nudge-Nudge-Wink-Wink.