SpirirHost Support Centre: MySQL Reference Manual p.227

<< previous page -- table of contents -- next page >>

Chapter_1

Chapter_2

Chapter_3

Chapter_4

Chapter_5

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 4: Database Administration 227 -> REQUIRE CIPHER "EDH-RSA-DES-CBC3-SHA"; Also it is allowed to combine these options with each other like this: mysql> GRANT ALL PRIVILEGES ON test.* TO root@localhost -> IDENTIFIED BY "goodsecret" -> REQUIRE SUBJECT "C=EE, ST=Some-State, L=Tallinn, "> O=MySQL demo client certificate, "> CN=Tonu Samuel/Email=tonu@mysql.com" -> AND ISSUER "C=FI, ST=Some-State, L=Helsinki, "> O=MySQL Finland AB, CN=Tonu Samuel/Email=tonu@mysql.com" -> AND CIPHER "EDH-RSA-DES-CBC3-SHA"; But it is not allowed to use any option twice. Only dierent options can be mixed. 4.4 Disaster Prevention and Recovery 4.4.1 Database Backups Because MySQL tables are stored as les, it is easy to do a backup. To get a consistent backup, do a LOCK TABLES on the relevant tables followed by FLUSH TABLES for the tables. See Section 6.7.2 [LOCK TABLES], page 483. See Section 4.5.3 [FLUSH], page 248. You only need a read lock; this allows other threads to continue to query the tables while you are making a copy of the les in the database directory. The FLUSH TABLE is needed to ensure that the all active index pages is written to disk before you start the backup. If you want to make a SQL level backup of a table, you can use SELECT INTO OUTFILE or BACKUP TABLE. See Section 6.4.1 [SELECT], page 447. See Section 4.4.2 [BACKUP TABLE], page 228. Another way to back up a database is to use the mysqldump program or the mysqlhotcopy script. See Section 4.8.5 [mysqldump], page 299. See Section 4.8.6 [mysqlhotcopy], page 303. 1. Do a full backup of your databases: shell> mysqldump --tab=/path/to/some/dir --opt --full or shell> mysqlhotcopy database /path/to/some/dir You can also simply copy all table les (`*.frm', `*.MYD', and `*.MYI' les) as long as the server isn't updating anything. The script mysqlhotcopy does use this method. 2. Stop mysqld if it's running, then start it with the --log-update[=file_name] option. See Section 4.9.3 [Update log], page 309. The update log le(s) provide you with the information you need to replicate changes to the database that are made subsequent to the point at which you executed mysqldump. If you have to restore something, try to recover your tables using REPAIR TABLE or myisamchk -r rst. That should work in 99.9% of all cases. If myisamchk fails, try the

MySQL Reference Manual

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