Support » Fixing WordPress » MySQL Database Restore Error

Viewing 4 replies - 1 through 4 (of 4 total)
  • 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.

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

    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.

    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.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘MySQL Database Restore Error’ is closed to new replies.