create database if not exists test default charset utf8 collate utf8_general_ci;
{
如果不存在数据库test,就创建数据库,默认字符集为utf8,字符校验集为utf8_general_ci
}
grant all privileges on test.* to liang@'%' identified by 'xxxxxx';
{
创建用户liang并授予test数据库的所有权限,且该用户是可远程连接的。
}
mysqldump --opt -h192.168.0.156 -uUsername -pPassword databaseName>database.sql
{
远程导入导出数据
}
SELECT fid,name,type INTO OUTFILE 'test.sql' FIELDS TERMINATED BY ',' FROM test WHERE type=3
{
导出数据到文件中
}
LOAD DATA INFILE 'test.sql' INTO TABLE 'test' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (fid,name,type)
{
从文件中导入数据到数据库表中
}
(纯属个人备忘记录)