Title: Problem manually importing DB using PHPMyAdmin
Last modified: August 19, 2016

---

# Problem manually importing DB using PHPMyAdmin

 *  [MikeonTV](https://wordpress.org/support/users/mikeontv/)
 * (@mikeontv)
 * [15 years ago](https://wordpress.org/support/topic/problem-manually-importing-db-using-phpmyadmin/)
 * I had to make change to my directory path in a lot of posts. I decided to export
   the DB and do a find/replace to makew the changes. But when I imported the DB
   back i got the error
 * #1064 – You have an error in your SQL syntax;
 * which I think it becuase of mt charset not understanding &
 * How can I import this

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

 *  [s_ha_dum](https://wordpress.org/support/users/apljdi/)
 * (@apljdi)
 * [15 years ago](https://wordpress.org/support/topic/problem-manually-importing-db-using-phpmyadmin/#post-2061139)
 * You won’t be able to import until you find the syntax error.
 * I think what I would do is copy the table– make sure you presevere everything
   including auto-increment values– to another table in the database and then use
   [MySQL’s replace](http://www.mydigitallife.info/how-to-find-and-replace-text-in-mysql-database-using-sql/)
   to make the changes. If, as you suspect, the issue is with the charset you should
   get around the problem that way. After you’ve made the changes and your modified
   table is sane, you can rename the two tables and everything should work.
 *  Thread Starter [MikeonTV](https://wordpress.org/support/users/mikeontv/)
 * (@mikeontv)
 * [15 years ago](https://wordpress.org/support/topic/problem-manually-importing-db-using-phpmyadmin/#post-2061161)
 * I already dropped the tables and can’t import the backup
 *  [s_ha_dum](https://wordpress.org/support/users/apljdi/)
 * (@apljdi)
 * [15 years ago](https://wordpress.org/support/topic/problem-manually-importing-db-using-phpmyadmin/#post-2061165)
 * Oh…
 * As soon as you started editing the backup it stopped being a backup.
 * Take the file you have and copy it. The copy is now a quasi-backup. At least 
   you can back up somewhat. Then cut about half the file into another file and 
   try to import that. Be sure to break the cut between queries. If that doesn’t
   work cut your file halves in half so that you have quarters of the original. 
   And so on. The idea is to import piecemeal and also to narrow down where the 
   errors are in the file so that hopefully you can correct them.

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

The topic ‘Problem manually importing DB using PHPMyAdmin’ is closed to new replies.

## Tags

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

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 3 replies
 * 2 participants
 * Last reply from: [s_ha_dum](https://wordpress.org/support/users/apljdi/)
 * Last activity: [15 years ago](https://wordpress.org/support/topic/problem-manually-importing-db-using-phpmyadmin/#post-2061165)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics