Skip to main content
Scott_-_Columbus__OH
Participant
March 29, 2010
Question

Moving MySQL Databases into Production

  • March 29, 2010
  • 4 replies
  • 966 views

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.

This topic is closed to new replies. Start a new post to keep the conversation going.

4 replies

David_Powers
David_Powers
Inspiring
March 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.

Scott_-_Columbus__OHAuthor
Participant
March 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

David_Powers
David_Powers
Inspiring
March 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.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices