Title: Import sql file
Last modified: August 19, 2016

---

# Import sql file

 *  [baszer](https://wordpress.org/support/users/baszer/)
 * (@baszer)
 * [16 years, 11 months ago](https://wordpress.org/support/topic/import-sql-file-1/)
 * Dear people,
 * i have a problem. I backed my database up. And delete my whole ftp account. Now
   i want to import the localhost.sql file (my wordpress database). And i get the
   following error:
 *     ```
       SQL-query: 
   
       -- phpMyAdmin SQL Dump
       -- version 2.8.2.4
       -- http://www.phpmyadmin.net
       --
       -- Host: localhost:3306
       -- Generatie Tijd: 29 Jun 2009 om 11:06
       -- Server versie: 5.0.26
       -- PHP Versie: 5.2.6
       --
       -- Database: <code>wp2</code>
       --
       CREATE DATABASE <code>wp2</code> DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
   
       MySQL retourneerde:  
   
       #1044 - Access denied for user 'DFfgfLKJE23'@'%' to database 'wp2'
       ```
   
 * can someone help me plz?

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

 *  [whooami](https://wordpress.org/support/users/whooami/)
 * (@whooami)
 * [16 years, 11 months ago](https://wordpress.org/support/topic/import-sql-file-1/#post-1125479)
 * > #1044 – Access denied for user ‘DFfgfLKJE23’@’%’ to database ‘wp2’
 * thats a permissions issue. if this is mysql running on your own machine than 
   fix the permissions for that user. did you even add that user? and why does that
   username look like a password?
 *  [shane-g](https://wordpress.org/support/users/shane-g/)
 * (@shane-g)
 * [16 years, 11 months ago](https://wordpress.org/support/topic/import-sql-file-1/#post-1125498)
 * Hi,
 * Assign require permissions to database and database user..which will resolve 
   the case
 * Thanks,
 * Shane G.
 *  [Ryan S](https://wordpress.org/support/users/ryan_accuwebhosting/)
 * (@ryan_accuwebhosting)
 * [16 years, 11 months ago](https://wordpress.org/support/topic/import-sql-file-1/#post-1125511)
 * #1044 – Access denied for user ‘DFfgfLKJE23’@’%’ to database ‘wp2’
 * I think you need to check your wp-config.php file. You have placed wrong details
   in it.. Check it and correct it
 * Also, make sure that the username is added and have all privileges..
 *  Thread Starter [baszer](https://wordpress.org/support/users/baszer/)
 * (@baszer)
 * [16 years, 11 months ago](https://wordpress.org/support/topic/import-sql-file-1/#post-1125656)
 * i allready got it, i couldnt create databases within myphpadmin.
 * but now i have a problem. I created the backup in 2.7.1 and then i installed 
   2.8 and i cant update the database anymore! how do i do that?
 * first install 2.7.1 and then upgrade to 2.8?
 * this is the error i get:
 * #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 ‘Tabel structuur
   voor tabel `wp_posts`
 * INSERT INTO `wp_posts` (`ID`, `post_a’ at line 1
 *  [shane-g](https://wordpress.org/support/users/shane-g/)
 * (@shane-g)
 * [16 years, 11 months ago](https://wordpress.org/support/topic/import-sql-file-1/#post-1125660)
 * Hi,
 * Install the wordpress and apply the details of your 2.7.1 database to complete
   the installation..
 * After that when you go to admin page access of your blog it will ask for the 
   database upgrade..simple click on upgrade database and it will be automatically
   do that..
 * Thanks,
 * Shane G.

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

The topic ‘Import sql file’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [Import](https://wordpress.org/support/topic-tag/import/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 5 replies
 * 4 participants
 * Last reply from: [shane-g](https://wordpress.org/support/users/shane-g/)
 * Last activity: [16 years, 11 months ago](https://wordpress.org/support/topic/import-sql-file-1/#post-1125660)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics