MYSQL TUTORIALS - MySQL Database Export
MySQL Database Export
ADVERTISEMENTS
Exporting Data with the SELECT ... INTO OUTFILE Statement:
mysql> SELECT * FROM tutorials_tbl -> INTO OUTFILE '/tmp/tutorials.txt';ADVERTISEMENTS
mysql> SELECT * FROM passwd INTO OUTFILE '/tmp/tutorials.txt' -> FIELDS TERMINATED BY ',' ENCLOSED BY '"' -> LINES TERMINATED BY '\r\n';ADVERTISEMENTSExporting Tables as Raw Data:
$ mysqldump -u root -p --no-create-info \ --tab=/tmp TUTORIALS tutorials_tbl password ******Exporting Table Contents or Definitions in SQL Format:
$ mysqldump -u root -p TUTORIALS tutorials_tbl > dump.txt password ******
-- MySQL dump 8.23 -- -- Host: localhost Database: TUTORIALS --------------------------------------------------------- -- Server version 3.23.58 -- -- Table structure for table `tutorials_tbl` -- CREATE TABLE tutorials_tbl ( tutorial_id int(11) NOT NULL auto_increment, tutorial_title varchar(100) NOT NULL default '', tutorial_author varchar(40) NOT NULL default '', submission_date date default NULL, PRIMARY KEY (tutorial_id), UNIQUE KEY AUTHOR_INDEX (tutorial_author) ) TYPE=MyISAM; -- -- Dumping data for table `tutorials_tbl` -- INSERT INTO tutorials_tbl VALUES (1,'Learn PHP','John Poul','2007-05-24'); INSERT INTO tutorials_tbl VALUES (2,'Learn MySQL','Abdul S','2007-05-24'); INSERT INTO tutorials_tbl VALUES (3,'JAVA Tutorial','Sanjay','2007-05-06');
$ mysqldump -u root -p TUTORIALS > database_dump.txt password ******
$ mysqldump -u root -p --all-databases > database_dump.txt password ******Copying Tables or Databases to Another Host:
$ mysqldump -u root -p database_name table_name > dump.txt password *****
$ mysql -u root -p database_name < dump.txt password *****
$ mysqldump -u root -p database_name \ | mysql -h other-host.com database_name