ARCHIVED: Legacy MySQL for Webserve account details

• Core database:
  • The core database is contained within the mysql directory, /ip/account/mysql/data/mysql. This directory should not be deleted or corrupted.
  • The process ID of the running MySQL server process is contained in account.pid.
• Interactive login: You can log in to the server providing the MySQL service from an SSH (secure shell) client capable of using the SSH2 connection protocol.
• File transfer using SFTP (Secure FTP), and scp (Secure Copy): You can transfer data and other files to and from the server providing the MySQL service using either scp (Secure Copy)-equipped Unix platforms or the SFTP (Secure FTP) component of the Windows-based SSH (Secure Shell) client.
• Cron scheduled background processing: All MySQL service accounts are pre-enabled to use the cron scheduled background processing system. This enables you to run database checkpoint and backup processing at night (and sometimes during the day) without significantly impacting database or system performance because cron scheduled processing runs at a lower priority than your account's MySQL server.

  You are responsible for performing and maintaining your own database backups on mysql.iu.edu and mysql-test.iu.edu.

• The master MySQL configuration/settings file: Your account login directory contains a symbolic link to the master configuration file for your account's MySQL server named .my.cnf, which has been customized for your account. The master configuration file is provided as a read-only file. For assistance in making changes in your master configuration file, contact Web Services Support.

• Online MySQL reference manuals: For an online reference manual for the version of MySQL running on mysql.iu.edu, see MySQL 5.0 Reference Manual.