Title: Recurring database errors when importing
Last modified: August 20, 2016

---

# Recurring database errors when importing

 *  [WebMC](https://wordpress.org/support/users/webmc/)
 * (@webmc)
 * [14 years, 6 months ago](https://wordpress.org/support/topic/recurring-database-errors-when-importing/)
 * I am trying to update an old site currently on wp3.1.3 and due to it’s size I
   have been putting if off until now;because the client wants a restyle of the 
   site. I have been trying to upgrade the database to mysql5 from 4, I have tried
   exporting the database now 8 times and keep getting errors. I have followed the
   instructions on the codex about backing up your database and followed them to
   the letter. I am using phpMyadmin to do this, the database is hosted by Namesco,
   the latest error is below. Please help, I need to update this site asap.
 * SQL query:
 * —
    — Database: `zenithcosmet` — — ——————————————————– — — Table structure for
   table `wp_commentmeta` — DROP TABLE IF EXISTS `wp_commentmeta` ;
 * MySQL said: Documentation
    #1046 – No database selected

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

 *  Moderator [Jan Dembowski](https://wordpress.org/support/users/jdembowski/)
 * (@jdembowski)
 * Forum Moderator and Brute Squad
 * [14 years, 6 months ago](https://wordpress.org/support/topic/recurring-database-errors-when-importing/#post-2365345)
 * You’re close to making the restore work. Did you create and select an empty database
   to restore that backup to?
 * See step #2 on using phpMyAdmin.
 * [http://codex.wordpress.org/Restoring_Your_Database_From_Backup](http://codex.wordpress.org/Restoring_Your_Database_From_Backup)
 *  Thread Starter [WebMC](https://wordpress.org/support/users/webmc/)
 * (@webmc)
 * [14 years, 6 months ago](https://wordpress.org/support/topic/recurring-database-errors-when-importing/#post-2365370)
 * Thanks Jan you are a star, I followed the Tamba2.org advice. It appears my db
   was too big, so had to import manually via sql tab. Which worked!!!
    Now I will
   be able to do same to some other sites I am having the same problem with, sigh…
 * Karen

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

The topic ‘Recurring database errors when importing’ is closed to new replies.

## Tags

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

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [WebMC](https://wordpress.org/support/users/webmc/)
 * Last activity: [14 years, 6 months ago](https://wordpress.org/support/topic/recurring-database-errors-when-importing/#post-2365370)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics