发现有时phpmyadmin导出的数据库不可以通过命令导入,所以统一全部用命令行导入。
1.导出;
windows:
mysqldump -u root baogg --default-character-set=utf8 --add-drop-table > "D:\www\usb\Dropbox\uml\baogg_%date:~0,4%%date:~5,2%%date:~8,2%_2.sql"
linux: mysqldump -uroot -p123456 --default-character-set=utf8 --add-drop-table baogg > /var/www/usb/Dropbox/uml/baogg_`date +"%Y%m%d"`.sql
--add-drop-table:删除以前的表
--default-character-set :设置编码
%date:~0,4%%date:~5,2%%date:~8,2%:为当前日期
2.导入
windows:
mysql -u root --default-character-set=utf8 baogg < "D:\www\usb\Dropbox\uml\baogg_%date:~0,4%%date:~5,2%%date:~8,2%.sql"
linux:
mysql -uroot -p123456 --default-character-set=utf8 baogg
3.导入csv
LOAD DATA INFILE '/home/user/文档/doc-2015.5.22.csv' into table xls_doc_20150522_2 FIELDS TERMINATED BY '\t' enclosed by '$'IGNORE 1 LINES;
如果出现以下错误,请innodb 引擎的限制引起的,如max_allowed_packet,innodb_log_file_size 加大
ERROR 1118 (42000): Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.
其他:
文件同步:本地project下面的目录同步到服务器上面的目录 :
rsync -avSH /var/www/html/* root@192.168.1.47:/var/www/html/