Title: problems importing MySQL database
Last modified: August 19, 2016

---

# problems importing MySQL database

 *  [stonefree](https://wordpress.org/support/users/stonefree/)
 * (@stonefree)
 * [16 years, 10 months ago](https://wordpress.org/support/topic/problems-importing-mysql-database-2/)
 * I made a site with MAMP but when I try to import the SQL file exported in MAMP’s
   PHPmyAdmin, I get an error #1210 – Incorrect arguments to DATA DIRECTORY .
 * Amazingly a Google search turns up almost nothing. The closest I found was [this bug report](http://bugs.mysql.com/bug.php?id=33851)
   in which a poster describes a problem that did not occur with 5.0.41 (which MAMP
   uses) but does occur in 5.0.45. I host on Powweb, which uses 5.0.43. Though the
   exact text of error message and the workarounds didn’t seem to fit my situation.
   It mentioned a problem with Unsigned parameters so I did a find and replace to
   remove them from the SQL file but that did not help.
 * I’m pretty baffled and frustrated. Anyone have any clue what’s wrong?

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

 *  Thread Starter [stonefree](https://wordpress.org/support/users/stonefree/)
 * (@stonefree)
 * [16 years, 10 months ago](https://wordpress.org/support/topic/problems-importing-mysql-database-2/#post-1177415)
 * Here’s a bit of additional info-
 * A second site, that was much simpler in content, imported fine. I was also able
   to import an earlier version of the problem site fine a couple months ago. Unfortunately
   I don’t have that earlier sql file to test again.
 *  [adamh](https://wordpress.org/support/users/adamh/)
 * (@adamh)
 * [16 years, 7 months ago](https://wordpress.org/support/topic/problems-importing-mysql-database-2/#post-1177539)
 * I’ve just had the same error when trying to amend the structure of a table on
   a local mysql installation.
 * A restart fixed the problem, although that’s easier to do locally. Contact your
   host and ask them to restart their db server.

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

The topic ‘problems importing MySQL database’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [adamh](https://wordpress.org/support/users/adamh/)
 * Last activity: [16 years, 7 months ago](https://wordpress.org/support/topic/problems-importing-mysql-database-2/#post-1177539)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics