Restore problem

  • This came after downloading a backup of an existing website to build it on another server with new domain. I uploaded the files to the server and went into php admin after creating the database. The error was in phpmyadmin…it’s below.

    Documentation
    #1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘# WordPress MySQL database backup
    #
    # Generated: Friday 2. September 2005 03:’ at line 1

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

  • Open up the sql file and make sure you do not have the red M’s in the file.

    ” Red M’s” ?????
    There never ever will be ‘red M’s’ in a plain text file.

    Joelwalsh – open your sql file in something like Notepad.
    At the top will be lines like this:
    -- phpMyAdmin SQL Dump
    -- version 2.6.1-pl2
    -- https://www.phpmyadmin.net
    --
    -- Host: localhost
    -- Generation Time: Jun 24, 2005 at 05:14 PM
    -- Server version: 4.0.24
    -- PHP Version: 4.3.11
    --
    -- Database:
    --

    Delete them.
    In fact, you can delete everything above the first “DROP TABLE” or “CREATE TABLE” line.

    Before you start altering the sql file though, copy it and work from the copy.

    Every time I export my sql file I always have to clean up the red M’s. And yes, they do exist in txt files.

    They may exist in whatever you are viewing the text file in, but not in the text file – that is what podz is saying, I think. What editor are you using?

    Sorry misunderstood. Forgot that I only look at files through the shell.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Restore problem’ is closed to new replies.

Tags