New Install - From Database Copy
This procedure applies if you have been given a set of files with extensions like ".myd", ".myi", and ".frm".
|•||If you have a single file with a ".db" extension, you have an old-style database. See New Install - From .db Database File|
|•||If you have a single ".sql" file with a name like "bkup_Date_DBName.sql", you have a true database backup. See New Install - Restoring a Backup instead.|
A set of files like this is not the preferred way to transfer the database. If you have access to the computer that is running the database you're being given, you may want to follow the instructions for Moving the Software instead. It will make things a lot easier. Otherwise, make certain you really have all three types of files -- myi, myd, and frm. If any type is missing, this procedure will not work.
Note: If you are running any sort of firewall or antivirus software on your computer, read this.
Reloading a Database Copy
|1||First, you need to know where databases are going to be stored on your computer. This location will be displayed on the Local Database Server utility:|
|•||Choose Start > Programs > MemberTies > Local Database Server.|
|•||Look in the "Local Server Settings" area for the field labeled "Root Database Directory". The path will normally be:|
c:\documents and settings\all users\application data\MemberTies\Database (for windows XP)
c:\ProgramData\MemberTies\Database (for Windows Vista)
|•||Go to My Computer, and navigate to the location you found. (If you can't see the folder, you may need to tell Windows to show hidden files and folders. In Windows Explorer, choose Tools > Folder Options, click View, and select the Show Hidden Files and Folders checkbox, then click OK.)|
|2||Copy the database files into a sub-folder under the Database folder you found above.|
The chances are that the files you were given are already in a folder of their own, so you can just copy that folder into the Database folder. Otherwise, you'll need to create a folder to hold the database files. Note: There will already be a folder under the Database folder called "mysql". Leave that folder alone -- it is used by the server. Create a new folder for your database files.
You should end up with your "myd", "myi", and "frm" files in a folder like:
c:\documents and settings\all users\application data\MemberTies\Database\MyClub\ (on Windows XP)
c:\ProgramData\MemberTies\Database\MyClub\ (on Windows Vista)
NOTE: If you copy these files from a CD-ROM, they will probably be read-only. After copying them to the new folder under your database folder, you MUST select all these files and then right-click and choose Properties. Make sure the Read Only checkbox is not selected. Failure to do this will prevent the server from being able to use the database, and result in, "unable to write to xxxxx table" error messages.
|4||When the Login window appears, make sure your database is selected.|
|•||If your database is NOT listed, go back and verify that it really did contain all three types of files, "myd", "frm", "myi".|
|5||Enter a username and password from the existing database, and click Login.|
Things to try if you cannot log in:
|•||Contact the previous user of the database and get their user name and password.|
|•||Try to log in using the default administrator account, and once you log in, create a new user name and password for yourself by going to Tools > Database Admin Tools> Maintain Users.|
|•||If you are completely locked out, contact support.|