<< 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
    304 MySQL Technical Reference for Version 4.0.3 -S, --socket=# Socket to use when connecting to local server --allowold Don't abort if target already exists (rename it   old) --keepold Don't delete previous (now renamed) target when done --noindices Don't include full index les in copy to make the backup smaller and faster The indexes can later be reconstructed with myisamchk -rq.. --method=# Method for copy (cp or scp). -q, --quiet Be silent except for errors --debug Enable debug -n, --dryrun Report actions without doing them --regexp=# Copy all databases with names matching regexp --suffix=# Sux for names of copied databases --checkpoint=# Insert checkpoint entry into speci ed db.table --flushlog Flush logs once all tables are locked. --tmpdir=# Temporary directory (instead of /tmp). You can use perldoc mysqlhotcopy to get a more complete documentation for mysqlhotcopy. mysqlhotcopy reads the groups [client] and [mysqlhotcopy] from the option les. To be  able to execute  mysqlhotcopy  you need write access  to the backup directory,  the SELECT  privilege for the tables you are about to copy and the MySQL  RELOAD  privilege (to be able to execute FLUSH TABLES). 4.8.7  mysqlimport, Importing Data from Text Files mysqlimport provides a command-line interface to the LOAD DATA INFILE SQL statement. Most options to mysqlimport correspond directly to the same options to LOAD DATA INFILE. See Section 6.4.9 [LOAD DATA], page 461. mysqlimport is invoked like this:
     

    Customer Support CentreMySQL Reference Manual

    Web Hosting Services
    UNIX WEB HOSTING
    SUPPORT & FAQ's
    TERMS OF USE
    Domain Services
    DOMAIN REGISTRATION
    MANAGE YOUR ACCOUNT
    SUPPORT & FAQ's
    TERMS OF USE
    SITE MAP
    Home
    Hosting Plans | Domain Registration | About Us | Contact Us | Site Map
    Terms of Use | Privacy Policy | Guarantees
    Merchant Accounts

    SpiritHost - web hosting for spiritual and education sites
    SpiritHit.com - Religious and Spiritual Portal

    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