<< previous page   --   table of contents   --   next page >>
| | | | | | | |
  • Return to Table of Contents
    • Table of Contents
    1. General Information
    2. MySQL Installation
    3. Tutorial Introduction
    4. Database Administration
    5. MySQL Optimisation
    6. MySQL Language Reference
    7. MySQL Table Types
    8. MySQL APIs
    9. Extending MySQL
    Chapter 2:  MySQL Installation 99 /bin/sh -c 'cd /usr/local/mysql ; ./bin/safe_mysqld --user=mysql &' You  can  also  add  options  for  mysql.server  in  a  global  `/etc/my.cnf'   le.    A  typical `/etc/my.cnf' le might look like this: [mysqld] datadir=/usr/local/mysql/var socket=/var/tmp/mysql.sock port=3306 user=mysql [mysql.server] basedir=/usr/local/mysql The mysql.server script understands the following options:  datadir, basedir, and pid- file. The following table shows which option groups each of the startup scripts read from option les: Script Option groups mysqld mysqld and server mysql.server  mysql.server,   mysqld,  and server safe_mysqld    mysql.server,   mysqld,  and server See Section 4.1.2 [Option les], page 186. 2.5  Upgrading/Downgrading MySQL You can always move the MySQL form and data les between di erent versions on the same architecture as long as you have the same base version of MySQL. The current base version is 3.  If you change the character set when running MySQL (which may also change the sort order), you must run myisamchk -r -q on all tables.  Otherwise, your indexes may not be ordered correctly. If you are afraid of new versions, you can always rename your old mysqld to something like mysqld-old-version-number.  If your new  mysqld  then does something unexpected, you can simply shut it down and restart with your old mysqld! When you do an upgrade you should also back up your old databases, of course. If after an upgrade, you experience problems with recompiled client programs, like Commands out of sync or unexpected core dumps, you probably have used an old header or library le when compiling your programs. In this case you should check the date for your `mysql.h' le and `libmysqlclient.a' library to verify that they are from the new MySQL distribution. If not, please recompile your programs! If  you  get  some  problems  that  the  new  mysqld  server  doesn't  want  to  start  or  that  you can't connect without a password, check that you don't have some old `my.cnf' le from your old installation!  You can check this with:  program-name --print-defaults.  If this outputs anything other than the program name, you have an active `my.cnf' le that will a ect things!
     

    Customer Support CentreMySQL Reference Manual

    Web Hosting Services
    UNIX WEB HOSTING
    MERCHANT ACCOUNTS
    DEDICATED SERVERS
    E-COMMERCE HOSTING
    SUPPORT & FAQ's
    TERMS OF USE
    Domain Services
    DOMAIN
    REGISTRATION
    MANAGE
    YOUR ACCOUNT
    SUPPORT & FAQ's
    TERMS OF USE
    Corporate Info
    ABOUT US
    OUR NETWORK
    CONTACT US
    SITE MAP
    UNIX Web Hosting | Merchant Accounts | Dedicated Hosting | E-Commerce Hosting
    Domain Registration | About Us | Our Network | Contact Us | Site Map
    Our Partners
    Copyright © 2002 Dyntex Group, Inc. All Rights Reserved
  • Return to Table of Contents
    		•
  • Back to top
    • Web Hosting: Manuals & FAQ's
    1. Unix-Based Web Hosting
    2. Unix Dedicated Servers
    3. Windows Dedicated Servers
    4. CuteFTP User’s Guide
    5. CuteHTML User’s Guide
    6. WS_FTP Pro User's Guide
    7. Miva Order User's Guide
    8. Miva Merchant User's Guide