Title: Restore problem
Last modified: August 18, 2016

---

# Restore problem

 *  [joelwalsh](https://wordpress.org/support/users/joelwalsh/)
 * (@joelwalsh)
 * [20 years, 7 months ago](https://wordpress.org/support/topic/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)

 *  [vrada](https://wordpress.org/support/users/vrada/)
 * (@vrada)
 * [20 years, 7 months ago](https://wordpress.org/support/topic/restore-problem/#post-257203)
 * Open up the sql file and make sure you do not have the red M’s in the file.
 *  [Mark (podz)](https://wordpress.org/support/users/podz/)
 * (@podz)
 * [20 years, 7 months ago](https://wordpress.org/support/topic/restore-problem/#post-257206)
 * ” 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 -- http://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.
 *  [vrada](https://wordpress.org/support/users/vrada/)
 * (@vrada)
 * [20 years, 7 months ago](https://wordpress.org/support/topic/restore-problem/#post-257217)
 * 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.
 *  [Beel](https://wordpress.org/support/users/beel/)
 * (@beel)
 * [20 years, 7 months ago](https://wordpress.org/support/topic/restore-problem/#post-257218)
 * 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?
 *  [vrada](https://wordpress.org/support/users/vrada/)
 * (@vrada)
 * [20 years, 7 months ago](https://wordpress.org/support/topic/restore-problem/#post-257219)
 * 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

 * [moving](https://wordpress.org/support/topic-tag/moving/)

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 5 replies
 * 4 participants
 * Last reply from: [vrada](https://wordpress.org/support/users/vrada/)
 * Last activity: [20 years, 7 months ago](https://wordpress.org/support/topic/restore-problem/#post-257219)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics