Uploading an old WP SQL database

  • anataya

    (@anataya)


    21 years, 2 months ago

    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)

    (@podz)

    21 years, 2 months ago

    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

    (@anataya)

    21 years, 2 months ago

    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.