Glitch restoring database using PHPMyAdmin

  • Martin

    (@martin-amada)


    9 years, 6 months ago

    Hello,

    I exported my database via PhpMyAdmin as a backup, and when I went to restore using Import from the PhpMyAdmin panel I got this error message, obviously related to a table created by one of the site’s plugins. It interrupted the import which never completed.

    SQL query:

    —
    — Dumping data for table wp_adrotate
    —
    INSERT INTO wp_adrotate ( id , title , bannercode , thetime , updated , author , imagetype , image , link , tracker , timeframe , timeframelength , timeframeclicks , timeframeimpressions , type , weight , sortorder )
    VALUES ( 1, ‘This Space for Rent’, ‘Image: <img src=\\"https://wp-content/themes/wp-jazz-basic/images&gt;‘, 1354122062, 1354133836, ‘admin’, ‘field’, ‘https://www.hsswriters.com/wp-content/uploads/2012/11/Your-Ad-Here.png&#8217;, ”, ‘N’, ”, 0, 0, 0, ‘error’, 6, 0 ) ;

    MySQL said: Documentation

    Can someone advise me how to proceed to complete this import (restore? Should I try deleting the table?

    Thanks,
    Martin

  • The topic ‘Glitch restoring database using PHPMyAdmin’ is closed to new replies.