Title: Test data for theme development please!! Last modified: August 19, 2016 --- # Test data for theme development please!! * Resolved [gr1zzly](https://wordpress.org/support/users/gr1zzly/) * (@gr1zzly) * [15 years, 6 months ago](https://wordpress.org/support/topic/test-data-for-theme-development-please/) * Hi folks, * I need some test data for theme development, any format that will import using phpMyAdmin is fine but SQL for preference. * Done the usual google and found a couple in XML format but they don’t import using phpMyAdmin. Have tried the wordpress importer plugin but it doesn’t have write access to the ‘uploads’ folder. — I’m running a Ubuntu based LAMP server( I’m new to Linux) and it has the root privileges locked down so my only hope is to have raw database dump from phpMyAdmin to use. * Any help please? Viewing 7 replies - 1 through 7 (of 7 total) * [Chantal Coolsma](https://wordpress.org/support/users/chantalc/) * (@chantalc) * [15 years, 6 months ago](https://wordpress.org/support/topic/test-data-for-theme-development-please/#post-1759407) * You can import the xml file using wp-admin > tools > import * [MichaelH](https://wordpress.org/support/users/michaelh/) * (@michaelh) * [15 years, 6 months ago](https://wordpress.org/support/topic/test-data-for-theme-development-please/#post-1759428) * Also: * [http://svn.automattic.com/wpcom-themes/test-data.2010-08-02.xml](http://svn.automattic.com/wpcom-themes/test-data.2010-08-02.xml) [http://wordpress.org/support/topic/test-data-for-themers?replies=2](http://wordpress.org/support/topic/test-data-for-themers?replies=2) * Thread Starter [gr1zzly](https://wordpress.org/support/users/gr1zzly/) * (@gr1zzly) * [15 years, 6 months ago](https://wordpress.org/support/topic/test-data-for-theme-development-please/#post-1759437) * [@chantalc](https://wordpress.org/support/users/chantalc/) – Yeh I tried that, but as I said my Ubuntu linux setup won’t let WordPress ‘upload’ the file to the folder. (I’m using a LAMP localhost development server). * [@michaelh](https://wordpress.org/support/users/michaelh/) – Yeh I’ve downloaded both of the test data set’s you’ve listed, but as I’ve described to ChantalC above, WordPress can’t upload them to install the data. Hence the need for a “ pure from phpMyAdmin” exported SQL / XML file. * Failing that are there any Linux LAMP guru’s on here can tell me how to safely and securely allow WordPress write privileges to it’s own folder system? * [MichaelH](https://wordpress.org/support/users/michaelh/) * (@michaelh) * [15 years, 6 months ago](https://wordpress.org/support/topic/test-data-for-theme-development-please/#post-1759451) * You do need to install [http://wordpress.org/extend/plugins/wordpress-importer/](http://wordpress.org/extend/plugins/wordpress-importer/) * Thread Starter [gr1zzly](https://wordpress.org/support/users/gr1zzly/) * (@gr1zzly) * [15 years, 6 months ago](https://wordpress.org/support/topic/test-data-for-theme-development-please/#post-1759466) * [@michaelh](https://wordpress.org/support/users/michaelh/) – I appreciate the suggestions but this doesn’t work for me… * After manually downloading, installing and activating the ‘wordpress-importer’ plugin I went to ‘Tools > Import’ again and selected WordPress from the list of import options. I got the file selection screen and selected the XML file, then I clicked the ‘Upload and Import’ button… * This is where I get an error message saying that the import process Failed because it was unable to upload the file to the folder! * — As I said before, Linux’s folder permissions wont allow this so I need another“ non-WordPress Admin panel” solution, hence the request for a raw SQL file that I can install using phpMyAdmin! * [MichaelH](https://wordpress.org/support/users/michaelh/) * (@michaelh) * [15 years, 6 months ago](https://wordpress.org/support/topic/test-data-for-theme-development-please/#post-1759469) * Just did a test import with folder permissions (e.g wp-content/uploads/2010/11/) set to 755 on linux host and it worked just fine. * Thread Starter [gr1zzly](https://wordpress.org/support/users/gr1zzly/) * (@gr1zzly) * [15 years, 6 months ago](https://wordpress.org/support/topic/test-data-for-theme-development-please/#post-1759525) * Hmm that’s odd, doesn’t seem to work for me?! * I tried chmod 755 and 775 but neither would give me access — I think Ubuntu is a bit funny when it comes to ‘root’ permissions. Then again I am a bit a Linux n00b! — Anyway in the end I tried setting the permissions to 777 (once I was safely offline) and it worked! (restored them to 755 after of course) * So I have now successfully added lwallenstein’s test data from your second link above: [http://wordpress.org/support/topic/test-data-for-themers?replies=2](http://wordpress.org/support/topic/test-data-for-themers?replies=2) and can highly recommend it as a very useful and complete set of test data. It’s the best one I’ve seen yet! * As for my permissions issue I dunno, any ideas why my system setup wouldn’t work with ‘755’? — I may start a new thread or look for support from apache / ubuntu forums. * Thanks for the help though! Viewing 7 replies - 1 through 7 (of 7 total) The topic ‘Test data for theme development please!!’ is closed to new replies. ## Tags * [phpmyadmin](https://wordpress.org/support/topic-tag/phpmyadmin/) * [sql](https://wordpress.org/support/topic-tag/sql/) * [theme development](https://wordpress.org/support/topic-tag/theme-development/) * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 7 replies * 3 participants * Last reply from: [gr1zzly](https://wordpress.org/support/users/gr1zzly/) * Last activity: [15 years, 6 months ago](https://wordpress.org/support/topic/test-data-for-theme-development-please/#post-1759525) * Status: resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics