Skip to main content
A
Ant911
Known Participant
March 9, 2011
Question

ColdFusion & MySql & NaviCat

  • March 9, 2011
  • 2 replies
  • 1465 views

I need so help with MySql - its the first time I'm using MySql to run my databases in CF.

I have created a MySql database in NaviCat and linked it to my website with CF on my local machine and it's all working.

The problem is, I don't know how to load the DB onto my server so that I can use it in a live environment. I cannot seem to find where the database is stored so that I can copy it across to the server.

Can so help?

Thanks 

    This topic has been closed for replies.

    2 replies

    A
    Anonymous
    May 19, 2011

    Even simpler then dumping the database is to use Navicat to connect to the two database at once (one on your local machine and one on the server). Once these are connected simply click and drag the tables (maybe even the database) from your local connection to the server connection. Can't get any simpler.

    I use the Mac version, so I am not sure if this is available in the Windows version.

    Cheers, Bill

    A
    Adam Cameron.
    Inspiring
    March 10, 2011

    This is not a CF question, so probably not the best place to post it.

    Not that I am a MySQL expert, but I have used it a bit, if I was to be needing to do this, I'd use MYSQLDUMP to serialise the DB, and then reimport it on the prod box via MYSQL itself.  That said, I've not needed to do this for a few years, so things might have moved on since then.

    However if you ask MySQL questions on a MySQL forum, you will get MySQL experts (if only self-proclaimed ~) who will give you a more informed answer.

    --

    Adam

    A
    Ant911Author
    Known Participant
    March 10, 2011

    Thanks Adam,

    I have listed it on MySql forum - but nobody has replied thus far.

    Anthony

    A
    Adam Cameron.
    Inspiring
    March 10, 2011

    Did you look in to mysqldump?

    --

    Adam

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