• I am trying to create a local version of our site from a manual backup.

    The backup was created by making a copy of the live site’s public_html foldder via ftp, and exporting a zipped copy of the sql database via phpMyAdmin (through the host’s site admin pages).

    I’ve set up WAMP and WP locally as per the WPBeginner guide.

    When I try to import the backup sql databast to the local site using phpMyAdmin, I get error mesages about tables that already exist.

    Error

    SQL query:


    — Database: web156-a-wo-709

    — ——————————————————–


    — Table structure for table wp_afap_logs

    CREATE TABLE wp_afap_logs (
    log_id int(11) NOT NULL,
    post_id int(11) NOT NULL,
    log_status int(11) NOT NULL,
    log_time varchar(255) DEFAULT NULL,
    log_details text
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8

    MySQL said: Documentation
    #1050 – Table ‘wp_afap_logs’ already exists

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘Local site from backup’ is closed to new replies.