MAJOR PROB!!! NEED HELP ASAP

[whitewiddow]

hi, i backed up the database for my forum the other day by exporting it and when i try and import it now i get the message:

[color=red]#1044 - Access denied for user 'user'@'localhost' to database 'user_phpb1'[/color]

can you help ??

the full message reads:

[color=red] -- phpMyAdmin SQL Dump
-- version 2.8.0.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 10, 2006 at 06:18 AM
-- Server version: 4.1.21
-- PHP Version: 4.4.2
--
-- Database: `user_phpb1`
--
CREATE DATABASE `user_phpb1` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

MySQL said: Documentation
#1044 - Access denied for user 'user'@'localhost' to database 'user_phpb1[/color]

[Crusader]

It seems like you've either got the wrong password or the mysql account you're trying to import with doesn't have the correct permissions.

Is the database user_phpb1 already made? If so, and you know for sure your backup works, empty it and comment out the create database line in your backup. Otherwise, if there is no user_phpb1 database created, create it and import the dump again (again with the line create database commented out).

Hope that helps and don't go emptying or deleting tables unless you're 100% sure.

[whitewiddow]

thankyou that helps a lot... but i dont actually know how to comment out the create database line ?

[Crusader]

I think you just have to put a -- infront of that part.

[chronister]

to comment it out....

//CREATE DATABASE `user_phpb1` DEFAULT CHARACTER SET latin1 COLLATE //latin1_swedish_ci;

or

/*
CREATE DATABASE `user_phpb1` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
*/