• Resolved stefan0215

    (@stefan0215)


    Hi there,

    I have manually restored WordPress from a backup. My problem: After entering the respektive website URL the …/wp-admin/install.php shows up and not the home page. What to do? Thanks for your help.

    Stefan

Viewing 15 replies - 1 through 15 (of 15 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    How did you do this restore?

    Thread Starter stefan0215

    (@stefan0215)

    Hi Steve,

    thanks for your quick reply.

    I have manually restored the WordPress site using FTP and following the instructions of

    https://www.wpbeginner.com/beginners-guide/beginners-guide-how-to-restore-wordpress-from-backup/#restorewordpressfiles

    The whole application is now on our SiteGround server.

    For my understanding:
    I don’t have to install a new WP version prior to uploading all files?? I don’t want to reinstall all plugins since it`s so time consuming.

    Many thanks for your help.

    Best Stefan

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    What did you do about the database? The error you listed indicates to me that you did not move over the database.

    Thread Starter stefan0215

    (@stefan0215)

    Sorry Steve, took some time, to recap which steps I took:

    created new database using same database name prior to restoration
    created new MySQL user and added to database
    updated database username and database password in wp-config.php
    /** MySQL hostname */
    define(‘DB_HOST’, ‘localhost’);
    imported .sql database file from back up
    changed table prefix for safety reasons in wp-config.php and .sql database back up
    uploaded edited wp-config.php

    Maybe WP doesn’t find the path to database?

    Best regards

    Stefan

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    check that the database prefix in wp-config.php actually matches what you have in the DB. There’s no security gained by changing the table prefix.

    Thread Starter stefan0215

    (@stefan0215)

    prefix matches

    I’ve also checked:
    if wp-config.php exists | yes

    database connection details:
    wp-config.php: database name, username, password are | matches

    Check wp_options table
    Values of the siteurl and home

    For my understanding:
    Where does WP store database file?

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    There is no database file. Once you import it into the database via phpmyadmin or from the command line, the .sql file has no use.

    What tables are in the database?

    Thread Starter stefan0215

    (@stefan0215)

    Sorry Steve gotta go to bed now. It’s 4:53 am here in Germany. Re. tables: Should I make a screenshot of the tables listing in phpmyadin? Is there a way to add attachments in this forum?

    Best

    Stefan

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    A screenshot would be great! You an upload (without needed to create an account) on imgur.com and then post a link to the image here.

    Thread Starter stefan0215

    (@stefan0215)

    Hi Steve,

    attached please find direct links to 3 screenshots of my DB listing in myphpadmin. Do you also need infos on LOCAL HOST and DATABASE NAME?

    View post on imgur.com

    View post on imgur.com

    View post on imgur.com

    Best regards

    Stefan

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Is the database prefix in your wp_config.php set to bofac_neu_?

    Thread Starter stefan0215

    (@stefan0215)

    yes

    ***************** content of wp-config ***********************

    application/x-httpd-php wp-config.php
    PHP script text
    <?php
    /**
    * The base configuration for WordPress
    *
    * The wp-config.php creation script uses this file during the
    * installation. You don’t have to use the web site, you can
    * copy this file to “wp-config.php” and fill in the values.
    *
    * This file contains the following configurations:
    *
    * * MySQL settings
    * * Secret keys
    * * Database table prefix
    * * ABSPATH
    *
    * @link https://codex.www.ads-software.com/Editing_wp-config.php
    *
    * @package WordPress
    */

    // ** MySQL settings – You can get this info from your web host ** //
    /** The name of the database for WordPress */
    define( ‘WPCACHEHOME’, ‘/home2/kinoseka/public_html/yoganbaum/wp-content/plugins/wp-super-cache/’ ); //Added by WP-Cache Manager
    //define(‘WP_CACHE’, true); //Added by WP-Cache Manager
    define(‘DB_NAME’, ‘yoganbau_kinoseka_wordpress50e’);

    /** MySQL database username */
    define(‘DB_USER’, ‘xxx’);

    /** MySQL database password */
    define(‘DB_PASSWORD’, ‘xxx’);

    /** MySQL hostname */
    define(‘DB_HOST’, ‘localhost’);

    /** Database Charset to use in creating database tables. */
    define(‘DB_CHARSET’, ‘utf8’);

    /** The Database Collate type. Don’t change this if in doubt. */
    define(‘DB_COLLATE’, ”);

    /**#@+
    * Authentication Unique Keys and Salts.
    *
    * Change these to different unique phrases!
    * You can generate these using the {@link https://api.www.ads-software.com/secret-key/1.1/salt/ www.ads-software.com secret-key service}
    * You can change these at any point in time to invalidate all existing cookies. This will force all users to have to log in again.
    *
    * @since 2.6.0
    */
    define(‘AUTH_KEY’, ‘JWkOQ_F>[|v)!NvWlPo<E^CrJz=iqyCS]finnHGmHLUg$!y_KB;wIN?;RLiZE|;m}}CV)r&<_PIaO?TXhTk?TK$jAkr*epwY$s@/AI)%PF_t)nI|]BeyGkqJvVjWZn/s’);
    define(‘SECURE_AUTH_KEY’, ‘cj|Vv]CzF^jKZm>$ONSePNyfE=Z[l-Yuq%ROjyRYsR^J^EBDq)?VbGARY/xgvr*wmjG!xHun/D}>oZtzq?nD;HtFY-KiT+z/At;Pd+Q[|^f+EH{+IjLgRM;%o)YYjRjO’);
    define(‘LOGGED_IN_KEY’, ‘xcpc_r*_VbT*DLmc|&Vr=<@&H%BG-]NTMgY<khS+g|ASwv;pVPhyPnBfV{bFG>NQESy;EFMRuu)^Vt[r?a+rx;TB?;QOP]mtoWtth-gCN^mLWGGDmLK&EgjNirxrm>>V’);
    define(‘NONCE_KEY’, ‘$vWq=c[T^VCdK>OBN&!s[dqR%J^r%rwvz?C%gTvmKD+KKfvoA^;AZ<TTf&h{_/=aAonh?|RtMdpH;^*Soc<^Crp[_/D-HV^{gFw!|OBY+XCUSkGGjJA_{tt)I@L$_AhM’);
    define(‘AUTH_SALT’, ‘L/UFtE(WQlI&K=sqr[{/w>COavOZ=XeGM{I)NWdjntFesAM&WjL-LvqEGTq&?q}LzvSFKbnYvpM}_C>ruZV=<kf|@*gr>LLlVyZ[sCJ&Z!BVMvnF?W-SAxcpMXeAv=^l’);
    define(‘SECURE_AUTH_SALT’, ‘b)SiDXgnNzjWgGmHM!)j$@U/SskZAcpLi$rtHS$RK&aR?;AOUT)]=vPA@Uvf?ONp{JtJfpbz<Uk>d!qkvGzhq&zwHaxVku?RYctPG>^vvj{ZZ{!jYl/t-fG(%qDzEj$R’);
    define(‘LOGGED_IN_SALT’, ‘$XF-&(H&&EPTXt!})m%Rt<[foP|w!+syo{/ROpyWRi(-nOfIsLMM-+?ToW[uRx)<DVXXio?rurzrZvc==E>RXx@^CrbrS)akezKL)>Zn=s^WRInu$^lUk|PcSbd{J|@G’);
    define(‘NONCE_SALT’, ‘Az(fjnon^>)KHq<d/_NXGs)VtIP&VF/ts>*nl@EGDSe_/F*)FX>KaELyXEkTAcG?[Rdb}UmatwL|i=ZD%Tj+lPLqOWmtXnEVQoQQ<v<QyzqSg+cBKOQuKGo&R!&@P)$Z’);

    /**#@-*/

    /**
    * WordPress Database Table prefix.
    *
    * You can have multiple installations in one database if you give each
    * a unique prefix. Only numbers, letters, and underscores please!
    */
    $table_prefix = ‘bofac_neu’;

    /**
    * For developers: WordPress debugging mode.
    *
    * Change this to true to enable the display of notices during development.
    * It is strongly recommended that plugin and theme developers use WP_DEBUG
    * in their development environments.
    *
    * For information on other constants that can be used for debugging,
    * visit the Codex.
    *
    * @link https://codex.www.ads-software.com/Debugging_in_WordPress
    */
    define(‘WP_DEBUG’, false);
    define(‘SCRIPT_DEBUG’, true);

    /* That’s all, stop editing! Happy blogging. */

    /** Absolute path to the WordPress directory. */
    if ( !defined(‘ABSPATH’) )
    define(‘ABSPATH’, dirname(__FILE__) . ‘/’);

    /** Sets up WordPress vars and included files. */
    require_once(ABSPATH . ‘wp-settings.php’);

    /**
    * Include tweaks requested by hosting providers. You can safely
    * remove either the file or comment out the lines below to get
    * to a vanilla state.

    if (file_exists(ABSPATH . ‘hosting_provider_filters.php’)) {
    include(‘hosting_provider_filters.php’);
    } */
    //Disable File Edits
    define(‘DISALLOW_FILE_EDIT’, true);

    /** You can disable error reporting in WordPress by adding the following code to your wp-config.php file: */
    error_reporting(0);
    @ini_set(‘display_errors’, 0);

    ***************************

    Thread Starter stefan0215

    (@stefan0215)

    table prefix ist

    bofac_neu

    please see wp-config above

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    bofac_neu

    Change that to bofac_neu_ (note the trailing underscore)

    Thread Starter stefan0215

    (@stefan0215)

    Dear Steve,

    MANY thanks. The simple “_” made the difference. Website is loading now and WP backend is accessible ??

    Now after moving my cousin`s author website from Bluehost to SiteGround I can take care of website maintenance, update WP, themes and plugins and finally return to keep on promoting his books dealing with the 3/11 Fukushima disaster in Japan.

    https://www.smashwords.com/profile/view/YoganBaum

    In a couple of days yoganbaum.com will be back online.

    Once again many thanks for your help and your WP expertise!

    Best regards

    Stefan

Viewing 15 replies - 1 through 15 (of 15 total)
  • The topic ‘Home page doesn’t show up after WP restore’ is closed to new replies.