Apple Mac OS X manual Web Content, To migrate the mail database

Page 42

42

Web Content

Copy saved web content to:

Â/Library/WebServer/Documents/

Â/Library/WebServer/CGI-Executables/

MySQL Data

If you backed up your MySQL data using mysqldump, you can restore the data using:

mysql -p table < backup-file.sql

or

mysql database < backup-file.sql

If the MySQL 4.0.18 database you’re migrating originated as a MySQL 3.23.x database and it’s still using the deprecated ISAM table format from MySQL 3.23, you must update it. ISAM is no longer supported with MySQL 4.1. Refer to the documentation on the MySQL website for migration details:

www.mysql.com/doc/en/Upgrading-from-3.23.html

This site suggests:

ÂRunning mysql_fix_privilege_tables to enable new security privilege features.

ÂRunning 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).

When running MySQL and PHP on the same server, you may find that PHP cannot connect to MySQL or that authentication errors occur when using PHP. For more information and workarounds, see the following AppleCare KnowledgeBase articles:

Â“Mac OS X Server 10.4: PHP and MySQL authentication issues” (article 301456)

Â“Mac OS X Server 10.4: Issues connecting PHP to MySQL” (article 301457)

Additional instructions for MySQL database backup and restore can be found in the MySQL documentation at www.mysql.com.

Mail Database

To migrate the mail database:

1Make sure that mail service isn’t running.

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

2Restore the saved mail database and mail store. By default the mail database resides in /var/imap/ and the mail store in /var/spool/imap/.

3Rename the saved ctl_mboxlist file to ctl_mboxlist.old, and then move it to /usr/bin/ cyrus/bin/.

If ctl_mboxlist.old is not present, the upgradedb script will fail in step 7 below.

Chapter 4 Migrating From Mac OS X Server Version 10.3

Image 42

Contents Mac OS X Server Apple Computer, Inc Apple Computer, Inc. All rights reserved Contents Migrating From AppleShare IP IndexAbout This Guide What’s in This GuideUsing This Guide Using Onscreen HelpMac OS X Server Suite This guide Tells you how toGetting Documentation Updates Getting Additional InformationServers From Which You Can Upgrade or Migrate Before You BeginMigrating From a Pre-Version 10.4 Server to Version Migrating Users and Groups Migrating From Windows NTUID Here is a list of the predefined group accounts Before You Begin Version Understanding What Can Be ReusedTo upgrade the master and its replicas Upgrading an Open Directory Master and Its ReplicasStep-by-Step Instructions Update your server to version Perform an upgrade installation to versionUpgrading Mac OS X Server Version Upgrading Mac OS X Server Version WebObjects Make Adjustments as needed after initial server setupTo update a WebObjects project Secure Sockets Layer SSL CertificatesNetBoot Images To upgrade a group recordDirectory Services GroupsWeb Service Print ServiceOpen Directory Upgrade Log Macintosh ManagerVersion Step-by-Step Instructions Upgrading Mac OS X Server Version Upgrading Mac OS X Server Version Make Adjustments as needed after initial server setup Groups Print Service Upgrading Mac OS X Server Version Before You Begin Understanding What You Can Migrate To reestablish the master and its replicasTo set up See Tools You Can UseGroup info User export file Export users and groups To export users and groupsCreate archive files MySQL Data Web Configuration DataWeb Content Mail DatabaseWebObjects Applications and Frameworks FTP Configuration FilesWebmail Data Tomcat DataIP Firewall User DataQuickTime Streaming Server Files and Folders Copy archive files to the new server To transfer tar files or disk images using FTPSet up the home directory infrastructure To prepare the server to store home directoriesTo import users and groups using Workgroup Manager Import users and groups and other dataTo migrate the web configuration Relocate saved data filesTo migrate the mail database AFP Configuration To migrate WebObjectsIP Firewall Configuration To migrate the IP firewall configurationDhcp Settings DNS ConfigurationTo migrate the DNS configuration To migrate the Dhcp configurationTest the new server Set up share points and privilegesTo create a share point and set privileges To test the new serverVersion Tools You Can Use Infrastructure Export users and groups Web Configuration Data Nidump -r /config/AppleFileServer . afpconfig Dhcp Import users and groups and other data Relocate saved data files Web Content To migrate the AFP configuration WebObjects Applications and Frameworks Server Admin, start firewall service Test the new server Version Tools You Can Use Export user Export users and groups AFP DNS Copy archive files to the new server Import exported users and groups and other data Relocate saved data files Mail Database AFP Configuration Tomcat Data User Data Migrating From Mac OS X Server Version AFP and NFS services File services administration guide Tools You Can Use Workgroup Manager or dsimport tool Export user and group information To export user and group informationCreate archive files To transfer tar files using FTP Import users and groups and other data Relocate saved data files QuickTime Streaming Server Files and Folders Migrating From Mac OS X Server Version Migrating From AppleShare IP Migrating From AppleShare IP Create Internet aliases for users Meichen,mei Mei chen Users Provide Internet Aliases if necessary Export user and group information if necessaryTo export user information from Asip Mount the Asip server on Mac OS X Server To mount the Asip serverCopy the Users & Groups Data File To copy this fileTo use the AppleShare IP Migration utility To import users and groups using Workgroup Manager Copy data to the new server Migrate mail To have users copy mailTo migrate the Asip mail database Migrating From AppleShare IP Index Index Reasons for migrating 10 requirements