Hello,
I'm using mysql-max 3.23.49 binary distribution.
I use mysqldump utility to dump tables from my DB.
for example:
mysqldump --opt -u root -p EFDB users > users.sql
users.sql file contains:
--
-- MySQL dump 8.21
--
-- Host: localhostDatabase:
I think the best way is to export Access 2000 tables to tab
delimited text files and then use mysql LOAD DATA INFILE in mysql
to get data from text files into MySQL tables.
See manual for LOAD DATA INFILE syntax.
I'm not sure but maybe some utilities exist to convert Access to MySQL.
Peter.
>
