| |
If your client decides to switch to MySQL they will need to download MySQL
Front 2.5
from as this is one of the best MySQL
database administration programs. It is also free so they won't have to
worry about licensing. Once installed on their computer, the client will
need
download the Access database from their website. The software will take your
Access database and dump the contents into a file. I am including step-by- step instructions how to make the conversion:
1. Login to your WebsiteOS, go to Website Management and open Database Manager
2. Set up the Database Manager password if you haven't yet. Then create a
database. The format will be prefix_yourdomain_com where the prefix is
something you will choose.
3. Open MySQL Front and configure the connection screen with the following
information:
Hostname / IP: megasqlservers.com
User: dbm.yourdomain.com
Password: the password you set using Database Manager
Database: prefix_yourdomain_com (where prefix is your database name)
Save the settings (by clicking Save on the top of the screen) and hit Connect
(located at the bottom)
4. Once connected, click on "Im -/ Export" from the top menu bar and then
select "ODBC Import".
5. When the Import screen opens up, select the "MS Access File" radio button
and locate your Access database by clicking on the yellow folder on the
right side. This will bring up the local Windows file and folder viewer.
6. Once you select the database another window will open up, but you can
click on as most likely your database is not password protected.
7. Near the bottom of the screen (same screen as in step 5) you will see two
columns, once called Tables and the other called Fields. These columns will
be populated with tables and fields from your Access database. By default,
all should be checkmarked, however if you wish you can remove any of them
that you do not wish to be included.
8. Finally, all you have to do is hit the IMPORT button at the bottom right
side. That is it, your database has been converted.
You will now need to convert your ColdFusion or ASP code slightly so that it
connects to the MySQL database. You again have two options, either to go
with DNS or DNSless connection. If you want to go with a DSN, we will
need to recreate one for you. We will need to know your new database name
(something_yourdomain_com) and the prefix for the DSN (usually kept the same
as the MySQL database name).
--
Regards,
Your 24hourwebhostingsupport.com Team
|
