can't import a sql that wamp has exported
Posted by: maxelcat (217.39.1.---)
Date: March 25, 2014 05:49PM

Hi. I have a local WAMP on my laptop.

I have a linux cpanel.

I am developing the site on the WAMP and now find that I can't import the database into the live server. I can however, import a database into the live server that has come from another cpanel, just not the one from the wamp.

There error I get is:
SQL query:

--
-- Database: `test`
--
CREATE DATABASE IF NOT EXISTS `test` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;


MySQL said: Documentation

#1044 - Access denied for user 'c2920553'@'localhost' to database 'test'


I know the db name as 'test' isn't idea - and will change that once I can get the import to work.

Any help please!

E

Options: ReplyQuote
Re: can't import a sql that wamp has exported
Posted by: RiggsFolly (---.as13285.net)
Date: March 25, 2014 08:45PM

Create the database manually

remove the CREATE statement from the restore.

Make sure that user 'c2920553' has access to the database you cretaed manually

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote


Sorry, only registered users may post in this forum.