Title: Restore Data Base Error
Last modified: August 18, 2016

---

# Restore Data Base Error

 *  [metaltiger](https://wordpress.org/support/users/metaltiger/)
 * (@metaltiger)
 * [20 years, 4 months ago](https://wordpress.org/support/topic/restore-data-base-error/)
 * I am moving to a new server and have backed up the entire web site at [http://metaltiger.org](http://metaltiger.org)
   as well as the Data Base. The restore data base on the new server is giving me
   syntax errors :
 * Error
 * SQL-query:
 * #
    # Table structure of table `wp_categories` # CREATE TABLE `wp_categories` (`
   cat_ID` bigint( 20 ) NOT NULL AUTO_INCREMENT , `cat_name` varchar( 55 ) NOT NULL
   default ”, `category_nicename` varchar( 200 ) NOT NULL default ”, `category_description`
   longtext NOT NULL , `category_parent` bigint( 20 ) NOT NULL default ‘0’, `category_count`
   bigint( 20 ) NOT NULL default ‘0’, PRIMARY KEY ( `cat_ID` ) , KEY `category_nicename`(`
   category_nicename` ) ) ENGINE = InnoDB DEFAULT CHARSET = latin1
 * MySQL said: 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 ‘DEFAULT CHARSET=latin1’ at line 14
 * I am not sure where to go from here to restore the data base. Thanks.
 * David

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

 *  [Mark (podz)](https://wordpress.org/support/users/podz/)
 * (@podz)
 * [20 years, 4 months ago](https://wordpress.org/support/topic/restore-data-base-error/#post-314569)
 * “DEFAULT CHARSET = latin1”
 * Open the .sql file in a plaintext editor and do a search/replace
    Replace “DEFAULT
   CHARSET = latin1” with nothing and all should be well.
 *  Thread Starter [metaltiger](https://wordpress.org/support/users/metaltiger/)
 * (@metaltiger)
 * [20 years, 4 months ago](https://wordpress.org/support/topic/restore-data-base-error/#post-314584)
 * Podz, does this mean that I just remove the
    “DEFAULT CHARSET = latin1” or do
   I change it to
 * “DEFAULT CHARSET = “
 * Thanks
    David
 *  [Mark (podz)](https://wordpress.org/support/users/podz/)
 * (@podz)
 * [20 years, 4 months ago](https://wordpress.org/support/topic/restore-data-base-error/#post-314596)
 * Remove it 🙂
 * (Apologies for not being clearer!)

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

The topic ‘Restore Data Base Error’ is closed to new replies.

## Tags

 * [base](https://wordpress.org/support/topic-tag/base/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 2 participants
 * Last reply from: [Mark (podz)](https://wordpress.org/support/users/podz/)
 * Last activity: [20 years, 4 months ago](https://wordpress.org/support/topic/restore-data-base-error/#post-314596)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics