Results 1 to 14 of 14
  1. #1
    Join Date
    Apr 2007
    Posts
    20

    Unanswered: What what is the best way to transfer data to mySQL periodically

    Hi everyone, here is my situation and what I am hoping to accomplish.
    I want some data from my msSQL to be seen on my website but I do not want a website to access the msSQL database due to performance etc (the database is not intended for website use).
    Innitially I was thinking of exporting the data every 24hours to a text file that the website would access, but now I am thinking it would be better to have some data sent to a mySQL database that I have from my webhost.

    I am not really sure what the best way to do this is, any help please?
    thank a lot

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    WTF?

    Are you serious?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Quote Originally Posted by Paul.
    What is the best way to transfer data to mySQL periodically
    A dixie cup, maybe? Sorry Rudy....
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by Brett Kaiser
    WTF?

    Are you serious?
    what's your problem, brett?

    talk about elitist

    maybe you're just jealous because precious microsoft is losing so much ground to the upstart i-can't-believe-it's-not-a-real-database open source giant killer
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by blindman
    A dixie cup, maybe? Sorry Rudy....
    you too, although i choose to believe that your attitude was just jovial ribbing based on our comments in the "SQL forum" thread
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  6. #6
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    paul, export the data you want moved into a flat file (CSV format will do nicely), then use mysql's LOAD DATA INFILE command
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  7. #7
    Join Date
    Apr 2007
    Posts
    20
    Cheers, will look into that, thanks

    ps anyone want to enlighten me on why I deserved a WTF =/

  8. #8
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Brett, Rudy, I will NOT tolerate bickering between moderators.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  9. #9
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Actually Rudy this is what I was refering to. Not that piece of garbage mySQL


    Quote Originally Posted by Paul.
    I do not want a website to access the msSQL database due to performance etc (the database is not intended for website use).
    Innitially I was thinking of exporting the data every 24hours to a text file that the website would access

    What do you mean the database is not intened for website use?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  10. #10
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by blindman
    Brett, Rudy, I will NOT tolerate bickering between moderators.

    Will you go already
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  11. #11
    Join Date
    Apr 2007
    Posts
    20
    Quote Originally Posted by Brett Kaiser
    Actually Rudy this is what I was refering to. Not that piece of garbage mySQL





    What do you mean the database is not intened for website use?
    It is not intended to be used for a website, actually its not accessed by the internet at all

  12. #12
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    It's perfectly cromulent. We have many servers that are not to be accessed by the outside world, even if it is only one database. It comes down more to a business decision than a technical one.

  13. #13
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  14. #14
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Quote Originally Posted by Brett Kaiser
    [to blindman] Will you go already
    *Rofl*
    This site never ceases to amuse me
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •