Moving MySQL Databases into Production

Report · Mar 28, 2010

I've created a MySQL database on my Windows-based, localhost, computer using MyPHPAdmin. I have also created numerous *.php files using Dreamweaver that access the dynamic data. Now I want to move all of this onto a remote site (hosting company).

Does Dreamweaver automatically move the MySQL databases because they are dependent to the *.php files? If not, any suggestions on how I can make this happen?

I'd appreciate any help that you can provide. I haven't been able to find the answer to this online or in manuals (Dreamweaver CS4: The Missing Manual).

Thank you in advance.

Report · Mar 29, 2010

Scott - Columbus, OH wrote:
Does Dreamweaver automatically move the MySQL databases because they are dependent to the *.php files? If not, any suggestions on how I can make this happen?

No, Dreamweaver doesn't do it. The database isn't dependent on the PHP files. The PHP files are dependent on the existence of the database.

To move a MySQL database, use the Export tab in phpMyAdmin. Export the database to a .sql file, and save it on your local hard disk.

Launch phpMyAdmin on your remote site, select or create the database you want to use, and click the Import tab. Use the Browse button to navigate to the .sql file on your hard disk, and click Go.

Report · Mar 29, 2010

David,

Thank you very much for the prompt reply. I did save my database to a SQL database so I understand that process now. Unfortunately though, my web hosting service (Netwalk) does not offer phpMyAdmin. Is there another tool that I can use? I have the XAMPP-provided files on my local machine.

Netwalk has told me that I can install phpMyAdmin in my area of the remote site. I'll also follow-up with them on how to do this.

I will be deleting this database from the web hosting service and re-adding it once a day with daily updates.

Regards,

Scott

Report · Mar 29, 2010

Scott - Columbus, OH wrote:
Unfortunately though, my web hosting service (Netwalk) does not offer phpMyAdmin. Is there another tool that I can use?

You can use Navicat. I don't know if the free version will do it, but the commercial version will. However, I think the best solution is to ask your hosting company for advice on their recommended solution. You need to be very careful about installing phpMyAdmin on a public site.

I will be deleting this database from the web hosting service and re-adding it once a day with daily updates.

That sounds like madness. Create a password-protected update page on your remote server.

Report · Mar 30, 2010

David,

Just to close the loop on this, my web hosting company setup phpMyAdmin for me so that I can use it. Thanks to your help I've transferred the MySQL databases from my localhost to the web hosting company.

I'll heed your advice on my earlier "deleting the datbase" comment and find a much better way as I get closer to production.

Now I'm thrashing through the process of trying to get my php files to communicate with the MySQL database on my web hosting company. You'll likely see another posting from me soon!

Thanks again for your prompt help.

Scott