RE: import tables from MS-Access

2001-09-17 Thread Deon de Villiers
I do it by setting up a MyODBC databsource which points to my MySQL database and then export each MS-Access table to that ODBC datasource. It works fine except that it does not do primary key and index definitions (as far as I have been able to tell) and things like setting "auto_increment" on fo

Table / Field name cases-sensitivity

2001-08-23 Thread Deon de Villiers
Hi Is it possible to tell MySQL not to be case-sensitive about table names? Thanks Deon. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

Repost: MySQL Backup and Restore Using Binary Log

2001-08-13 Thread Deon de Villiers
Hi I am reposting this just in case someone who would be able to assist me did not see it first time around. Thanks Deon. I am currently putting together a backup system for our MySQL server. The way I want to do this is to make use of mysqldump to perform the backup and have the binary log (o

MySQL Backup and Restore Using Binary Log

2001-08-08 Thread Deon de Villiers
Hi There I have only just subscribed to this list - thank you in advance for any assistance. I am currently putting together a backup system for our MySQL server. The way I want to do this is to make use of mysqldump to perform the backup and have the binary log (on a different disk to my datab