Rover's Home

The person who risks nothing does nothing, has nothing, is nothing. He may avoid suffering and sorro...

DATA IMPORT & EXPORT

  Data Import & Export
 
1. MySQL
 
data export:
%MYSQL_HOME%/bin> mysqldump [options] database [tables]
 
eg.  mysqldump --opt database_name > backupfile.sql
 

data import:
There are two commands for importing, mysql and mysqlimport.
The first one import msql dump file into a database.
The second one import data from a txt file into a table. The txt filename and the table name should be the same.
 
eg. (1) mysql> mysql database_name < backupfile.sql
     (2) %MYSQL_HOME%/bin> mysqlimport database_name tablename.txt
 
阅读更多
个人分类: Database
想对作者说点什么? 我来说一句

solr配置dataimport步骤

dataimpor

u010367582 u010367582

2017-01-05 17:46:29

阅读数:5963

没有更多推荐了,返回首页

加入CSDN,享受更精准的内容推荐,与500万程序员共同成长!
关闭
关闭