MySQL数据导入导出与备份
kalmanfans
posted @ 2013年9月29日 20:49
in 数据库
, 1201 阅读
数据表数据导出为TXT、EXCEL格式
select CI,LAC,Longtitude,Latitude
into outfile "c:/data_outchen.txt"
lines terminated by "\r\n"
from buf_20070918;
数据表数据导出为TXT、EXCEL格式
从TXT、EXCEL格式导入到数据库中。
use db4teletra;
CREATE TABLE buf_20070918 (
`R_ID` int(10) NOT NULL AUTO_INCREMENT,
`CI` int(10) NOT NULL,
`LAC` int(10) NOT NULL,
`Longtitude` decimal(12,6) NOT NULL,
`Latitude` decimal(12,6) NOT NULL,
`Rechtswert_Y` decimal(12,3) NOT NULL,
`Hochwert_X` decimal(12,3) NOT NULL,
`Azimuth` int(10) DEFAULT NULL,
`Sectorangle` int(10) DEFAULT NULL,
`Repeater` int(10) DEFAULT NULL,
PRIMARY KEY (`R_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=6755 DEFAULT CHARSET=utf8;
use database_name;
load data local infile "c:/buf20070918.txt"
into table buf_20070918(CI, LAC, Longtitude, Latitude, Rechtswert_Y, Hochwert_X, Azimuth, Sectorangle, Repeater);
数据表数据导出为SQL语句
mysqldump -u root -p tele_tra_db buf_20070918 > dumpbuf.txt password mysql
数据库备份
2023年1月13日 15:35
MySQL data import, export and backup are important functions that help ensure the data in a MySQL database is safe and can be recovered if necessary. There are a few different ways to real estate des moines ia accomplish these tasks, and the method you use will depend on the specific needs of your database. In general, however, all three functions can be performed using the MySQL Workbench tool.