MySQL Forums
Forum List  »  Microsoft Access

Re: How do I upload My access data base to an Mysql account
Posted by: Nick Roper
Date: August 05, 2004 07:23AM

Hi Alex,

If the hosting organisation uses MySQL then that will be your best solution. There are a number of ways that you can proceed:

1) If you have MySQL installed on your local machine then, yes, you could recreate the database locally in MySQL and then upload it.

2) You could create a new MySQL database on the server, and then export the existing data from access and import it into MySQL

Mike Hillyer has posted details of an article that discusses the options for migrating from Access to MySQL - his post can be found at:

http://forums.mysql.com/read.php?65,28,28#28

You may also need to check with your hosting organisation to see what limitations they impose on MySQL usage - for example, some ISPs only allow 1 database per account, whilst others are much more flexible. You might also want to check what their backup and support policies are, and which version they use.

Best of luck, and post again if you need any other assistance.

Nick

--
Nick Roper

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How do I upload My access data base to an Mysql account
7139
August 05, 2004 07:23AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.