WordPress.org

Ready to get started?Download WordPress

Forums

MySQL Database Restore Error (5 posts)

  1. MacGuy22
    Member
    Posted 9 years ago #

    I tried to restore my backup copy of MySQL database for WordPress after I messed it up trying to fix an error. When I try to restore I get an error. You can see a picture of the error at http://www.zachkarst.com/sql.jpg. You can download my MySQL database at http://www.zachkarst.com/wrdp1.zip. If you could take a look at my database I am sure one of you guys can fix the problem.

  2. Joshua Sigar
    Member
    Posted 9 years ago #

    I couldn't find the offending line in your file.

    Instead of restoring thru a file, try to cut and paste the content of the file on the provided textarea and run it.

  3. MacGuy22
    Member
    Posted 9 years ago #

    ok, I will try that thanks for your help I will tell you if it works.

  4. MacGuy22
    Member
    Posted 9 years ago #

    Thank you alpaoide your suggestion, it fixed my problem. Although I still can't get rid of the error messages below my posts. My support topic for that is located at http://wordpress.org/support/topic/34586.

  5. Dalby
    Member
    Posted 9 years ago #

    I have had a similar problem and I think it's something to do with phpmyadmin and/or mysql.

    In my case removing the following lines from the db backup has always fixed the problem:

    # phpMyAdmin SQL Dump
    # version 2.5.2-pl1
    # http://www.phpmyadmin.net
    #
    # Host: localhost
    # Generation Time: May 22, 2005 at 04:06 PM
    # Server version: 4.1.11
    # PHP Version: 4.3.6
    #
    # Database : wrdp2
    #
    USE wrdp2;

    # --------------------------------------------------------

    I don't know much about these things but I think it's to do with that USE line and the way you instruct phpmyadmin to restore: you actually have to click on the db name and then restore.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.