Dumps schema and data of a Microsoft Access database file to mysql (REQUIRES mdbtools!)

mdb-dump.sh

#!/bin/bash

# Dumps schema and data of mdbfile (which can be .accdb too) to mysql

if [ $# -ne 2 ]; then
    echo usage: $0 mdbfile mysqlfile
    exit 1
fi

mdb-schema $1 mysql > $2
for i in $( mdb-tables $1 )
do 
	mdb-export -D "%Y-%m-%d %H:%M:%S" -H -I mysql $1 $i >> $2
done