Title: Import issue
Last modified: August 22, 2016

---

# Import issue

 *  [alisnilreb](https://wordpress.org/support/users/alisnilreb/)
 * (@alisnilreb)
 * [11 years, 8 months ago](https://wordpress.org/support/topic/import-issue-2/)
 * Hi,
 * I need to work offline on an exixsting website, so I tried to export it and import
   it in wordpress on my pc. How can I import everything and not only posts, pics…?
   I mean, also the theme and his settings for example? Cause it is not my website
   and it’s impossible to do manually again everything. I tried the Importer plug-
   in, so I imported an XML file, but it is only for contents, not the “surroundings
   things”.
 * Thanks,
 * alis

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

 *  [CMSHelpLive](https://wordpress.org/support/users/cmshelplivecom/)
 * (@cmshelplivecom)
 * [11 years, 8 months ago](https://wordpress.org/support/topic/import-issue-2/#post-5272822)
 * To import everything, you need to take the backup of your existing website. You
   can use BackUpWordpress plugin for that:
 * [https://wordpress.org/plugins/backupwordpress/](https://wordpress.org/plugins/backupwordpress/)
 * After installing this plugin, you can follow these steps:
 * 1. In dashboard, go to Tools -> Backups. Here you will find the setting option.
   Select “**Both Database and File**” option. And in “**schedule**“, select “**
   Manual**” option.
 * 2. Take a backup and download it.
 * 3. Unzip the backup zip folder and place it on your local server and rename it.
 * 4. Create a database on local server and upload the .sql file from the unzip 
   folder.
 * 5.Look for wp_options table after you are done with database import. Change site_url
   and home_url.
 * You can read the below link to know about home and site_url
 * [http://wordpress.stackexchange.com/questions/20294/whats-the-difference-between-home-url-and-site-url](http://wordpress.stackexchange.com/questions/20294/whats-the-difference-between-home-url-and-site-url)
 * 6. Look for the wp-config.php file on the root of the unzipped folder. Change
   database name, username, password, and host name.
 * Post this, you should have a working site on your localhost, and you may login
   using existing site credentials.
 *  Thread Starter [alisnilreb](https://wordpress.org/support/users/alisnilreb/)
 * (@alisnilreb)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/import-issue-2/#post-5273142)
 * Thanks for the answer and sorry for the delay!
    Everything worked but I have 
   this error “Error establishing a database connection” but in the wp-config.php
   everything is correct so I can’t understand what I did wrong. Do you have an 
   idea? Actually for the pt.5 you worte, I found the site_url in the options table
   but not the home_url, so I don’t know where to change it.
 *  [Daniel Kanchev](https://wordpress.org/support/users/danielkanchev/)
 * (@danielkanchev)
 * SiteGround Representative
 * [11 years, 7 months ago](https://wordpress.org/support/topic/import-issue-2/#post-5273147)
 * If you’re sure that the MySQL settings are correct then you’ve most probably 
   recreated the following bug:
 * [https://core.trac.wordpress.org/ticket/28273](https://core.trac.wordpress.org/ticket/28273)
 * The solution is to update the “siteurl” and “home” in the database table “wp_options”.
 * You can also define the WP_SITEURL and WP_HOME in the wp-config.php file as per
   the instructions here:
 * [http://codex.wordpress.org/Editing_wp-config.php#Blog_address_.28URL.29](http://codex.wordpress.org/Editing_wp-config.php#Blog_address_.28URL.29)
 * [http://codex.wordpress.org/Editing_wp-config.php#WordPress_address_.28URL.29](http://codex.wordpress.org/Editing_wp-config.php#WordPress_address_.28URL.29)
 *  [Africanwebs](https://wordpress.org/support/users/africanwebs/)
 * (@africanwebs)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/import-issue-2/#post-5273149)
 * also having issues import theme i bought from another site to my wordpress theme
   locally. i mean offline

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

The topic ‘Import issue’ is closed to new replies.

## Tags

 * [Import](https://wordpress.org/support/topic-tag/import/)

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 4 replies
 * 4 participants
 * Last reply from: [Africanwebs](https://wordpress.org/support/users/africanwebs/)
 * Last activity: [11 years, 7 months ago](https://wordpress.org/support/topic/import-issue-2/#post-5273149)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics