Build Site on Localhost server - How easy to Transfer database

[NooseLadder]

Hi,

If I build a site on a localhost server. Is it easy to transfer to a live server. Mainly concerned with the database? Or is it a simple export and import?

[apeisa]

Export and import is enough, no problems there. Only things you need to take care are file permissions and that you have same password hash in your site/config.php file.

[yellowled]

Beware that it might be a bit more work if you develop in a subdirectory locally but transfer it to the root directory on the remote server. Wasn't there a module to make that easier? Page Link Abstractor?

[ryan]

I always develop in a subdirectory and usually launch to root. While Page Link Abstractor is one way to resolve that, an even simpler way is to do a search/replace on your DB dump file before importing it to your live server/root installation. I use TextWrangler (free version of BBEdit), but any quality plain-text editor should work. So lets say you were developing a site locally in /subdir/ and you wanted to update all the /subdir/ links to be / (root) instead:

Search for: ="/subdir/

Replace with: ="/

This should cover all <a> and <img> tags, like <a href="/subdir or <img src="/subdir.