• Sabbz

    (@sabbz)


    I recently changed domains and in the process I’ve re-installed 4 WP blogs, all of which I backed up the databases for. Now I can’t restore the databases to save my life. I know how to use phpmyadmin, how to create mysql databases, etc. I’ve never had a problem restoring databases before, but now I get this error:

    “Error

    SQL query:

    — — Dumping data for table wp_ajaxim_sess — INSERT INTO wp_ajaxim_sess (name, lasttime, starttime, sessid) VALUES (”, 1276644246, 1276644245, ‘3d1a67b75414ee60a28996ade9216792’), (”, 1276652546, 1276650604, ‘22015caf2ba9e476869e85040f2d1d98’), (”, 1276693807, 1276693806, ‘9d1bfe4b889fdbcf1570ec7a31d14010’), (‘Guest_FG4Db’, 1276744862, 1276744800, ‘fadc58e6f4990fc5fcd214260dc6a946’), (‘Guest_uZEMt’, 1276800008, 1276779043, ‘d990d17992018a6ab6a614c50a390655’), (‘Guest_5jxUl’, 1276802194, 1276801849, ‘68411a8d1edba35999c8e554bc928a98’), (‘Guest_rav64′, 1276805081, 1276804793, ’95b03d7296adc8bf874ea8a4500b589e’), (‘Guest_BJtE1’, 1276823980, 1276805289, ‘26860e35e3e07753b5789e1c390f1bde’), (‘Guest_9kyTp’, 1276827954, 1276824563, ‘1bbaa879841b21db2e2cd54240ffbe68’), (‘Guest_kTUrt’, 1276838185, 1276838059, ‘159c5e2b76865129c1e0ee85f9b8a7de’), (‘Guest_YtGqK’, 1276864829, 1276863318, ‘4b45d9082bb2933ba729abcb4899dda3’), (”, 1276912207, 1276865595, ‘2ce8a4a31e39af30b6a81ebc[…]

    MySQL said: Documentation
    #1062 – Duplicate entry ‘3d1a67b75414ee60a28996ade9216792’ for key 1 “

    For some strange reason, the only thing it restored, were the spam comments, which I now can’t delete no matter what. Any help will be greatly appreciated. Thanks

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

The topic ‘Error when restoring SQL DataBase’ is closed to new replies.