importing access.mdb

Hi, I'm doing a project for a local hospital, they want to migrate their access databases to mysql on a Linux box. The hospital runs a Windows network and I have MYsql running on a linux box connected to the network. I need to import the Access .mdb data and structure from the windows server to

importing Access databases

Hi, I'm doing a project for a local hospital, they want to migrate their access databases to mysql on a Linux box. The hospital runs a Windows network and I have MYsql running on a linux box connected to the network. I need to import the Access .mdb data and structure from the windows server to

Mysqld dead subsys locked

Shut down my Linux PC running MySqld and rebooted this morning and cannot get mysqld up. In services when I click on mysqld I get the message "Mysqld dead subsys locked" when i restart the server it says mysql succesfully restarted, but it isnt. When I try to stop the server it comes back with

User table and version

Hi I am using mysql 3.23.54 that came bundled with RH9. When I do a show databases there is no user table, I am working through the reference manual for 4.0 is the reason there is no user table because of the version? also I have tried updating to version 4.0 using the RPM available from the my

upgrade

Hi I am using mysql 3.23.54 that came bundled with RH9. I have tried updating to version 4.0 using the RPM available from the mysql site but on logon the version still says 3.23.54 any ideas? thanks in advance. Bob

Fw: Mysqld dead subsys locked

- Original Message - From: Robert Morgan To: mysqllist Sent: Monday, August 11, 2003 1:50 PM Subject: Mysqld dead subsys locked Shut down my Linux PC running MySqld and rebooted this morning and cannot get mysqld up. In services when I click on mysqld I get the message "Mysqld

linking databases

Hi, is it possible to link databases within mysql? I have a access database that I need to import into mysql this db consists of 4 other dbs linked together sharing a common switchboard. Can I link the tables in one db to tables in another db? thanks Bob

linked db

Hi, is it possible to link databases within mysql? I have a access database that I need to import into mysql this db consists of 4 other dbs linked together sharing a common switchboard. Can I link the tables in one db to tables in another db? thanks Bob

connection error

I have created a user grant all privileges on *.* to user@"%" =>identified by ' pword' with grant option; and grant all privileges on *.* to [EMAIL PROTECTED] =>identified by ' pword' with

transaction savepoints

Hi I'm running mysql 4.0.14 I'm doing an update from a webpage involving 3 tabIes, using 3 update queries and need to be able to roll back to before the first update query if the second or third query go pear shape. So I need to set a savepoint to rollback to if anyone could show me a an exampl

show tables query

Hi, I'm populating a dropdown with table names so the user can then choose the table he/she wishes to edit. However I just want to show the lookup tables. I tried "show tables from DB where table like 'lkp' ;" but got an error; I'm just wondering whether it can be done using show tables or whet

upgrading

Hi, a while ago I upgraded from version 3.23.54 to 4.0.16 I downloaded the rpm's to usr/src/rpm I can't remember the syntax to install all the rpm's it was something like ' U rpm ' any help appreciated I have to write this up so best I get it right. Thanks Bob

relationships

Hi, is there a way of showing relationships in mysql? such as. mysql> SHOW relationships Bob