Interview Question in SQL Server 2005 Driver for PHP


 

Interview Question :: Uploading/publishing a database and php files


Hello all,

I've got a form that once submitted it stores the info to a database...it seems to work offline on my local testing server (i'm using dreamweaver by the way & EMS SQL Manager 2005 Lite for MySQL) now i want to publish it to my host....and i don't know how to do that !

I have normal html files and php files which i have published...but how do i publsh the database??? Is it as simple as just hitting publish like the way i usually do...or is there something else i should do before this? Does dreamweaver realise that the database is linked to the php files it needs to be published?

btw, my host supports php and mysql databases

>>>any websites that you can suggest that can help me are welcome too

Thanks all
Answers to "Uploading/publishing a database and php files"
RE: Uploading/publishing a database and php files?

You need to "dump/export" the database/tables from your current machine, then you need to "import" it on the other.

Also you may need to edit the database login info you are using in your php files to reflect the ones on the new server if they differ.
 
Vote for this answer ::  
Update Alert Setting