WordPress.org

Forums

Import sql file (6 posts)

  1. baszer
    Member
    Posted 5 years ago #

    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?

  2. whooami
    Member
    Posted 5 years ago #

    #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?

  3. Shane G
    Member
    Posted 5 years ago #

    Hi,

    Assign require permissions to database and database user..which will resolve the case

    Thanks,

    Shane G.

  4. Ryan S
    Member
    Posted 5 years ago #

    #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..

  5. baszer
    Member
    Posted 5 years ago #

    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

  6. Shane G
    Member
    Posted 5 years ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Topic