Error importing MySQL db to my internet server
Posted by: hashie (---.hfc.comcastbusiness.net)
Date: April 25, 2016 08:25PM

1 - Windows version used w7Pro 64 bit
2 - Version WampServer 3.00 64 bit
3 - Apache Version 2.4.17
4 - PHP Version 5.6.16
5 - MySQL Version 5.7.9
6 - What color is the WampServer icon Green
No error events in logs
7 - In the file c:\Windows\System32\drivers\etc\hosts, what are the active lines with the name [localhost] in them?
* Active means no # at the beginning of the line.
127.0.0.1 woodbypeyton
::1 woodbypeyton

If the WampServer icon is green:

8 - Do you have access to localhost (Homepage WampServer)? yes
9 - Do you have access to phpMyAdmin? yes

10 - If you refer to an error message, please include the EXACT wording of the error in your post

Error

SQL query:

--
-- Database: `on9q7`
--
CREATE DATABASE IF NOT EXISTS `on9q7` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

MySQL said: Documentation
#1044 - Access denied for user 'sawdust'@'localhost' to database 'on9q7'

11 - If you use an Antivirus and / or Firewall, please include the names of these Microsoft Security Essentials and Window firewall
12 - What is the full path to the installation of WampServer (eg D:\wamp\) D:\wamp64

I have checked and Create/Use option is unchecked in Export options

Options: ReplyQuote
Re: Error importing MySQL db to my internet server
Posted by: RiggsFolly (Moderator)
Date: April 26, 2016 12:53AM

You need to create a user account in MYSQL called sawdust or change your restore to use a the root account

---------------------------------------------------------------------------------------------
(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
Re: Error importing MySQL db to my internet server
Posted by: hashie (---.hfc.comcastbusiness.net)
Date: April 26, 2016 03:00AM

I have setup sawdust as a user and given all rights. I still get the same error when trying to import.

Options: ReplyQuote
Re: Error importing MySQL db to my internet server
Posted by: RiggsFolly (Moderator)
Date: April 26, 2016 10:45AM

How are you running this restore?

Are you using phpMyAdmin?

Are you using the MySQL Console?

Are you using some other tools?

---------------------------------------------------------------------------------------------
(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
Re: Error importing MySQL db to my internet server
Posted by: hashie (---.hfc.comcastbusiness.net)
Date: April 26, 2016 04:45PM

I'm using phpMyAdmin.

Options: ReplyQuote
Re: Error importing MySQL db to my internet server
Posted by: RiggsFolly (Moderator)
Date: April 26, 2016 05:20PM

Upgrade to WAMPServer 3.0.4 ad then install the ADDON for phpMyAdmin 4.6.0

See [forum.wampserver.com]

---------------------------------------------------------------------------------------------
(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
Re: Error importing MySQL db to my internet server
Posted by: hashie (---.hfc.comcastbusiness.net)
Date: April 26, 2016 07:00PM

Got it! Thanks for your help.

Options: ReplyQuote


Sorry, only registered users may post in this forum.