php, coldfusion and general web development waffle

[luke]

thanks again major, nice one

i'm going to move one of my sites over later this week and see how it goes ...

[major.tom]

Let me know if you experience any issues. PM or here; your choice.

[luke]

does anyone know if you can have email coming from one host, and the site hosted with another?

i have a site to host on our server, so their domain will point to us, but they'd like to be able to keep their email on their current server - they've got a couple of hundred email addresses, i don't - and they don't - want to have to set them all up again!

i'm thinking it probably won't work ... but i'm not sure, anyone?

[faceless]

if the emails are going to the domain, then they will come to your server, but you should be able to setup a forwarder for them without much trouble.

[luke]

thanks face, i kinda thought that. i've seen something to do with forwarding in the mail admin bit so i'll check it out

[major.tom]

I don't see why not, Luke. www.mydomain.com and admin@mydomain.com are 2 separate functions. The 1st is serviced by the web server (probably Apache) and the 2nd by the e-mail server (sendmail is the most popular). The host company should have the ability (and know-how) to configure their network to service each type of request specific to their own network architecture. (ie. You shouldn't have to worry about that at all.)

[faceless]

indeed, I should have been more correct (as opposed to being lazy/wrong, haha) regarding the mail server.

You could configure the pop/smtp settings via the nameservers to sort this, if you have that access.

[luke]

thanks for the help, i think we've got a solution now

[luke]

i'm having the worst couple of days ever

i'm going to have to learn how to create and populate a mysql database tonight, for a site to go live tomorrow!

i've never used mysql, anyone know of any good resources?!

i just need to create a database, i know the types of fields i need, and then populate it with the data

[faceless]

you should have phpmyadmin as part of the control panel - that's quite intuitive, but if it's all new then you might be lucky to get it sorted by tomorrow...

[luke]

if i can get the database created through phpmyadmin, which i think i have ( theres a folder been created under the mysql\data directory ) would i need to copy that whole folder containing loads of files to the server? its not like one database file, theres a .frm, .myd, and .myi file for each table i've created?! and a db.opt file

[faceless]

Whenever I've used them, the database contents are all in one file, with command lines to indicate which tables they're to be uploaded to.

but this page looks like it should sort you

http://stackoverflow.com/questions/879176/how-to-recover-mysql-db-from-myd-myi-frm-files

[luke]

thank you, i remember something about MyISAM - which is what i think i've set up

what storage engine do you normally use? i can choose between myisam, archive, bdb, brighthouse, csv, falcon, innodb or maria

[faceless]

I've no idea - I set the databases up, then allow the software in the CMS to create the tables etc

[luke]

alright thanks faceless this is going to be a long night!