WordPress.org

1. MacGuy22
   Member
   Posted 7 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 7 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 7 years ago #
   

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

4. MacGuy22
   Member
   Posted 7 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 7 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.