Title: Uploading an old WP SQL database
Last modified: August 18, 2016

---

# Uploading an old WP SQL database

 *  [anataya](https://wordpress.org/support/users/anataya/)
 * (@anataya)
 * [21 years, 2 months ago](https://wordpress.org/support/topic/uploading-an-old-wp-sql-database/)
 * Im reuploading my WordPress MySQL database, but I’m having some trouble. When
   I click the upload link, I get this error message. I haven’t touched the file
   myself and it was working fine before, so I don’t know what could be wrong.
 * `-- Table structure for table `wp_categories`
    -- CREATE TABLE wp_categories (
 * cat_ID` int( 4 ) NOT NULL AUTO_INCREMENT ,
    
   cat_name varchar( 55 ) NOT NULL 
   default '',
    
   category_nicename varchar( 200 ) NOT NULL default '',
    
   category_description
   text NOT NULL ,
    
   category_parent int( 4 ) NOT NULL default '0',
    PRIMARY KEY(
   
   cat_ID ) ,
    UNIQUE KEY 
   cat_name ( cat_name ) ,
    KEY 
   category_nicename ( category_nicename)
   )
   TYPE = MYISAM
 * Before when it was up it did tend to go offline once in a while, and on the main
   page I’d get an error like this:
 * `Error establishing a database connection! This probably means that the connection
   information in your wp-config.php file is incorrect. Double check it and try 
   again.`
 * But after a day or so it would fix itself and run fine. Can anybody help me?

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

 *  [Mark (podz)](https://wordpress.org/support/users/podz/)
 * (@podz)
 * [21 years, 2 months ago](https://wordpress.org/support/topic/uploading-an-old-wp-sql-database/#post-129615)
 * Try…..
 * If you are using a zip file, unzip it and use the .sql file
 * If you are uploading the .sql file, try opening it in NOTEPAD (Not any sort of
   wordprocessor), selecting all then pasting it into the SQL query box
 * Make sure that all tables have been dropped before you try the upload
 * What version of wp ?
 *  Thread Starter [anataya](https://wordpress.org/support/users/anataya/)
 * (@anataya)
 * [21 years, 2 months ago](https://wordpress.org/support/topic/uploading-an-old-wp-sql-database/#post-129648)
 * Will I have to upload the congif file again and everything? Copying and pasting
   the code worked, but I’m still getting that second WordPress error. I’m not entirely
   sure which version it is, but it’s probably one of the newer ones, since I downloaded
   this sometime in the summer I think.

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

The topic ‘Uploading an old WP SQL database’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [anataya](https://wordpress.org/support/users/anataya/)
 * Last activity: [21 years, 2 months ago](https://wordpress.org/support/topic/uploading-an-old-wp-sql-database/#post-129648)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics