IOTN :: Work Book :: MySQL

ȸ¿ø°¡ÀÔ

mysql Å×ÀÌºí º¹±¸ [ sed start_txt .... end_text ºí·° ±¸°£ text È®ÀÎ , table recover ]

ÃÖ±æÈ£ [LIST]   2020-07-04 12:56:26, Á¶È¸ : 248 Å×ÀÌºí º¹±¸ cat >> ~/.bash_profile export MYSQL_PS1='\u@\d> ' sed -n -e '/CREATE TABLE.*`board`/,/UNLOCK TABLES/p' /data/backup/full.200704.sql > board.sql mysql ... --default-character-set=euckr show variables like 'c%'; set names euckr; source board.sql Ãâó: https://stackoverflow.com/questions/1013852/can-i-restore-a-single-table-from-a-full-mysql-mysqldump-file

LIST

Copyright 1999-2022 Zeroboard / skin by ÃÖ±æÈ£(gilho.kr@gmail.com)