linking fresh install to existing sql db

  • HI,

    I am attempting a clean install because of some hacks with fresh downloads of everything (WP, as well as plugins and theme templates…) while linking to an existing sql database. As far as I am able to tell, I have everything set up correctly, but when I went through the installation procedure (auto) WP set up fresh tables in the database, rather than linking to the correct tables with all my old postes, etc. (this was because it’d fail when setting the correct prefix in the config file…)

    from what I can tell, it is linking to the correct db on the correct server, but I cannot get it to use the correct tables.

    setting the line

    $table_prefix = ‘wp_’;

    ‘wp_’ is the correct prefix
    to the correct table prefix gives me a generic login page, and that leads to a broken link. trying to load the site returns no information at all.

    setting the line to a completely new prefix creates new tables in the correct db, but that means not linking to the correct content.

    I don’t seem to be able to set the config file to the correct prefix and go through the installation either, as that tells me it’s already installed.. but then I can’t log in…

    Some history and details… some things that are different from the first install

    When I re-installed WP, I installed it in a new directory

    I made the admin name a different name (originally I had run through the install and it was defaulted to admin… i wanted to change this so it showed my name in posts)

    I set new authorization codes in the config file – can’t see why that would affect this, but figured I’d list everything I can think of.

    I tried changing the prefix of the db tables in phpmyadmin, but that didn’t work either. appeared to do the same thing as if i was linking to the correct prefix

    I’m kinda lost. Coding isn’t my core skill, but i’m not totally ignorant. I can cut and paste code and get it to work where it’s not too complicated… I prefer to work with customizable plugins and themes… I really just don’t have the background to figure this one out.

    all the content is there in the db

    Let me know if there is other info I should post to help me,

    Thanks

    Dave

Viewing 1 replies (of 1 total)
  • Thread Starter DaveEwald

    (@daveewald)

    as a slight update, I tried to make another clean install of WP by running the /wp-admin/install.php again with a completely new prefix, and then swapping the old db for the new prefix, and this still breaks the site… generic login, and the following error code when trying to load the site:

    Warning: require(.wp-blog-header.php) [function.require]: failed to open stream: No such file or directory in /home/singleestate/deftcoffee.com/index.php on line 17

    Fatal error: require() [function.require]: Failed opening required ‘.wp-blog-header.php’ (include_path=’.:/usr/local/lib/php:/usr/local/php5/lib/pear’) in /home/singleestate/deftcoffee.com/index.php on line 17

    thanks

    dave

Viewing 1 replies (of 1 total)
  • The topic ‘linking fresh install to existing sql db’ is closed to new replies.