프로그램을 실행하거나, 사용하는 도중에 다음과 같은 메시지가 다이얼로그 창으로 나타난다.
Word에서 작업 파일을 만들 수 없습니다. 임시 환경 변수를 확인하십시오
임시 인터넷 파일의의 주소가 잘못 지정되어있는 경우 발생한다. 임시 인터넷 파일 저장하는 폴더를 따로 설정했거나, 드라이브 재설치나 변경 등으로 문제가 발생할 수 있다.
실행에서 regedit를 실행시킨다.
HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders 로 이동한다.
이 곳에 있는 값 중에서 Cache 값은 임시 인터넷 파일 경로임을 알 수 있다. 잘못된 임시 인터넷 파일 경로를 올바른 경로로 수정해주면 문제가 해결된다.
scrollHeight 의 사용
<IFRAME name="mainFrame" src="document.html"></IFRAME>
document.html
<html>
<SCRIPT>
window.onload = function() {
var sH=document.body.scrollHeight;
parent.document.getElementById("mainFrame").style.height=sH+40;
}
</SCRIPT>
<body>
내용이 많아서 스크롤 바가 생긴다. 그런데 스크롤 생기는 건 싫다.
문서가 로딩 땔때 scrollHeight; 를 구해서 숫자를 조금 더해 준후 상위 프레임의
document.... 에서 mainframe 의 스타일 속성을 자동으로 설정 한다.
</body>
</html>
MySQL의 데이터를 백업하는 방법은 크게 두가지로 분류 할 수 있다.
1. mysqldump를 이용한 text타입의 백업 방법.
2. 데이터파일 자체를 복사하는 백업 방법.
두가지 방법모두 장단점이 있으므로 용도와 필요에 맞게 사용하는 것이 좋다.
1. mysqldump를 이용한 백업(출처 : http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html)
mysqldump는 Igor Romanenko라는 사람이 만든 백업 프로그램이다. 이는 database나 database의 일부를 백업하는 목적이나 다른 시스템으로 옮길때 사용된다. 그리고 원하는 분리 문자를 넣을 수 있어 CSV파일 등으로 만들 수 있으며, XML포맷으로 만들 수도 있다.
굉장히 많은 옵션들을 제공하고 있는 만큼 사용하는 방법과 용도 또한 여러가지이다. 먼저 가장 기본적인 사용법 부터 알아 보자. 아래에 옵션표를 첨부할 것이다.
1) database백업
MyISAM과 ARCHIVE table만 가능하다는 것이다.| Format | Config File | Description | Introduction |
|---|---|---|---|
| --add-drop-database | add-drop-database | Add a DROP DATABASE statement before each CREATE DATABASE statement | |
| --add-drop-table | add-drop-table | Add a DROP TABLE statement before each CREATE TABLE statement | |
| --add-locks | add-locks | Surround each table dump with LOCK TABLES and UNLOCK TABLES statements | |
| --all-databases | all-databases | Dump all tables in all databases | |
| --all-tablespaces | all-tablespaces | Adds to a table dump all SQL statements needed to create any tablespaces used by an NDB Cluster table | 5.1.6 |
| --allow-keywords | allow-keywords | Allow creation of column names that are keywords | |
| --comments | comments | Add comments to the dump file | |
| --compact | compact | Produce less verbose output | |
| --compatible=name[,name,...] | compatible | Produce output that is more compatible with other database systems or with older MySQL servers | |
| --complete-insert | complete-insert | Use complete INSERT statements that include column names | |
| --create-options | create-options | Include all MySQL-specific table options in the CREATE TABLE statements | |
| --databases | databases | Dump several databases | |
| --debug[=debug_options] | debug | Write a debugging log | |
| --debug-check | debug-check | Print debugging information when the program exits | 5.1.21 |
| --debug-info | debug-info | Print debugging information, memory and CPU statistics when the program exits | 5.1.14 |
| --delayed-insert | delayed-insert | Write INSERT DELAYED statements rather than INSERT statements | |
| --delete-master-logs | delete-master-logs | On a master replication server, delete the binary logs after performing the dump operation | |
| --disable-keys | disable-keys | For each table, surround the INSERT statements with disable and enable keys statements | |
| --dump-date | dump-date | Include dump date in "Dump completed on" comment if --comments is given | 5.1.23 |
| -E | events | Dump events from the dumped databases | |
| --extended-insert | extended-insert | Use multiple-row INSERT syntax that include several VALUES lists | |
| --fields-enclosed-by=string | fields-enclosed-by | This option is used with the -T option and has the same meaning as the corresponding clause for LOAD DATA INFILE | |
| --fields-escaped-by | fields-escaped-by | This option is used with the -T option and has the same meaning as the corresponding clause for LOAD DATA INFILE | |
| --fields-optionally-enclosed-by=string | fields-optionally-enclosed-by | This option is used with the -T option and has the same meaning as the corresponding clause for LOAD DATA INFILE | |
| --fields-terminated-by=string | fields-terminated-by | This option is used with the -T option and has the same meaning as the corresponding clause for LOAD DATA INFILE | |
| --lock-all-tables | first-slave | Deprecated. Now renamed to --lock-all-tables | |
| --flush-logs | flush-logs | Flush the MySQL server log files before starting the dump | |
| --flush-privileges | flush-privileges | Emit a FLUSH PRIVILEGES statement after dumping the mysql database | |
| --help | Display help message and exit | ||
| --hex-blob | hex-blob | Dump binary columns using hexadecimal notation (for example, 'abc' becomes 0x616263) | |
| --ignore-table=db_name.tbl_name | ignore-table | Do not dump the given table | |
| --insert-ignore | insert-ignore | Write INSERT statements with the IGNORE option | |
| --lines-terminated-by=string | lines-terminated-by | This option is used with the -T option and has the same meaning as the corresponding clause for LOAD DATA INFILE | |
| --lock-all-tables | lock-all-tables | Lock all tables across all databases | |
| --lock-tables | lock-tables | Lock all tables before dumping them | |
| --log-error=file_name | log-error | Append warnings and errors to the named file | 5.1.18 |
| --master-data[=value] | master-data | Write the binary log file name and position to the output | |
| --max_allowed_packet=value | max_allowed_packet | The maximum packet length to send to or receive from the server | |
| --net_buffer_length=value | net_buffer_length | The buffer size for TCP/IP and socket communication | |
| --no-autocommit | no-autocommit | Enclose the INSERT statements for each dumped table within SET autocommit = 0 and COMMIT statements | |
| --no-create-db | no-create-db | This option suppresses the CREATE DATABASE statements | |
| --no-create-info | no-create-info | Do not write CREATE TABLE statements that re-create each dumped table | |
| --no-data | no-data | Do not write any table row information (that is, do not dump table contents) | |
| --no-set-names | no-set-names | Turn off complete-insert | |
| --opt | opt | This option is shorthand; it is the same as specifying --add-drop-table --add-locks --create-options --disable-keys --extended-insert --lock-tables --quick --set-charset. | |
| --order-by-primary | order-by-primary | Sorts each table's rows by its primary key, or by its first unique index | |
| --password[=password] | password | The password to use when connecting to the server | |
| --pipe | On Windows, connect to server via a named pipe | ||
| --port=port_num | port | The TCP/IP port number to use for the connection | |
| --quick | quick | Retrieve rows for a table from the server a row at a time | |
| --quote-names | quote-names | Quote database, table, and column names within backtick characters | |
| --replace | replace | Write REPLACE statements rather than INSERT statements | |
| --result-file=file | result-file | Direct output to a given file | |
| -R | routines | Dump stored routines (procedures and functions) from the dumped databases | |
| --set-charset | set-charset | Add SET NAMES default_character_set to the output | |
| --single-transaction | single-transaction | This option issues a BEGIN SQL statement before dumping data from the server | |
| --skip-add-drop-table | skip-add-drop-table | Do not add | |
| --skip-add-locks | skip-add-locks | Do not add locks | |
| --skip-comments | skip-comments | Do not add comments to the dump file | |
| --skip-compact | skip-compact | Turn off compact | |
| --skip-disable-keys | skip-disable-keys | Do not disable keys | |
| --skip-extended-insert | skip-extended-insert | Turn off extended-insert | |
| --skip-opt | skip-opt | Turn off the options set by opt | |
| --skip-quick | skip-quick | Do not retrieve rows for a table from the server a row at a time | |
| --skip-quote-names | skip-quote-names | Turn off quote names | |
| --skip-set-charset | skip-set-charset | Suppress the SET NAMES statement | |
| --skip-triggers | skip-triggers | Turn off triggers | |
| --skip-tz-utc | skip-tz-utc | Turn off tz-utc | |
| --ssl-ca=file_name | ssl-ca | The path to a file that contains a list of trusted SSL CAs | |
| --ssl-capath=directory_name | ssl-capath | The path to a directory that contains trusted SSL CA certificates in PEM format | |
| --ssl-cert=file_name | ssl-cert | The name of the SSL certificate file to use for establishing a secure connection | |
| --ssl-cipher=cipher_list | ssl-cipher | A list of allowable ciphers to use for SSL encryption | |
| --ssl-key=file_name | ssl-key | The name of the SSL key file to use for establishing a secure connection | |
| --ssl-verify-server-cert | ssl-verify-server-cert | The server's Common Name value in its certificate is verified against the host name used when connecting to the server | |
| --tab=path | tab | Produce tab-separated data files | |
| --tables | tables | Override the --databases or -B option | |
| --triggers | triggers | Dump triggers for each dumped table | |
| --tz-utc | tz-utc | Add SET TIME_ZONE='+00:00' to the dump file | |
| --verbose | Verbose mode | ||
| --version | Display version information and exit | ||
| --where='where_condition' | where | Dump only rows selected by the given WHERE condition | |
| --xml | xml | Produce XML output |
