Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MySql backups 1
- Thread starter ilanmod
- Start date
-
1
- #2
Kozusnik
Programmer
- Feb 27, 2005
- 620
Save the excel file as csv.
Log in from the command prompt...
$mysql -u root -p password
mysql> use databasename;
Load data infile...
LOAD DATA LOCAL INFILE '/importfile.csv'
INTO TABLE test_table
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(field1, filed2, field3);
Mark
Log in from the command prompt...
$mysql -u root -p password
mysql> use databasename;
Load data infile...
LOAD DATA LOCAL INFILE '/importfile.csv'
INTO TABLE test_table
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(field1, filed2, field3);
Mark
- Status