kalmanfans's Blog

模式识别 非线性预测 复杂网络 Following your heart

MySQL数据导入导出与备份

kalmanfans posted @ 2013年9月29日 20:49 in 数据库 , 1200 阅读
 
 
数据表数据导出为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
 
 
数据库备份
Small_feed 评论 (1)
1
[回复]
Avatar_small
Emma 说:
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.


登录 *


loading captcha image...
(输入验证码)
or Ctrl+Enter