Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Leuven, Vlaanderen, Belgium
    Posts
    312
    Thanks
    5
    Thanked 0 Times in 0 Posts

    MySQL dump import (im)possible? (2K/XP)

    Hi,

    (could anyone help me out with this one? If not I'll need to go and dig in the resources like the ones I referred to myself in an earlier thread... feel like a total greeny)

    We plan to run a MySQL database driven application (CiviCRM) at a server, but due to security issues it looks like I can't connect to it.
    I would like to use an Access front end though to provide the functionality which we might not be able to use CiviCRM for (like reports & statistics,...).
    I am asked now whether I can't import an MySQLdump in Access.
    As far as I know, this isn't possible... and will I probably need to install MySQL (server? client?) at my portable, so I can make & ODBC link to a lokal copy. Is this true? Or... can Access import MySQL anyway?
    Hasse

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 16 Times in 16 Posts

    Re: MySQL dump import (im)possible? (2K/XP)

    If you can't connect to the server, how could you download anything from it, into Access or otherwise? <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: MySQL dump import (im)possible? (2K/XP)

    Presumably when you do the dump, it will be somewhere you can connect to.

    I don't know much about MySQL - is the dump still a MYSQL database, or does it dump in some other form?

    I did a Google search on this and found lots of stuff for moving data between Access and MySQL such as http://www.sobolsoft.com/accessmysql/ but I have nver tried to use any of them
    Regards
    John



  4. #4
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Leuven, Vlaanderen, Belgium
    Posts
    312
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Kinda solved - Re: MySQL dump import (im)possible?

    I'm sorry - I didn't make myself clear enough.
    The mysqldump is a plain text file (example in attachment). As far as I understand it's a backup of the MySQL database's structure (SQL?) and content.
    Our admin mailed me this dump asking me to figure out if I couldn't import it like that in Access. I replied that I couldn't, but wanted to be sure - hence my question here.

    Now... I decided it's probably better just to locally install MySQL on my laptop (Windows XP)... This would allow me to 'unpack' the dump here into a full local backup copy of the database which I can link to using ODBC (*) without any security issues to handle, or convert to an Access database backend using software like John suggested.
    So the confirmation I looked for (that I can't import the dump file) isn't that important anymore. I'm exploring new grounds.

    Thanks again for your time,
    Hasse

    ps FWIW in addition to John's suggestion: a couple of years ago I dumped some google search results at the board <!post=here,371718>here<!/post> ... maybe it's time now to figure it out what they were worth for real <img src=/S/smile.gif border=0 alt=smile width=15 height=15>.

    (*) Alternative howto at devshed mysql
    Attached Files Attached Files

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 16 Times in 16 Posts

    Kinda solved - Re: MySQL dump import (im)possible?

    No, Access can't import a .sql file.

Posting Permissions

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