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. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 15 Times in 15 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>

  4. #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



  5. #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

  6. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 15 Times in 15 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
  •