MySQL基本概念跟常用命令

MySQL基本概念和常用命令1 MySQL简介或者load data infile /tmp/test_outfile.txt into table test_outf

MySQL基本概念和常用命令
1 MySQL简介




或者

load data infile '/tmp/test_outfile.txt' into table test_outfile fields terminated by '"' enclosed by ',';

引用物理备份:
1. MyISAM 储存引擎的物理备份:
root@localhost:mysql> mysqlhotcopy db_name new_db_name

2. InnoDB储存引擎的物理备份:  使用ibbackup