Internal effect of taking backup :
when you execute the command to take the backup of the database,there are so many processes which and executions are made in the background.
It's a sample of the sql.dump file which was generated when I backed up the same database with the –-opt parameter-
Code:
#
# Table structure for table 'tbl_contactemails'
#
DROP TABLE IF EXISTS tbl_contactemails;
CREATE TABLE tbl_contactemails (
pk_ceId int(11) NOT NULL auto_increment,
ceEmail varchar(250) NOT NULL default '',
ceType int(11) default NULL,
PRIMARY KEY (pk_ceId),
UNIQUE KEY id (pk_ceId)
) TYPE=MyISAM;
#
# Dumping data for table 'tbl_contactemails'
#
LOCK TABLES tbl_contactemails WRITE;
INSERT INTO tbl_contactemails VALUES (18,'mitchell@devarticles.com',1),(17,'mitchell_harper@hotmail.com',1),(16,'mytch@dingoblue.net.au',1);
UNLOCK TABLES;
These are the procedures which internally happens with the dump file.
Bookmarks