Skip to main content
R
ryanf4321111
Participant
September 6, 2011
Question

Moving Coldfusion Site

  • September 6, 2011
  • 2 replies
  • 929 views

Hello,

This will probably seem like a very basic question but after searching online, I can't really find an answer. Hoping someone can help. A client of ours had their website written in coldfusion and developed some bad blood with the other developer and basically received a site copy and handed it off to us. I've never had to deal with coldfusion before so I don't know much about it, however I do have a pretty extensive knowledge of php/mysql environments. We even went as far as to find a host for them that supports coldfusion because our usual host does not. What I need to do is prop their site back up, but after unpacking the zip into the root, I don't know where to go from there. The hosting environment uses plesk. There is a database (100mb) in the site backup but I can't seem to import it into an empty database. I don't know if it's the size or what. Can anyone give me any advice on where to start in getting this site back up?

    This topic has been closed for replies.

    2 replies

    J
    Joshua_Cyr
    Participating Frequently
    September 6, 2011

    The database is outside of CF, and maybe your host can help. They often

    will do that with db backups. Is it Mysql or mssql?

    For CF the important thing to know is that it uses datasources to connect to

    a database. Basically a shortcut name that resolves the db server,

    user/pass, etc.

    You set the datasource up in Plesk to point to the db.

    The datasource name is usually mentioned in the CF code. It may be a global

    variable in Application.cfm or Application.cfc.

    If not, look for code with cfquery in it. It is just standard text so use

    any editor to do the search. In there you should see an attribute for

    datasource name. Make sure the datasource name you used in Plesk is the

    same.

    Sometimes you need other things. Like mappings. This is manually done, or

    can also be set in the application.cfc. Hard for us to help more, but that

    should get you started.

    R
    ryanf4321111Author
    Participant
    September 7, 2011

    I see <CFSET siteDataSource = "ikc_data"> set in Application.cfm. It seems that this is what I'm looking for? As for the database type, I'm not sure. I can't import the .sql file properly into a new database and I don't know if it should be MYSQL or MS SQL. Also, I have all the site files in the root but it's still displaying the "Parallels Panel Default Page", which is saying that I haven't put any files into the root (httpdocs). Cleared cache and it's still not showing anything but the default. Shouldn't it at least be aware that there are different files in the root, I even deleted the default page files and it's still showing!

    12Robots
    12Robots
    Participating Frequently
    September 6, 2011

    This really sound slike a MySQL question (at least to start). Maybe you have additional questions that are ColdFusion related.

    But I will try to help.

    " but I can't seem to import it into an empty database"

    Could you tell us if you are getting some kind of an error message?  What happens when you try? What tool are you using to do it?  This should not be any different than how you would do this with a PHP site.

    R
    ryanf4321111Author
    Participant
    September 7, 2011

    Thanks for replying. When I try to import the database, it takes a really long time because of the size (100mb) and when it gets to 100% uploaded, it gives a 404. I'm importing it via phpMyAdmin. Could it be that it's timing out? I've never had an issue importing a database before this. I'm also not sure which type of DB I should be creating, MYSQL or MS SQL. The database file just has a .sql extension. The original developer is basically out of the picture so I can't ask.

    A
    Adam Cameron.
    Inspiring
    September 7, 2011

    OK, this is nothing to do with ColdFusion, and you're asking this on a ColdFusion forum.  You get that, right?  If you want to ask MySQL or MS SQL questions, you should be asking them on a DB-specific forum.  I say this because: a) it makes no sense asking this question here; b) it does make sense to ask it on a DB forum!

    First things first, you need to find out what the SQL file contains, and what DB system it came from.  There will probably be some sort of indication within the file itself?  Failing that, you're gonna have to just eyeball the SQL and look for dialectual vagaries that identify the DB system (eg: MySQL uses LIMIT, MS SQL uses TOP to row-limit SELECT statements).

    That said, if the DB gets a reasonable difference through importing before barfing, rather than just failing immediately, it sounds like the SQL is valid for MySQL.  So this means yuo're probably best to take this question directly to a MySQL forum.

    What happens, though, if instead of using PhpMyAdmin, you just use mysql from the command prompt?

    Once you've sorted your DB situation out, come back and we can help you with your CF situation.

    To be honest, though (and with all due respect), if you're asking this sort of question, I think you are out of your depth and you should engage a CF consultant to get this sorted out for you.  It's not really the sort of thing you just want to be messing around with blindly.

    --
    Adam

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices