nixCraft
Linux / UNIX Tech Support Forum
loading data with INFILE
This is a discussion on loading data with INFILE within the Databases servers forums, part of the Mastering Servers category; Hi all, I am having trouble loading data directly into my database. I have copied the file onto the remote ...
|
|||||||
| Databases servers Discussions of databases of all types - especially MySQL. |
 |
|
|
LinkBack | Thread Tools | Display Modes |
23-10-2008, 03:19 PM
|
||||
|
||||
loading data with INFILE
Hi all,
I am having trouble loading data directly into my database. I have copied the file onto the remote server, but whenever I run the command : Code:
mysql -h host -u user -p -D test -e "load data infile '/tmp/CHANGE_Raw_Data.txt' replace into table changeTable fields terminated by '|'" Code:
ERROR 1045 (00000) at line 1: Access denied for user: 'user@host' (Using password: YES) BTW, due to IT issues, I am still running MySQL v3.23 and can't upgrade yet... 
|
| Sponsored Links | ||
|
|
|
24-10-2008, 08:46 PM
|
||||
|
||||
|
Try login using ssh:
Code:
ssh user@server-ip mysql -u user -p dbnane < INFILE
__________________
Vivek Gite Linux Evangelist  Be proud RHEL user, and let the world know about your enterprise choices! Join RedHat user group. Always use CODE tags for posting system output and commands! Do you run a Linux? Let's face it, you need help
|
|
05-11-2008, 02:13 PM
|
||||
|
||||
|
Thanks for the reply nixcraft, I have had a look at this, but isn't this the method for re-building a database or table from a mysqldump? The problem I still face, is that the data to be loaded is a 'pipe' separated text file, and won't load with this method...
|
|
| Tags |
| mysql , mysql load files , sql 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 |
| How loading Modules at boot time | muralidhara.rk | CentOS / RHEL / Fedora | 3 | 08-09-2009 02:37 PM |
| Linux XP not loading / booting Computer | newtolinux | Ubuntu / Debian | 1 | 11-06-2008 10:05 PM |
| Problem loading Atheros AR5005G in Ubuntu, Kubutu, & PCLinuxOS | blackrosebud | Linux hardware | 0 | 02-10-2007 11:10 PM |
| squid service error loading on startup | asim.mcp | Linux software | 5 | 27-07-2006 02:29 PM |
| print data to txt | rock | Shell scripting | 1 | 10-03-2006 02:01 AM |
All times are GMT +5.5. The time now is 11:26 AM.
