To make a backup copy of your mysql database via a SSH session:
mysqldump -e –force –quick -h mysqlhost -u Username -pPassword DatabseID > dbBackupFile.sql
backup/restore gbk characters and blob
mysqldump -hmysql.netfirms.com -uUsername -Password DatabseID –hex-blob –force > test.sql
Or you can load data in file
mysql -hmysql.eecho.info -P3306 -p111111 -uMyAdminUser dmydatabase
LOAD DATA LOCAL INFILE ‘E:\\Echo\\MySql_Server\\BackUps\\tbl_pagina.txt’ REPLACE INTO TABLE tbl_pagina;
To make a txt file use
SELECT * INTO OUTFILE ‘/tmp/result.txt’
If you use INTO DUMPFILE instead of INTO OUTFILE, MySQL writes only one row into the file, without any column or line termination and without performing any escape processing. This is useful if you want to store a BLOB value in a file.
SELECT * INTO DUMPFILE ‘/tmp/result.txt’
