Hi,

To write additional information in the dump file such as program version, server version, and host. . This option "--comments" is enabled by default. To suppress additional, use --skip-comments.


Regards,
S.Ashokkumar

Hi,

what's the difference between mysqldump and mysqlhotcopy ?

__________________
Keep smiling...

mysqlhotcopy :
It is the fastest way to make a backup of the database or single tables, but it can be run only on the same machine where the database directories are located. mysqlhotcopy works only for backing up MyISAM and ARCHIVE tables. It runs on Unix and NetWare.

mysqldump :
A client that dumps a MySQL database into a file as SQL statements or as tab-separated text files. It takes backup of all database tables regardless of the storage engine. This utility can be executed in any platform.

Ashok, Do u any idea about raw backup ?

__________________
Keep smiling...

RAW Backup :

It's more efficient to use a raw backup technique rather than using dumps. A raw backup is a direct copy of MySQL's data files as they exist on disk. Because the records aren't converted from their native format to ASCII, raw backups are much faster and more efficient than dumps. For ISAM and MyISAM tables, this means copying the data, index, and table definition files. For BDB and InnoDB tables, it also involves preserving the transaction logs and the data.

The dump SQL file we get using mysqldump utility occupies more disk space than raw backup.

Thanks ashok... got some idea about raw backup and this can be achieved using mysqlhotcopy utility... is that rite ?

__________________
Keep smiling...

yes prakash, you are correct.. but mysqlhotcopy will take raw backup only for myisam and archive tables.

Is mysql provides Online backup solution ?

__________________
Keep smiling...

Online backup solution for mysql is being developed by MySQL, probably we may get this in MySQL 6.0 release ;-) But there is a commercial tool available for mysql online backup, that's called INNODB Hot Backup.

InnoDB Hot Backup is the ideal solution for online backups of InnoDB tables in MySQL—and for setting up replication.

Yes ashok, i have checked in MySQL website and got the while paper for online backup solution that is being developed for mysql database..

__________________
Keep smiling...

HI,

mysqlshow
- This command is used to Shows the structure of a mysql database (databases,tables and columns).

DESCRIPTION
-#|--debug=...
output debug log. Often this is 'd:t,filename`

-?|--help
display help and exit

-c|--character-sets-dir=...
Directory where character sets are

-C|--compress
Use compression in server/client protocol

-h|--host=...
connect to host

-i|--status
Shows a lot of extra information about each table

-k|--keys
show keys for table

-p|--password[=...]
password to use connecting to server

-P|--port=...
Using Port number to connecting it

-S|--socket=...
Connecting the Socket file

-u|--user=#
user for login

-V|--version
output version information and exit

Thanks,
R.Gopi

Short note on MySQL Cold Backup

The MySQL server is stopped, the underlying data and configuration files
are copied to another location, and the MySQL server is restarted.

__________________
Keep smiling...