Welcome to WebmasterWorld Guest from 220.127.116.11
Forum Moderators: open
i have been mucking about on mysql on my home pc with dreamweaver using php
now i have bought hosting with a mysql database
1. when i set up the site in dreamweaver, do i use the local database or do i connect to the remote database?
2. the remote db is empty, how can i transfer tables over?
[edited by: jatar_k at 5:48 pm (utc) on May 12, 2006]
[edit reason] no specific hosts thanks [/edit]
it should have the host in there, I am guessing it is set as localhost, if that is the case then you just need to look at your hosting and see if that setting is the same. If it is then you don't need to worry, it will work on both.
If there is a different setting you need to use on your host then you could use a config file on each that has the appropriate connection settings.
yeah cheers but will the code for my pages still point to my local database? i want my local database to be used for testing on apache on my machine, then upload it to the remote site using the remote database
<edit>jatar_k beat me to it :)</edit>
obviously if not then the including the code from a seperate file would be a good idea, but i use dreamweaver to make the connection and design the pages, so how do you separate the connection code?