How can I include a MySQL table and records with the PUT of my Dreamweaver site?

Report · Oct 29, 2010

I am using .php to validate a user code against one of four codes that I am providing to potential clients. They enter that code, along with a default user id and the appropriate page is then displayed for them. Everything is working fine on the desktop. I need to have this table and the records created on my remote server. I tried saving the table in the Connections folder, but that didn't help. Everytime I enter a code (valid or invalid) on the live site, I get the following message: "Table 'boundsauctions_com.promocode' doesn't exist". Is there someway to include the table and records in my Dreamweaver folders for the site?

Thanks for any help that you can offer.

Report · Oct 29, 2010

You can't. Dreamweaver, or FTP for that matter has no connection to the MySQL database. If you have created a MySQL database locally and now wish to move/copy it to your server you'll need to create a back up of your local database and then log into your database on the server and then restore that back up.

An even easier way to do this, and if you are working with MySQL much at all a good investement is to get the commercial version of Navicat MySQL - this is the best MySQL administrator I've found to date and is well worth the few bucks to buy it. With Navicat you can connect to your local MySQL database and also create a connection to your remote database, then literally drag and drop your local database contents to copy them to your server. This function alone justifies buying Navicat. A huge time saver. And no I do not work for or have any share or ties to Navicat. I'd recommend something else if I knew of anything better, but so far I don't.

Hope this helps. If you need any more details let me know.

--
Lawrence Cramer - *Adobe Community Professional*

http://www.Cartweaver.com

Shopping Cart for Adobe Dreamweaver
available in PHP, ColdFusion

Stay updated - http://blog.cartweaver.com