github
Advanced Search
  • Home
  • Pricing and Signup
  • Explore GitHub
  • Blog
  • Login

lwallenstein / Wordpress-Test-Database

  • Admin
  • Watch Unwatch
  • Fork
  • Your Fork
  • Pull Request
  • Download Source
    • 4
    • 1
  • Source
  • Commits
  • Network (1)
  • Issues (1)
  • Downloads (0)
  • Wiki (1)
  • Graphs
  • Branch: master

click here to add a description

click here to add a homepage

  • Branches (1)
    • master ✓
  • Tags (0)
Sending Request…
Enable Donations

Pledgie Donations

Once activated, we'll place the following badge in your repository's detail box:
Pledgie_example
This service is courtesy of Pledgie.

A set of test data for Wordpress blogs for theme designers to test their themes. — Read more

  cancel

  cancel
  • Private
  • Read-Only
  • HTTP Read-Only

This URL has Read+Write access

updated formatting of README 
lwallenstein (author)
Thu Sep 24 10:57:17 -0700 2009
commit  053503d4bcb4f154eddb56514172fa76bd1c5180
tree    be67f0265008f476879c1a3793ea568938989287
parent  ebecc8cbca1d862c042f7a8c67ae388b477fdee9
Wordpress-Test-Database /
name age
history
message
file readme.txt Loading commit data...
file uploads.zip
file wordpress_test_data.sql
file wordpress_test_data.xml
readme.txt
*****************************************************
README
******************************************************

------------------------------------------------------
Setup
------------------------------------------------------

1. Download and Unzip the uploads.zip archive

2. Copy the freshly extracted uploads folder to your wordpress installation (typically wp-content/uploads)

3. There are two ways to import the data, you only need to do 1, however I have provided both an XML (RECOMMENDED) and a 
SQL option so you can use whichever suits you better.
  a. XML OPTION (RECOMMENDED): Use the file wordpress_test_data.xml If you choose the .xml option, you will need to use 
  the import functionality in the Wordpress admin panel (located under tools)
  b. SQL OPTION: Use the file wordpress_test_data.sql - If you choose the .sql option, you will need GUI tool such as 
  phpmyadmin or working knowledge of mysql's command line interface to continue. This is just data. You will need to 
  have setup your wordpress database first. If the database is not brand new, empty the tables wp_comments, wp_links, 
  wp_postmeta, wp_posts, wp_term_relationships, wp_term_taxonomy and wp_terms 
  
4. Using the file for the option you have selected, open it in a text editor such as notepad, textmate, etc.

5. Find and Replace all instances of "http://wordpress.milabs.org/wp-content/uploads" with your server and path to the 
uploads directory that you copied the data into in step one. This may be http://localhost/wp-content/uploads if you did 
this locally, or you may need to set your domain if you are testing on a remote machine.

6. Save the file

7. Using either the Import tool in the Wordpress Admin Panel [Tools > Import] (Option A) or a SQL editor of your choice 
(Option B), import the test data.

8. Have fun testing your Wordpress theme, plugin, whatever you need this testing data for :)




------------------------------------------------------
Configuration
------------------------------------------------------

+ Wordpress 2.8.4 (I will try and keep this up to data)
  ++ Using Permalinks
+ MySQL 5.0.75




------------------------------------------------------
What is in the Testing Data?
------------------------------------------------------

+ Link Categories
  + Long and Short Link Categories
  + Link categories with and without descriptions

+ Links
  + Links with Short and Long Names
  + Links with Normal, Long and No Descriptions
  + Links with and without XFN
  + Links belonging to 0, 1 and multiple categories
  + Links with with and without ratings
  + Private Links
  
+ Pages
  + Short and Long Posts
  + Short and Long Titles
  + Pages with Comments on and Off
  + Pages with Images Linked from other site
  + Pages with Images Links from Local
  + Pages with HTML formatting like links, bold, italic and headers, ordered lists, tables (See 'Advanced Formatting' 
  Page)
  
+ Post Categories
  + Categories with and without descriptions
  + Categories with long descriptions
  + Children Categories

+ Tags
  + Tags with and without descriptions
  + Two Word Tags
  
+ Posts
  + 25 Posts
  + Posts with 0, 1 and many categories
  + Posts in children categories only
  + Posts ranging in a data span of a year
  + Posts with 0, 1 and many tags
  + Posts with No, Short and Long Titles
  + Posts with Linked and Uploaded Images
  + Posts with HTML formatting like links, bold, italic and headers, ordered lists, tables (See 'Advanced Formatting' 
  Page)
  + Posts with Images with multiple alignments
  
+ Comments
  + Posts with No Comments
  + Posts with 25 Comments
  + Posts with Threaded Comments
  + Posts with Private Comments
  + Posts with anonymous Comments.
  + Posts with comments with formatting
  
  
  
  
  
------------------------------------------------------
Contributions
------------------------------------------------------

I hope this is helpful to you, if it is all I ask is that if you add any additional data, find any bugs or update it for 
a new configuration (say an updated Wordpress or MySQL), that you please contribute back to the project. 

Blog | Support | Training | Contact | API | Status | Twitter | Help | Security
© 2010 GitHub Inc. All rights reserved. | Terms of Service | Privacy Policy
Powered by the Dedicated Servers and
Cloud Computing of Rackspace Hosting®
Dedicated Server