Setting up a Wordpress Test Site
Tuesday, April 21st, 2009 by Jonathan Lau
If you’re a Wordpress plugin or theme developer like we are, there might be times when you wanted to have a live demo or showcase on the cool stuff your plugin can do. However, most plugins are only configurable by administrators of the blog, and giving out admin permission on your Wordpress blog can be disastrous. Want to let your users have full admin access without compromising security? This post briefly runs through a few quick steps to get you started!
Before you Start
If you would like to have an example to play around with before you start, you can visit CubePoint’s live demo site here:
http://cubepoints.techcube.net/
What you Need
- A hosting account separate from your main sites (with cron jobs supported)
(that’s basically all you need!)
A Note of Caution!
In Wordpress, an admin account can potentially upload files with any file type (yes, including PHP). This can be harmful! To secure your set up, you are required to CHMOD all your files to 755. As such, we strongly recommend that you use a separate hosting account (you can use one of the many sites that offer free hosting) solely for this purpose.
Disclaimer: while nothing should go wrong by following this instructions, we are not responsible if anything happens (e.g. server crashes, files gone, site hacked, explosion of server – just kidding).
Getting Started
- Grab the latest stable copy of Wordpress from here:
http://wordpress.org/latest.zip
- Unzip, upload and install
(like you would normally do)
Customising your Install
- Install your plugin / theme
(remember to activate them through the admin panel)
- Tweak and configure the site to your liking
(remember to set a welcome page containing the admin password)
- Allow public signups and grant administrator privileges to all new users *optional
(if someone changes the admin password, others can still get immediate access by signing up)
- Finalise how you would like your site to appear
(check that everything is to your liking as changing something after this step would be difficult)
Setting Up
- Export mySQL Database
(you can do this from phpMyAdmin, usually found in your host’s control panel)
- CHMOD EVERY file and folder to 755 (including parent directories) *IMPORTANT!
(this is to prevent anyone from uploading any malicious scripts to your account)
Schedule Automatic Restoration of Site
Although your site should be secure by now, people sometimes try to ruin it by removing all your test accounts or adding rubbish to the homepage of your test site. As such, we would want to restore the site to its original state hourly or daily. All post data are stored in the mySQL database, so restoring your old export would do the trick here.
- Writing the Script
A PHP script would be needed to restore the original exported mySQL database. We have saved you the trouble by providing all you need here. All you have to do is change your database settings and upload the file! Upload your database export as well.Note: If possible, upload this in a folder outside your public web root<?php // Name of the file $filename = 'database.sql'; // MySQL host $mysql_host = 'localhost'; // MySQL username $mysql_username = ''; // MySQL password $mysql_password = ''; // Database name $mysql_database = ''; ////////////////////////////////////////////////////////////////////////////////////////////// // Connect to MySQL server mysql_connect($mysql_host, $mysql_username, $mysql_password) or die('Error connecting to MySQL server: ' . mysql_error()); $query = 'DROP DATABASE `'.$mysql_database.'`'; mysql_query($query); $query = 'CREATE DATABASE `'.$mysql_database.'`'; mysql_query($query) or die('Error: ' . mysql_error()); // Select database mysql_select_db($mysql_database) or die('Error selecting MySQL database: ' . mysql_error()); // Temporary variable, used to store current query $templine = ''; // Read in entire file $lines = file($filename); // Loop through each line foreach ($lines as $line) { // Skip it if it's a comment if (substr($line, 0, 2) == '--' || $line == '') continue; // Add this line to the current segment $templine .= $line; // If it has a semicolon at the end, it's the end of the query if (substr(trim($line), -1, 1) == ';') { // Perform the query mysql_query($templine) or print('Error performing query \'<strong>' . $templine . '\': ' . mysql_error() . '<br /><br />'); // Reset temp variable to empty $templine = ''; } } echo 'Database Restored'; ?> - Set up cron to execute the script
Execute: “PHP /full/path/to/script/restore.php”
(We recommend that you set this to once every hour or every few hours)
Test your Site
Once you done all the above steps, you should do some tests to make sure everything is working as intended.
Tips & Tricks
- Show a countdown timer to let users know the duration before the next site restore.
- You may temporarily set your cron jobs to every minute to test out if it works. Just remember to change it back after you are done testing.
- You may want to create more than just one account so that people have alternative logins if someone changes the admin password.
That’s all! Any better ways to secure these these? Any security flaws?
Do share your feedback / questions or successes in the comments below!
July 24th, 2010 at 7:24 am
Cheers for this article. Web Hosting can be quite challenging to choose if you’re trying to find a new provider. It could also be hard even when you do have a hosting company as problems can still occur in the near future, such as with downtime or customer support issues. That is why choosing the right hosting company is important, so you don’t face issues in the long term.
July 27th, 2010 at 1:06 pm
Thanks for your visiting this http://www.glamour-watch.com online store.
July 28th, 2010 at 7:15 pm
Thanks for your visiting this http://www.hello-free.com online free stuff online.
July 29th, 2010 at 8:40 pm
Good post. I need to start working out more. Need to find me a scholarship for moms too lol gosh!
July 30th, 2010 at 3:27 am
As a Freshman, I am always researching online for articles that can help me get further ahead.
August 3rd, 2010 at 11:17 pm
Hello, my group is just establishing our first website, searching and working out what is needed. This blog stuck out right away. I’m fired up about this, and adore the design of your site. Are you able to let me know what “theme” it is?
August 5th, 2010 at 2:30 am
Wow this takes me back. Adding to my bookmarks thanks.
August 5th, 2010 at 4:22 am
I’m impressed!! Really informative blog post here my friend. I just wanted to comment & say keep up the quality work. I’ve bookmarked your blog just now and I’ll be back to read more in the future my friend! Also nice colors on the layout, it’s really easy on the eyes.
August 5th, 2010 at 7:40 am
Hi everyone, i discovered really good things about this great site. and was wondering what’s the main difference between it and what you have wrote about ? might anybody recommend which is certainly better ?
August 5th, 2010 at 10:42 am
Thank you for your blog post.Really thank you! Really Cool.
August 6th, 2010 at 3:28 am
When my twins were born 16 months ago, I wanted to have a new cam corder to capture every one of the beautiful moments with them. I don’t know if there were FLIP available on the market at the time, but no one had informed me regarding it. So i got another camcorder but I had a difficult time to convert the videos on my PC in order to see them and I couldn’t share any videos with my family and friends. And I thought it was small! Now I’ve the FLIP and this is the best! I really like my FLIP! It’s user friendly and we were surprised about the quality of the videos! I just wish I had had it before!
August 6th, 2010 at 7:02 pm
I love reading your web site.
August 6th, 2010 at 10:53 pm
Just fyi, your site looks funny in google chrome
August 7th, 2010 at 1:58 pm
Advantageously, the post is in reality the freshest topic on curing acne naturally. I concur with your conclusions and will thirstily look forward to your upcoming updates. Just saying thanks will not just be enough, for the phenomenal clarity in your writing. I will right away grab your rss feed to stay abreast of any updates.
August 7th, 2010 at 6:20 pm
Thanks for the read, I will bookmark it and come back later to check out some of your other posts =)
August 7th, 2010 at 6:27 pm
Amazing, truly excellent information. Your blog is really awesome. I bookmarked this and will come back once again. . . .
August 7th, 2010 at 9:02 pm
Thank you so much for this valuable information. Very useful indeed. . . . .
August 8th, 2010 at 1:00 pm
If you want to buy real estate, you would have to receive the loans. Moreover, my brother usually uses a small business loan, which is really firm.
August 8th, 2010 at 4:06 pm
A round of applause for your post.Really looking forward to read more. Much obliged.
August 8th, 2010 at 4:16 pm
Wow, great article post.Thanks Again. Will read on…
August 8th, 2010 at 4:53 pm
I really liked your article.Much thanks again. Fantastic.
August 9th, 2010 at 12:48 pm
What a good blog you have here. Please update it more often. This topics is my interest. Thank you. . .
August 9th, 2010 at 1:08 pm
Pretty good post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I’ll be subscribing to your feed and I hope you post again soon.
August 9th, 2010 at 7:25 pm
Hello, this is my first time i visit here. I found so many interesting in your blog especially on how to determine the topic. keep up the good work.
August 9th, 2010 at 7:27 pm
Though I would’ve loved it much more if you added a relevant video or at least pictures to back up the explanation, I still thought that your write-up quite helpful. It’s usually hard to make a complicated matter seem very easy. I enjoy your weblog and will sign up to your feed so I will not miss anything. Fantastic content
August 10th, 2010 at 4:54 pm
I truly appreciate this blog post.Really thank you! Much obliged.
August 10th, 2010 at 5:52 pm
Hey, great blog, but I don’t understand how to add your site in my rss reader. Can you Help me please?
August 10th, 2010 at 6:18 pm
I’ve read some good stuff here. Definitely worth bookmarking for revisiting.
August 11th, 2010 at 5:32 am
We are a group of volunteers and starting a new scheme in our neighborhood. Your post provided us with valuable information to help us get started|.You have done a great job!
August 12th, 2010 at 2:48 pm
I really love going back to your site to read your story and see more pictures that are really taken with great care. . . . . .
August 13th, 2010 at 4:24 am
Fantastic blog! I truly love how it is easy on my eyes and also the facts are well written. I am wondering how I may be notified whenever a new post has been made. I have subscribed to your rss feed which should do the trick! Have a nice day!
August 13th, 2010 at 12:10 pm
Go to StartControl PanelAdd/Remove programs and find Firefox in the list. Select it and press Remove. You remove it just like you’d uninstall any software application.
August 13th, 2010 at 4:25 pm
Hypotheken? Heel veel hypotheek informatie: verschillende hypotheekvormen, hypotheekrentes, nationale hypotheek garantie, hoe een hypotheek te vergelijken.
August 13th, 2010 at 5:40 pm
Thank you very much this is a very nice information!. . . . . .
August 13th, 2010 at 11:22 pm
Hypotheek informatie, hypotheek aanvragen of afsluiten? Hypotheekrentes bekijken. Hypotheek aanbieders vergelijken, hypotheek vormen, bijkomende kosten,
August 14th, 2010 at 12:48 pm
You really make it seem so easy with your presentation but I find this topic to be really something which I think I would never understand. It seems too complicated and very broad for me. I am looking forward for your next post.
August 14th, 2010 at 2:32 pm
I really love going back to your site to read your story and see more pictures that are really taken with great care. . . . . .
August 15th, 2010 at 2:59 am
Lenen Zonder BKR Toetsing Lenen zonder BKR toetsing stijgt in populariteit op het Internet. Veel mensen met een zogeheten BKR notatie, die toch geld willen lenen zijn op zoek naar …
August 16th, 2010 at 4:03 pm
Lenen zonder BKR toetsing gaat vandaag heel gemakkelijk. Binnen een paar uur geld lenen zonder BKR toetsing doet u hier, lees snel verder
August 16th, 2010 at 5:22 pm
I was just browsing for relevant blog posts for my project research and I happened to stumble upon yours. Thanks for the excellent information!
August 16th, 2010 at 5:29 pm
WEAR THEM. Your orthodontist will keep making you come back for more appointments until he thinks your bite lines up perfectly. It’s impossible to tell how long you’ll have to wear the braces without seeing your teeth, but you can look at how "off" your bite is, and try to estimate it from there. If it’s pretty close…maybe one to two months. If you have an extreme over/under/cross bite it might be anywhere from six months to a year. But the most important thing to remember is the more diligent you are about wearing them…the sooner you will get them off!
August 17th, 2010 at 2:30 pm
Thanks for your visiting this http://www.glamoursell.com online store,It is a good idea for getting your desired Rolex Replicas or Replica Rolex. we are a professional,loyal and reliable store for your need Swiss Replica Watches.
August 17th, 2010 at 7:38 pm
Having been just looking at pertinent blog posts intended for the project research and My partner and i happened to stumble on yours. Thanks for this valuable material!
August 18th, 2010 at 3:10 pm
I thought it was going to be some boring old post, but it really compensated for my time. I will post a link to this page on my blog. I am sure my visitors will find that very useful. . . .
August 18th, 2010 at 4:22 pm
Thank you for your blog article. Really Cool.
August 18th, 2010 at 6:03 pm
Very informative article post.Really looking forward to read more. Cool.
August 20th, 2010 at 5:42 am
I didn’t quite understand this when I first read it. But when I went through it a second time, it all became clear. Thanks for the insight. Absolutely something to think about.
August 20th, 2010 at 6:38 am
I definitely appreciate your writing style. It is a wonderful post! Thanks!
August 20th, 2010 at 2:55 pm
You can’t use iTunes to sync the music to your MP3 but you can download the music, go to the iTunes music folder and then drop the music file into your Sansa.
August 20th, 2010 at 4:44 pm
Because most of the other people who commented are jerk offs, I would be more than happy to help you out! I am a romantic at heart. Last Valentine’s Day I had my buddy light candles in my apartment before me and my girl came home from dinner. I actually wrote on 20 cards asking random questions. I call it 20 questions. We had champagne and chocolate covered strawberries there too. It is just a way to let your girl know how much you care and want to know about her. Good Luck Man!
August 20th, 2010 at 5:10 pm
You can get one without a motherboard maybe for 200 bucks. If you’re just using word I’d get a netbook they’re cheap and portable. However they won’t be as quick as a full sized laptop. You can trade in your old computer at bestbuy for money. A netbook usually cost around 300 to 400 bucks.
August 20th, 2010 at 7:51 pm
Really great, practicly explained and useful tips.
August 20th, 2010 at 11:25 pm
I would not advise her to get the surgery unless she is morbidly obese.There are a lot of things that can go wrong with that kind of surgery,life threatening things.Be straight forward with her and show her some facts about how being overweight can lead to other health problems and shorten her lifespan.If she isnt trying to hear that or listen to you you might have to make it clear that you need a person in your life that cares more about their health…
August 20th, 2010 at 11:41 pm
Wow, that sounds like a scary, new, exciting experience, well, to me. lol. That is a lot of stops. I’d say be careful! My dad was going to Vietnam once and some how he almost went to Thailand! And your parents/guardians let you fly on your own? They’re so brave! Have fun! :)
August 21st, 2010 at 12:09 am
she is suppose to have a good gpa and already took atleast one art class like elements of art or art stiduo or have any other experience like activities , maybe she hav a portfolio of drawings
August 21st, 2010 at 12:29 am
Don’t get this concept of SEO. I made my site, submitted it to Google. It appeared on Google just three weeks later and has been #1 (search for HORTENSE ELLIS) for over a year
August 21st, 2010 at 12:46 am
I tried visistats.com (free)…. gud tool to capture traffic coming to website. It gives u all the info abt the website traffic. but I donmt kno,, why u want another analytic tool, wen u can use free google analytics. If the website is huge & want the competitor data also u can use omniture.. its a paid one….or google urchin
August 21st, 2010 at 1:02 am
I thought it links up automatically when you play a EA game online, but if it doesnt try the EA website or check your email address you used to create your Gamertag if its on the 360, mine had messages from EA about an account but i didnt bother reading them
August 21st, 2010 at 7:59 am
I’m really loving this blog, and hope this, as well as the excellent article some other people have written, will help somebody
August 21st, 2010 at 9:50 am
Wait until he does his big attack and you’ve killed the minions, then you have to knock him over with attacks then slowly defeat him by throwing him around like a rag-doll biatch…. thats the way to do it!
August 21st, 2010 at 10:14 pm
It happened automatically for me the first time I tried to view one using the preview pane. I don’t recall installing anything, but I do remember acknowledging the installation.
August 21st, 2010 at 10:44 pm
wud pwobly get ore famous in bollywud…dono if its a racism thing bt look at Parminder Nagra from bend it lyk beckham..shes not really famous in hollywood..bt kathrina kaif iz in bollywud
August 21st, 2010 at 11:00 pm
bollywood is not bs, i think it is really nice especially the old bollywood movies. yes i admit they have gotten worse, but the old ones are special and i totally recommend them!
August 21st, 2010 at 11:14 pm
Return your nuvi 200 as soon as possible. It was not loaded with the correct data at the factory. It sounds like they just installed the basemap and forgot to install the detail map for your region. There are no nuvis that ship without a detail map, so there is a problem with your unit.
August 22nd, 2010 at 2:10 am
this is the best? sounding (and healthiest) recipe i’ve seen so far… AWESOME!
August 22nd, 2010 at 3:31 am
Lovely information in your post, I saw a report on tv last week about this same stuff and since I am getting married in 6 weeks and the timing couldn’t have been better! Thanks for the post!
August 22nd, 2010 at 8:52 am
Wicked! Just got a brand-new Pearl and I can now read your blog on my phone’s browser, it didn’t work on my old one.
August 22nd, 2010 at 8:06 pm
twitter | freebase google | fahrrad map
August 23rd, 2010 at 9:03 am
Open your self with those factors that can contribute you best knowledge and skills. You can do searching of those strategies available who are then known to be effective, have some practice and make use of it. Gather more tips at available sites.
August 23rd, 2010 at 9:48 am
admiral is pretty good if you tell them that you’re not a frequent driver, even if you are. And it’s always cheaper if you get added onto insurance. for example if your parents have a car, get insurance for all 3. you do not have to be driving the same vehicle. And get one where you build your own no claims bonus. After a few years your insurance will drop dramatically.
August 24th, 2010 at 1:17 pm
use coverup to cover those really pesky imperfections. then, apply a liquid foundation ontop to even out your skin tones and make the look flawless. to add that beautiful glow, simply get a bronzer (not too dark) thats just a little step above your skin color. brush it on your cheek bones to highlite your cheeks but if you want, you can put it all over your face to give your whole face an overall glow. also, by wearing a tan or nude colored lip gloss your adding to the glow of your face without looking orange!! vanessa hudgens does all of this to achieve her gorgeous look: http://www.topnews.in/files/images/Vanessa-Hudgens4.jpeg
August 24th, 2010 at 1:25 pm
In order to do so, you need to 1) be running at least Windows XP, and 2) have the Sansa software installed on your PC to transfer the videos and pics. Also, when I last checked, the Sansa only supported certain file formats for videos; if I remember correctly, it may have only supported .MOV files, since I tried transferring .MPEG files and it could not play them.
August 24th, 2010 at 2:40 pm
if your file is .CSO, then unpack it to .ISO, then unpack it with WinRAR. Then you should get a buncha files, go to the map ’sound’, then remove all the files
August 24th, 2010 at 2:55 pm
Did you try to turn off the GPS to see if it still happened? Is your opener wired into the car or is it a simple hand held one? Is your GPS wired into the car or is it an after market one?
August 24th, 2010 at 5:49 pm
First make a dilute solution of 3% percent hydrogen peroxide (half a dixie cup of water and a cap full of peroxide), swish it in your mouth until it foams or tingles. This will clean and disinfect the cuts in your gums to prevent infection. Then spit out the peroxide and rinse it out of your mouth by swishing water. Then apply some ambesol afterwords to relieve the pain and cause numbness. Trust me it works real well.
August 26th, 2010 at 8:15 am
Surprise! You definitely covered this subject well. Are there other options that i am going to have to check out?
August 26th, 2010 at 9:29 am
Take it to the vet, and while your there find out if its kidneys are OK. The life span of a boxer is around 7 years, and that’s usually the first think to go is the kidneys.
August 29th, 2010 at 4:55 am
Cool website. Thank you!
August 29th, 2010 at 9:42 am
hi you all, i’m really listless on the internet so you all should contact me if you are also, strike up a convo :). or possibly facebook, my name on there is robert miller
August 29th, 2010 at 12:16 pm
Cool website. Thanks!
August 30th, 2010 at 4:29 am
Great tips! As a relatively new blogger, I don’t get many comments, but it’s so exciting when I do! I will definately try your tips. Thanks!
August 30th, 2010 at 12:31 pm
Purchase mp3 music online…
really this is a nice web thank you thanks admin good post super messege…
August 30th, 2010 at 12:49 pm
hey hey hey all, i’m really bored on the internet so you all should mail moi if you are too, strike up a convo :). or possibly myspace, my name on there is ashley walinsky
August 30th, 2010 at 10:25 pm
I was really delighted to find this web page.I wished to thank you for this excellent read I certainly enjoying each and every little bit of it and I have you bookmarked to check out fresh stuff you post.
August 31st, 2010 at 3:31 am
What I need to know is why I ought to care? I mean, not to express that what youve obtained to express isnt critical, but I mean, its so generic. Everyones referring to this guy. Give us anything far more, some thing that we can get behind so we can sense as passionately about this as you do.
August 31st, 2010 at 8:47 am
Great, I have already bookmarked your this page…Now I don’t have enough time for read but by reading beginning part I must say…it was a positive start .. Would love to read further too…Thanks for great post!
August 31st, 2010 at 11:41 pm
Yes it does support Windows Mobile applications. I’m not sure what kind of third party applications there might be, but there are always other third party features that are developed for something popular like Windows Mobile. You can VPN to a network if you have access to that network.
September 1st, 2010 at 9:55 am
I have begun to realize stopping can be very hard. I started smokes when I was really young. It absolutely was the dumbest mistake of my life. Now 20 years later and I have bronchitis. I tried each one of the quitting tricks still not anything did any good. My final try is the e cigs in the end.
September 1st, 2010 at 10:48 am
I wasted money on cigarettes for quite a long time and quitting tobacco had been literally impossible. I tested out all the quit smoking products but not a thing did any good. Then I stumbled on the e-cigarettes. The electric cigarette utilizes a nicotine liquid which consists of only nicotine. Basically no poisons whatsoever. They’ve already literally saved my life.
September 2nd, 2010 at 2:39 am
Cool!!! Bookmarked this page that has this impressive information and facts. Will come back to see if there are any updates. You, the author, are a master. Thanks
September 2nd, 2010 at 2:41 am
Nice piece of facts that you’ve got in this website publish. Hope I can get some much more of this stuff on your website. I’ll arrive back.
September 2nd, 2010 at 2:42 am
You actually saved me atleast 1 hour of time. I am making a project to this topic and your piece of content has helped me through one of the topics of my project. I will browse to the other pages now.
September 2nd, 2010 at 3:47 am
While trying to giving up smoking, I saw the e cig. The e cigarette wotks on a nicotine fluid which is made up of nothing but nicotine. No cancerous substances at all. They have pretty much saved my life. No more inhaling and exhaling poisons feels excellent to me!
September 2nd, 2010 at 4:13 am
I smoked for as long as i can remember. I understand it affects my health and so I wish to stop smoking and yet this has been difficult. None of the quitting methods did the trick. Then I came across the e-cigarette. It’s practically saved my life. No more inhaling toxic chemicals feels excellent!
September 2nd, 2010 at 4:42 am
I quit smoking over the weekend and it really is beginning to make me feel crappy today. My fiance keeps telling me I will not be able to keep going but I’m so determined on this I can. This morning I started getting aches in my lower stomach and I genuinely want to have a puff. I will never give in mainly because I’m quitting smoking for my young ones. I am lucky to have the electronic cigarettes. It is often beneficial to me.
September 2nd, 2010 at 5:30 am
I have found giving them up will be harder than you can imagine. I started tobacco while I was just a kid. It was the most terrible mistake I’ve made. Today I’m older and I have emphysema. I tried every one of the quit smoking tools still not one helped me stop. My final try is definitely the smokeless cigarettes in the end.
September 2nd, 2010 at 6:46 am
That is fantastic. Thanks for the link. A great idea for a book!
September 2nd, 2010 at 7:25 am
http://explodingmoon.org/forums/index.php?action=profile;u=5660
September 2nd, 2010 at 8:59 am
I really like bloggin and this blog has a lot of great ideas for my own personal site, thank you!
September 2nd, 2010 at 6:06 pm
Cool, I am the first time on this site and am really enthusiastic about and so many good articles. I think it’s just very good. :D
September 2nd, 2010 at 10:07 pm
The very easiest approach to find laser hair treatment within driving distance is word of mouth and absolutely not from some Dr. who’s getting a bit of the action. I used to visit a great Doctor just for laser treatments. I had blotchy hairy areas and had already been through all the other hair removal procedures. I bought the tria laser hair removal system and have never been more happy. At last I will be hair free for the summer. This will likely to be a fantastic year for me.
September 2nd, 2010 at 10:32 pm
A long time ago I used stringing to eliminate my excessive hair unfortunetly it was so painful that I needed to quit. I gave waxing a run and it was ok but was kind of tedious. So I used forever researching the tria laser. I actually purchased the laser hair removal and was absolutely happy with the final outcome. It gave me fast hair removal at an affordable price tag. I highly recommend it to anybody in place of shaving.
September 3rd, 2010 at 1:02 am
I haveheard of Klix makeup brushes. You don’t wash , you just “click” on new clean brush heads. It is fantastic product