dreamweaver mysql

[Twinkie]

I recently discovered Dreamweaver's MySQL integration, but I cannot get it to work. Something is wrong with my configuration, and when run, I get 404 errors. The server and permission are set correctly.

Local Info:
Local Root Folder: G:\xampplite\htdocs\home\
Links relative to: Site root
HTTP Address: http://supertwinkie.co.cc/

Testing Server:
Model: PHP MySQL
Access: Local/Network
Folder: G:\xampplite\htdocs\home\
URL Prefix: http://localhost/

My site is stored and tested on an XAMMP lite server located on my flashdrive. Remote goes through FTP to my x10 account (no probems). I setup a database with a user account and privileges setup with Dreamweaver. Testing this database connction, I get a 404 error:

I don't understand the second reason, and Dreamweaver documentation does not cover it. I assume that this is not relevant to me.

Whats wrong?

 

[jtwhite]

You cannot use this with x10 hosting because remote database access is not permitted. If you are on paid hosting, you need to add your IP address to the allowed list.

 

[Twinkie]

The MySQL server is run by the XAMMP server which is local.

I think this question requires someone who is experienced in Dreamweaver and preferably has used XAMMP before.

 

[Livewire]

I've got zilcho experience in DW but reading the error gives a dang good hint what's broken - there is a missing file, specifically _mmServerScripts/MMHTTPDB.php

I get the feeling that file is what DW uses to interface with mysql, although more than that, I've no idea. I'd start hunting for where that file might be though, so you can get it set up and configured for mysql.




EDIT:

If it's not there

1. Create _mmServerScripts directory
2. Go to your dreamweaver install directory and then Configuration\Connections\Scripts\PHP_MySQL\_mmDBS cripts
3. Upload MMHTTPDB.php and mysql.php to the _mmServerScripts directory on your server

That seems to be the stuff required to actually get it working. That particular forum post doesn't have a reply saying it worked though, but give it a shot anyways

 

[Twinkie]

Adobe forums beat you guys to it: http://forums.adobe.com/message/2248626

Thanks anyways x10.