PHPbb Forum SQL Import Failing

[louisere]

Hi all

Can anyone help me with this error I'm getting while trying to import a SQL file in PHPMyAdmin. Many thanks in advance.

Error Message:

Error
SQL query:

-- --------------------------------------------------------

--
-- Table structure for table `CHARACTER_SETS`
--

CREATE TEMPORARY TABLE `CHARACTER_SETS` (
`CHARACTER_SET_NAME` varchar(32) NOT NULL DEFAULT '',
`DEFAULT_COLLATE_NAME` varchar(32) NOT NULL DEFAULT '',
`DESCRIPTION` varchar(60) NOT NULL DEFAULT '',
`MAXLEN` bigint(3) NOT NULL DEFAULT '0'
) ENGINE=MEMORY DEFAULT CHARSET=utf8;



MySQL said:

#1044 - Access denied for user 'louisere'@'localhost' to database 'information_schema'

 

[Dead-i]

Hi louisere,

It is possible that your SQL backup is trying to import "information_schema" too, which is an internal database used by MySQL and cannot be modified. Please could you try re-creating your backup, but ensure that only the tables you need are backed up, rather than all your databases?

Thank you,

 

[louisere]

Hi and many thanks for you're reply. Sadly this is the only copy of the SQL file i have it's from a site i closed down earlier this year and i had only one backup of everything.

 

[Dead-i]

Hi louisere,

Please could you send me a Private Message on the forums with the .sql file?

Thank you,

 

[louisere]

Sent, thank you

 

[Dead-i]

Hi louisere,

I modified your database backup and restored it for you to a new _lo database. Could you please verify that everything has restored properly?

Thank you,

 

[louisere]

Perfect, thank you