1
|
mysqldump -u
"$DB_USER"
-p
"$DB_PASS"
-h
"$DB_HOST"
"$DB_NAME"
"$TBL_NAME"
> /home/backup/$TBL_NAME.$
DATE
.sql
|
1
|
mysql -u
"$DB_USER"
-p
"$DB_PASS"
"$DB_NAME"
<
/home/backup/
$TBL_NAME.$DATE.sql
|
1
2
3
|
mysql -u
"$DB_USER"
-p
"$DB_PASS"
#登录数据库
use
"$DB_NAME"
;
#选中数据库
truncate $TbalesName";
#清空数据库
|
1
|
mysqldump -u
"$DB_USER"
-p
"$DB_PASS"
-h
"$DB_HOST"
"$DB_NAME"
>
/home/backup/
$DATE.sql
|
1
|
mysqldump -u
"$DB_USER"
-p
"$DB_PASS"
-h
"$DB_HOST"
-d
"$DB_NAME"
"$TBL_NAME"
#加上-d
|
1
2
|
mysql>SELECT
sum
(DATA_LENGTH+INDEX_LENGTH) FROM TABLES WHERE TABLE_SCHEMA=
"$TBL_NAME"
#以字节为单位
mysql> SELECT
sum
(DATA_LENGTH+INDEX_LENGTH)
/1024/1024
FROM `TABLES` WHERE TABLE_NAME=
"$TBL_NAME"
#已M为单位
|
1
|
SELECT * FROM
"$TBL_NAME"
|