Transfering mysql/php website between hosts...

[philio16]

Hi guys,

I've been asked to make a small website for our local pub so they can take online bookings for rooms etc, which isn't a problem....I'm just wondering if it is possible for me to make it on my webspace to test etc, then transfer it over to their own once its all working?? Transfering the files will be easy enough...but how would I go about transfering all the database things?

 

[GeForce]

A database can be backed up as an SQL query in a text file, which you would then just run on the new MySQL server.

Jon

 

[meghatronic]

As above, either backup and restore using phpmyadmin or mysqldump if you have command line/system/exec access.

Only thing that'll presumuably change is mysql username, password and db name.

 

[philio16]

Cool! Sounds fairly straight forward! Thanks