Import sql file

  • baszer

    (@baszer)


    14 years, 10 months 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?

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

    (@whooami)

    14 years, 10 months 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?

    shane-g

    (@shane-g)

    14 years, 10 months ago

    Hi,

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

    Thanks,

    Shane G.

    Ryan S

    (@ryan_accuwebhosting)

    14 years, 10 months 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..

    Thread Starter baszer

    (@baszer)

    14 years, 10 months 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

    shane-g

    (@shane-g)

    14 years, 10 months 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.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Import sql file’ is closed to new replies.