Skip to main content
Known Participant
August 6, 2018
Answered

Recordset Connection to my remote server issue

  • August 6, 2018
  • 2 replies
  • 2571 views

Hi, I am having an issue with my Dreamweaver registration, login page.

I am new to dreamweaver and databases.

I am also using php5.6, I understand it is deprecated, however everything I am using is php 5.6, my testing server and my paid FTP.

I made my system in dreamweaver cs6, So from my understanding I should be fine.

I have successfully testing with site on my local server, Im using WAMP, now I want to put it on my paid hosting server. My paid hosting server has mysql, I have made a database and everything. I also have all of my files on my hosting server

I dont know if doing the recordset over is even proper, however I am trying to set it up for my remote sql server. however I keep getting this error.

MySQL Error#:2002

php_network_getaddresses: getaddrinfo failed: no such host is known

I have no idea what this mean or how to fix it.

If you can please direct me to the proper way to fix this.

This topic has been closed for replies.
Correct answer Nancy OShea

Hi Nancy,

I followed your instructions, and uploaded my local .sql file to my servers database successfully. Now upon trying to connect dreamweaver to my servers database I get the following error.

MySQL Error#-2002

php_network_getaddresses:getaddrinfo failed: This is usually a temporary error during hostname resolution and means that the local server did not receive a response from an authoritative server.

For some reason it looks like dreamweaver is trying to connect using the localhost, even though I changed the information to use my remote server [mysql @ ipower account support]. Is there some other step I'm missing?


I never connect Dreamweaver to my remote server. 

My local testing server is set up identically to my remote server.   Same db, username, password.  So if the connection string works on my local wamp server, it will work on my remote server when I transfer files over. 

2 replies

hans-g.
Legend
August 6, 2018

Hello,

it's well known, that in all these cases you describe I'm not a friend of a detailed troubleshooting. To be able to be independent in all this things it is one of the reasons why I prefer an external FTP program, its FileZilla. The difficulties with which you have to fight encourage me in this opinion, not least because we always search for experts, we don't charge a "jack of all trades".

To manage several websites or to upload my files and sometimes for the opposite way, for a necessary download from my server or to use a "a site-wide synch", I'm using FileZilla. It simply looks easier for me to keep track of all operations precisely and generate or reflect easily the desired tree structure.

Above all, FileZilla has a feature (translation from my German FileZilla) called "compare file list". Here it's possible to use file size or modification time as a criterion. There is also the possibility to "hide identical files", so that only these files which you want to redact remain visible.

And even if it means you have to install a new program, I am convinced that there is an advantage. Here is the link to get it and where you can read informations about how it works:

http://filezilla-project.org/ and http://wiki.filezilla-project.org/Tutorial#Using_the_site_manager

Mac: Mac OS X (Use: Show additional download options)

http://filezilla-project.org/download.php

Of course, you also need all the access data to reach your server and for MIME issues, you should contact your web host/provider.

Good luck!

Hans-Günter

P.S.

Since I use two screens, the whole thing became even more comfortable.

Known Participant
August 6, 2018

I am not sure if I can do with with WAMP somehow,

to migrate/ linking the mySQL table to a remote server from wamp?

Nancy OShea
Community Expert
Community Expert
August 6, 2018

Sorry Hans, this has nothing to do with FTP.    This is a server database question.

Does your hosting server have phpMyAdmin?   That's what I use to export local MySQL data to an .sql file.  And then I log into my server's root and use phpMyAdmin on the server to import the .sql file from my computer into my server's database.

Import and export databases using phpMyAdmin - TechRepublic

Nancy O'Shea— Product User & Community Expert
hans-g.
Legend
August 6, 2018

Hello Nancy,

you are right, naturally. On the other hand - to explain my thought processes -  I thought it was important for our OP to solve his problem "Connection to my remote server". Done this - so I assumed out of my own experience - that his provider would give him the necessary advices about MySQL and phpMyAdmin.

But I'm sure, OP now should be able to do it himself by using your link.

Hans-Günter