YA restore question – procedural

  • Resolved nicheplayer

    (@nicheplayer)


    20 years, 9 months ago

    I’ve searched, and I’m getting a bit muddled on the exact steps for a restore from an existing WP1.5 install. So, here goes:

    I just upgraded my OS X server to Tiger, clean install. I’m running PHP 5.0.4, MySQL 4.0.25, and phpMyAdmin 2.6.3-pl1.

    I have backups of my old database from the original install.

    I’ve created a new database in MySQL called ‘wordpress’ and a user called wordpress with all privs on that database.

    I have a copy of my old WP directory with all the necessary files in it.

    What’s unclear to me is whether I need to install WP *before* trying to restore my old database backup into its new home.

    I tried to restore the databse using PHPMyAdmin, and I got this error when trying to import the .sql file:

    #1064 – You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ‘cat_ID bigint(20) NOT NULL auto_increment,
    cat_name` varcha

    The file is only 464KB.

    And what must absolutely be the same between the two installs? I’ve used the same database name (wordpress) and the same user (wordpress). I was planning on using a different host name and a different subdirectory for the WP files, but can’t I specify those things in config?

    If I do need to do the fresh install, do I then just gut the WP files and replace them with the files from my backed-up directory, changing config to see the new host name and subdirectory?

    Thanks *very much* for any help you can provide. I think my brain is just getting tired of reading installation instructions after the last two days of rebuilding this server.

    [email protected] (<– google talk, too)

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

    (@skippy)

    20 years, 9 months ago

    You don’t need to do a fresh install if you’re restoring from a backup. Indeed, in this case, the error you’re experiencing would still occur.

    It looks like the copy-and-paste of the error message got gobbled by bbPress’ post formatting. Can you re-post it, or put it somewhere online so that we may see it?

    If you change the hostname of your site, you will need to adjust the values of “home” and “site_url” in the options table.

    Thread Starter nicheplayer

    (@nicheplayer)

    20 years, 9 months ago

    Actually, the error text that appears in my post above is all there was…?

    So, if I read your reply correctly, all I need to do is get my wordpress database imported back into MySQL (changing the “home” and “site_url” values in the option table), copy my WP files from the original install into my preferred subdirectory in Web root, then hit http://nicheplayer.net/wordpress and see what it looks like?

    Thank you for your reply!

    Thread Starter nicheplayer

    (@nicheplayer)

    20 years, 9 months ago

    Here’s more of the error text from the error window:

    — phpMyAdmin SQL Dump
    — version 2.6.0-pl3
    — http://www.phpmyadmin.net
    —
    — Host: palmberg.homeunix.net
    — Generation Time: May 02, 2005 at 05:08 PM
    — Server version: 4.0.23
    — PHP Version: 5.0.2
    —
    — Database: wordpress
    —
    — ——————————————————–
    —
    — Table structure for table wp_categories
    —
    DROP TABLE IF EXISTS wp_categories ;

    CREATE TABLE wp_categories (
    cat_ID bigint( 20 ) NOT NULL AUTO_INCREMENT ,
    cat_name varchar( 55 ) NOT NULL default ”,
    category_nicename varchar( 200 ) NOT NULL default ”,
    category_description longtext 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 AUTO_INCREMENT =15

    Thread Starter nicheplayer

    (@nicheplayer)

    20 years, 9 months ago

    Per another thread here, I copied and pasted the text of my wordpress.sql file (using TextWrangler in OS X) into the SQL window in phpmyadmin and was able to restore my database that way. When I did so, though, I deleted this portion of the text:

    — phpMyAdmin SQL Dump
    — version 2.6.0-pl3
    — http://www.phpmyadmin.net
    —
    — Host: palmberg.homeunix.net
    — Generation Time: May 02, 2005 at 05:08 PM
    — Server version: 4.0.23
    — PHP Version: 5.0.2
    —
    — Database: wordpress
    —
    — ——————————————————–
    —
    — Table structure for table wp_categories
    —

    And everything appears to have worked fine.

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

The topic ‘YA restore question – procedural’ is closed to new replies.