SEO Class in Chicago, IL
Are you a Google Analytics enthusiast?
More SEO Content
Microsoft Access 2003
Posted 19 January 2005 - 10:07 AM
That's all I know if everybody could explain the rest I would be grateful
Posted 19 January 2005 - 10:10 AM
But each database should be able to be backed up fairly easily, and unless you have some very specific needs that I can't think of right now, I don't see why you'd want to back up one DB to another.
Posted 19 January 2005 - 10:51 AM
What type of server are you on? If it's a Windows IIS machine I would assume that they offer the ability to save databases in Access format since they're both Windows. But I don't know for sure since I don't run any IIS servers.
Is there any wisdom out there from IIS users?
Posted 19 January 2005 - 11:26 AM
Raphael at the moment the the database is stored on the server of the host so I need for my puposes to back it if anything went wrong.
Posted 19 January 2005 - 11:51 AM
Just back up the MySQL database using (as Randy suggested) something like phpMyAdmin..
I guess I don't see where the Access database comes into play.
When you back up a database, you do not need to transfer that information into another database. It can be backed up purely as files. (Which you can then restore the original database from, should circumstances require)
Posted 19 January 2005 - 12:27 PM
Posted 19 January 2005 - 12:45 PM
Um.. I don't know if Access will read MySQL tables or not.
If you're backing up from a Linux server to a Win-based machine, I'd just install MySQL for windows on that machine and access the backed up tables that way. MySQL have some nifty free graphical tools for accessing and administrating a database now.
Posted 19 January 2005 - 01:29 PM
Access reads CSV files just fine. There is the potential for some naming conflicts, though generally Access is less restrictive on naming tables and fields than is MySQL, but even those can easily be resolved while setting up the import (there's a Wizard to walk you through it).
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users