nixCraft
Linux / UNIX Tech Support Forum
need to convert text files into mysql database
This is a discussion on need to convert text files into mysql database within the Databases servers forums, part of the Mastering Servers category; Hello, I need to convert text files into mysql database Thanks...
|
|||||||
| Databases servers Discussions of databases of all types - especially MySQL. |
 |
|
|
LinkBack | Thread Tools | Display Modes |
| Sponsored Links | ||
|
|
28-09-2007, 01:17 PM
|
||||
|
||||
first confirm file has the structure and schema and having saved with sql extension.
now u can do 2 things 1: u can login in mysql and type "source" following by "path" of the file. 2: without logging in it, import it by issuing mysqldump or mysqlimport command. mysqlimport -f /path/of/the/file -d <database> 
|
|
12-07-2008, 12:31 PM
|
|||
|
|||
|
that's going to depend on if you need to translate your source files into CSV, tab-delimited, or what. MySQL can import CSV files in a clever way. If your dataset is large, filter it into tab-delimited and use LOAD DATA INFILE.
MySQL :: MySQL 5.0 Reference Manual :: 12.2.5 LOAD DATA INFILE Syntax MySQL :: MySQL 5.1 Reference Manual :: 13.11 The CSV Storage Engine Good luck!
|
|
«
Connect Microsoft Access Database With PHP On Linux Server
|
how to do MYSQL online backup of huge database
»
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| convert perl code into binary executable | chandanperl | Coding in General | 2 | 12-01-2010 01:03 PM |
| how to do MYSQL online backup of huge database | manish_2479 | Databases servers | 4 | 12-07-2008 12:36 PM |
| text output to mysql | chebbab | Shell scripting | 4 | 26-11-2007 07:29 PM |
| ssh backup particular mysql table / database | brothers | Databases servers | 11 | 25-10-2007 05:06 PM |
| Appending text files | sparky | Shell scripting | 13 | 03-04-2006 04:43 PM |
All times are GMT +5.5. The time now is 05:55 AM.
