Title: [Plugin: BackUpWordPress] Restore/cloning database
Last modified: August 20, 2016

---

# [Plugin: BackUpWordPress] Restore/cloning database

 *  Resolved [maximan](https://wordpress.org/support/users/maximan/)
 * (@maximan)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/plugin-backupwordpress-restorecloning-database/)
 * Hi there,
 * I’m struggling with restore/cloning and would appreciate some help. I have a 
   backup of a site that I ftp’d to a new domain. When I try to import the database
   I get error message “#1046 – No database selected”. It seems I must first have
   an existing database to select so I did a clean WP install that created a database.
   I selected this new database and was able to import the backup .sql but this 
   created some duplicate tables. I’ve read wp codex on importing databases but 
   wonder if there’s little more explanation on the sequence and process in restoring
   to a new domain (i.e. a clone). TIA.
 * [http://wordpress.org/extend/plugins/backupwordpress/](http://wordpress.org/extend/plugins/backupwordpress/)

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

 *  Plugin Author [Tom Willmot](https://wordpress.org/support/users/willmot/)
 * (@willmot)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/plugin-backupwordpress-restorecloning-database/#post-2986965)
 * Hi Maxim,
 * You should delete the existing database tables before you do the import.
 * You’ll also need to do a find and replace in the database dump file to replace
   all instances of your old domain with your new domain. I’ve used this tool before
   to do that; [https://github.com/interconnectit/Search-Replace-DB](https://github.com/interconnectit/Search-Replace-DB)
 *  Thread Starter [maximan](https://wordpress.org/support/users/maximan/)
 * (@maximan)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/plugin-backupwordpress-restorecloning-database/#post-2987027)
 * Tom,
 * I did another clean wp install and deleted all tables. I successfully imported
   backup .sql. Because this was the same domain (it’s an experimental site) I did
   not have to change domain info, although I believe I can do that via phpmyadmin
   to access the _options table. I copied all backup wp files and folders except
   wp_config.php and backup .sql dump contained in the backup zip. However, when
   accessing the site is shows the clean install only, i.e. no posts/plugins that
   were copied. I then copied the backup wp_config.php but was unable to access 
   the site, with message “error connecting to database” Clearly I’m missing step
   in this process. Can you offer more hints to a noob?
 *  Thread Starter [maximan](https://wordpress.org/support/users/maximan/)
 * (@maximan)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/plugin-backupwordpress-restorecloning-database/#post-2987041)
 * A slight correction: all files were ftp’d successfully but settings, pages, media
   etc. are not showing on the back-end except for plugins (but plugins are not 
   activated, unlike source plugins). I kept the clean install wp-config.php file(
   not the backup version). Clearly I’m missing an important step in this cloning
   process. Any suggestions?
 *  Thread Starter [maximan](https://wordpress.org/support/users/maximan/)
 * (@maximan)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/plugin-backupwordpress-restorecloning-database/#post-2987060)
 * Disregard for now – further digging points to maybe domain in subdirectory or
   maintenance mode when making source backup.

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

The topic ‘[Plugin: BackUpWordPress] Restore/cloning database’ is closed to new 
replies.

 * ![](https://ps.w.org/backupwordpress/assets/icon-256x256.jpg?rev=1105225)
 * [BackUpWordPress](https://wordpress.org/plugins/backupwordpress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/backupwordpress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/backupwordpress/)
 * [Active Topics](https://wordpress.org/support/plugin/backupwordpress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/backupwordpress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/backupwordpress/reviews/)

 * 4 replies
 * 2 participants
 * Last reply from: [maximan](https://wordpress.org/support/users/maximan/)
 * Last activity: [13 years, 9 months ago](https://wordpress.org/support/topic/plugin-backupwordpress-restorecloning-database/#post-2987060)
 * Status: resolved