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

Page 55
Image 55
Apple 034-2344 manual MySQL Data