Title: Can't import SQL database
Last modified: August 20, 2016

---

# Can't import SQL database

 *  [orbachdl](https://wordpress.org/support/users/orbachdl/)
 * (@orbachdl)
 * [14 years, 3 months ago](https://wordpress.org/support/topic/cant-import-sql-database/)
 * Hey guys,
    Here’s my situation. I’m trying to import an sql database onto my 
   remote server so I can finally get this site live. When I went into MAMP phpmyadmin
   to export the database I see [this](http://i.imgur.com/2a5r1.png): After trying
   to troubleshoot on the internet and export the database anyways I THINK I was
   able to do it. But I’m not sure, after all it said there were no tables. So then
   I go onto the cpanel and create a database called danielor_wordpress. with user
   danielor_admin and password root. (there are all placeholders). I give the user
   all privileges and go to upload the database using phpmyadmin. I get this [error](http://i.imgur.com/mITeA.png).
   I tried troubleshooting it with by changing settings in the wp-config file. the
   current settings are define(‘DB_NAME’, ‘danielor_wordpress’) define(‘DB_USER’,‘
   danielor_admin’ define(‘DB_PASSWORD’, ‘thesecretpassword’; (not my real password)
   define(‘DB_HOST’, ‘localhost’); does anyone have ANY idea how to solve that error?
   it’s killing me right now. thanks!!!!!!!

Viewing 1 replies (of 1 total)

 *  [Elan Technosys](https://wordpress.org/support/users/elantechnosys/)
 * (@elantechnosys)
 * [14 years, 3 months ago](https://wordpress.org/support/topic/cant-import-sql-database/#post-2594098)
 * Just export your database tables from MAMP and create a new data base in your
   host and then import tables via phpmyadmin on your host and change the data base
   details in wp-config.php and upload it on your host server.

Viewing 1 replies (of 1 total)

The topic ‘Can't import SQL database’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [MAMP](https://wordpress.org/support/topic-tag/mamp/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [tables](https://wordpress.org/support/topic-tag/tables/)

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 1 reply
 * 2 participants
 * Last reply from: [Elan Technosys](https://wordpress.org/support/users/elantechnosys/)
 * Last activity: [14 years, 3 months ago](https://wordpress.org/support/topic/cant-import-sql-database/#post-2594098)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics