SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    will code HTML for food Michel V's Avatar
    Join Date
    Sep 2000
    Location
    Corsica
    Posts
    552
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi mighty gods of the MySQLing.

    To ease the maintenance of our huge database (52000+ items), we moved from dBase to MS Access one year ago.
    But now we are in the process of moving our database from an NT server to an Unix one, thus converting the database to MySQL.

    Has anyone had experience of converting a database from Access to MySQL ? What are the tools for it ?
    Are there tools to manipulate a MySQL database on a local computer on Win98/2k ?
    [blogger: zengun] [blogware contributor: wordpress]

  2. #2
    ********* Callithumpian silver trophy freakysid's Avatar
    Join Date
    Jun 2000
    Location
    Sydney, Australia
    Posts
    3,798
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'm sure someone asked this question quite recently. The only thing I know of that will help you is that MySQL has an operation called LOAD DATA INFILE which will load the contents of a tab delimited file into a table. You can also specifiy other data formats (I think) such as CSV format.

    http://www.mysql.com/doc/L/O/LOAD_DATA.html

  3. #3
    will code HTML for food Michel V's Avatar
    Join Date
    Sep 2000
    Location
    Corsica
    Posts
    552
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    So, basically I can export the data as a tab-delimited text file (just done that), and import the text file in a MySQL table, using PhpMyAdmin ?
    (now that would be the ideal cool solution)
    [blogger: zengun] [blogware contributor: wordpress]

  4. #4
    Dumb PHP codin' cat
    Join Date
    Aug 2000
    Location
    San Diego, CA
    Posts
    5,460
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Go to
    http://mysql.he.net/downloads/contrib.html

    There are several pieces of software that can be downloaded that will convert Access tables ot an easy importable MySQL format.
    Please don't PM me with questions.
    Use the forums, that is what they are here for.


Bookmarks

Posting Permissions

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