Title: Upload SQL file for demo theme
Last modified: August 20, 2016

---

# Upload SQL file for demo theme

 *  [fuwp](https://wordpress.org/support/users/fuck-you-wordpress/)
 * (@fuck-you-wordpress)
 * [13 years, 7 months ago](https://wordpress.org/support/topic/upload-sql-file-for-demo-theme/)
 * I have a template and I want to upload the SQL file to get the demo so I won’t
   have to build the theme from scratch because I’m terrible at using computers 
   and have the iq of a monkey.Here are the FAQS as to do everything for this.I 
   got lost at step 3! I was in my admin and I don’t have a clue as where to go 
   to “drop tables ,structure, blah blah I don’t know what they are talking about
   where do I click to do that for god sake!
    Please help guys I’m terrible sorry
   🙂
 * Yes! In versions 1.10 (censored )))and up a .sql file is included that you can
   import directly into your mysql database via phpMyAdmin. Here is how you do this:
   
   1. Backup your database! 2. Open your WordPress database using phpMyAdmin on 
   your web server 3. Drop all of your tables: Structure >> Check All >> With Selected:
   Drop 4. Click Import tab at the top 5. Click Choose File and select the .sql 
   file in your Swagger-Theme folder 6. Click Go 7. Open your wp_options table 8.
   Change the value in the siteurl and home records to your domain (currently they
   are pointing to [http://CENSORED](http://CENSORED))
 * After you make these changes, you can access your WordPress admin panel using
   the following
    Once logged in you should see one review type called Movie and
   5 sample movie reviews, as well as all of the Review Options for that review 
   type and all the Theme Options from the demo.
 * If you don’t want to do an entire db import, overwriting all of your current 
   tables, I have taken screenshots of the demo settings so you can replicate them
   in your dashboard. The Theme Options settings can be seen in this screenshot,
   and the Review Options settings can be seen in this screenshot.

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [Gwythan](https://wordpress.org/support/users/kevin-ashbridge/)
 * (@kevin-ashbridge)
 * [13 years, 7 months ago](https://wordpress.org/support/topic/upload-sql-file-for-demo-theme/#post-3131737)
 * The control panel you need to be working in to accomplish these steps is phpMyAdmin,
   which you’ll see if you log in to your web hosting CPanel.
 * This is not something you do in the WordPress admin area.
 *  [Marvel Labs](https://wordpress.org/support/users/royalprince/)
 * (@royalprince)
 * [13 years, 7 months ago](https://wordpress.org/support/topic/upload-sql-file-for-demo-theme/#post-3131743)
 * If it was just a demo theme. You just need to reinstall wordpress using your 
   cpanel and you are good to go. Don’t forget to delete all files in the directory
   in which you wish to install wordpress.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Upload SQL file for demo theme’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 3 participants
 * Last reply from: [Marvel Labs](https://wordpress.org/support/users/royalprince/)
 * Last activity: [13 years, 7 months ago](https://wordpress.org/support/topic/upload-sql-file-for-demo-theme/#post-3131743)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics