Apple 034-2344 manual MySQL Data

Page 55

MySQL Data

Restore saved MySQL databases in /var/mysql.

There are a few commands you can use on an old database to remove dependency on the ISAM table format, which has been deprecated:

•Run mysql_fix_privilege_tables to enable new security privilege features.

•Run either mysql_convert_table_format (if all existing tables are ISAM or MyISAM) or ALTER TABLE table_name TYPE=MyISAM on all ISAM tables to avoid the deprecated ISAM table format.

Refer to the documentation on the MySQL website for migration details before running these commands:

www.mysql.com/doc/en/index.html

Mail Database

To migrate the mail database:

1Make sure that mail service is not running.

Open Server Admin, then click Mail. If it is not grayed out, click Stop Service.

2Place the saved database in the default location: /Library/AppleMail Server/. Make sure that no extra files are in that location.

3Make sure that there is free space on the destination disk equal to the size of the mail database.

4Open the Terminal application.

5As the root user, type the /usr/bin/cyrus/tools/amsmailtool command. For information about this tool, type the following command or see the command-line administration guide:

/usr/bin/cyrus/tools/amsmailtool -help

Webmail Data

Place user address books and preferences in /var/db/squirrelmail/data/ if you want them to use SquirrelMail that comes with version 10.3.

FTP Configuration Files

Copy saved FTP configuration files to:

•/Library/FTPServer/Configuration/

•/Library/FTPServer/Messages/

Chapter 3 Migrating From Mac OS X Server Version 10.1

55

Image 55

Contents Mac OS X Server Migration Apple Computer, Inc Apple Computer, Inc. All rights reserved Contents Migrating in Place From Asip Migrating From AppleShare IPGetting Additional Information What’s Included in This GuidePage Upgrading Versus Migrating Before You BeginMigrating Users and Groups Migration ScenariosHere are the predefined user accounts System AccountsShort name Group ID Here is a list of the predefined group accountsMigrating Other Data Migrating Data for Managed Mac OS 8 and 9 UsersAfter Migration Understanding What You Can Migrate VersionTools You Can Use To set up SeeTest the new server Migrating in Place From VersionFTP Configuration Files Make a full backup of your current serverWeb Configuration Data Web ContentIP Firewall NetBoot ImagesWebObjects Applications and Frameworks Tomcat DataTo export users and groups Macintosh Manager DataQuickTime Streaming Server Files and Folders Export users and groups to another hard disk or partitionSet up the home directory infrastructure Install Mac OS X Server versionTo prepare the server to store home directories Import previously exported users and groups To import users and groups using Workgroup ManagerTo migrate the web configuration Restore saved dataTo migrate the AFP configuration AFP ConfigurationTo migrate the mail database To migrate the IP firewall configuration IP Firewall ConfigurationDNS Configuration To migrate the Dhcp configuration Dhcp SettingsTo test the new server Set up share points and privilegesTo create a share point and set privileges Test the new serverCreate archive files of data and user export file Migrating to a New Server From VersionCreate archive files Export users and groupsAFP DNS Copy archive files to the new server To transfer tar files or disk images using FTPRelocate saved data files Web Configuration Data Mail Database NetBoot Images Dhcp Settings Set up share points and privileges Version Tools You Can Use Install Mac OS X Server Copy current data to another hard disk or partition AFP QuickTime Streaming Server Files and Folders Import previously exported users and groups Restore saved data MySQL Data AFP Configuration DNS Configuration Migrate Macintosh Manager Information Export user Create archive files AFP DNS Set up the home directory infrastructure Relocate saved data files MySQL Data AFP Configuration IP Firewall Configuration User Data Network services administration guide Tools You Can Use Info to another hard Make a full backup of your current server Export user and group information To prepare data for the migration utilityTo export user and group information Set up the home directory infrastructure Restore saved data To migrate Macintosh Manager data For Move this folder to Old MM Items If login is Migration utility Test the new server Set up share points Export user and group information Create archive files To transfer tar files using FTP Set up the home directory infrastructure Relocate saved data files Set up share points and privileges For Move this folder to Old MM Items Migrating From Mac OS X Server Version If login is Migration utility Test the new server Page Migrating From AppleShare IP Migrating From AppleShare IP Check the migration Migrating in Place From AsipExport user and group information if necessary Provide Internet Aliases if necessaryTo export user information from Asip Prepare to migrate privileges To install the new serverTo use the AppleShare IP Migration utility Migrating From AppleShare IP Copy data to the new server This directory Place these files Macintosh Manager Macintosh Manager Items Migrating From AppleShare IP If login is Migration utility Test the new server Migrating to a New Server From Asip Provide Internet Aliases if necessary To mount the Asip server Mount the Asip server on Mac OS X ServerTo copy these items Copy the Users & Groups Data File and the mail database100 To create home directories for imported users 102 103 104 105