MySQL-command OK from commandline, notOK from bash-script

Habitual · 05-14-2013, 06:22 AM

Quote:

Originally Posted by jonaskellens

To grant "file" to a user other than root seems very dangerous...

I can't seem to find an alternative to import a csv-file into MySQL.

really? how about the root mysql-user?

I have Never used the file perm, nor have I Ever assigned it to anyone, nor never needed to for an import.
mysql -u <mysql_privileged_user> -p <db> < file.sql

Habitual · 05-14-2013, 06:49 AM

http://www.linuxquestions.org/questi...pt-4175461780/

jonaskellens · 05-14-2013, 07:36 AM

Quote:

Originally Posted by Habitual

mysql -u <mysql_privileged_user> -p <db> < file.sql

This is no alternative to import a csv-file. Like I said earlier I have no sql-file but a csv-file.

jonaskellens · 05-14-2013, 07:43 AM

Quote:

Originally Posted by chrism01

bash is interpreted, I believe php is not, so php should be faster & less resources.

Then I will use php and my problem of importing csv-data into external MySQL-database will also be solved I guess.

Habitual · 05-14-2013, 07:56 AM

try http://dev.mysql.com/doc/refman/5.0/...ort.html#c5680

<IMO>I am not certain that "GRANT FILE" is what you really need to get this job done.</IMO>

typically, I'd load data as root into a specific mysql_db, this way I only have to worry about what I do to the db, NOT worry about THE USER
trashing stuff.
the .csv may need some "massaging", or manipulation.

See also:
http://stackoverflow.com/questions/6...a-command-line
http://kurinchilamp.kurinchilion.com...mand-line.html
and
http://alvinalexander.com/blog/post/...database-table

Good luck.

jonaskellens · 05-14-2013, 08:05 AM

Quote:

Originally Posted by Habitual

typically, I'd load data as root into a specific mysql_db

I can not reveal root login information inside the bash script.

Habitual · 05-14-2013, 09:03 AM

Quote:

Originally Posted by jonaskellens

I can not reveal root login information inside the bash script.

Who said anything about revealing any passwords?
http://kurinchilamp.kurinchilion.com...mand-line.html

If you want to be spoon-fed, I charge $1000.00 per hour USD.

Easy answer: and the sanest, Create a csv-only user.

Code:

mysql -u root -p grant all privileges on dbname.* to csv_import@localhost ‘IDENTIFIED BY ‘n4Tur3aL’; flush privileges;"

then use mysql -u csv_import -p n4Tur3aL and work the import using those credentials.

jonaskellens · 05-14-2013, 09:15 AM

In your link passwords are revealed. This is not useful. Even if you charge $50.00 I would not recommend you.

Meanwhile I found another solution combining php and bash, which gives me the best of both worlds.

szboardstretcher · 05-14-2013, 09:16 AM

Hi. Why are you trying to import the rest of the file into a sql database? I dont like the idea. I make a shell script, and make a sql file, then import the sql file with the shell script.

Anyway... try this in your script.

Code:

#!/bin/bash -l

mysql -u MyUser -pMyPassword -h ip_databaseserver -D My-DB < some_file.sql

Habitual · 05-14-2013, 09:29 AM

Quote:

Originally Posted by jonaskellens

In your link passwords are revealed.

Big Fargin' Deal. Change it?

Quote:

This is not useful.

Again with the "spoon-feed me" response.

Quote:

Even if you charge $50.00 I would not recommend you.

I'm not sure you could count it.

Quote:

Meanwhile I found another solution combining php and bash, which gives me the best of both worlds.

You are all over the map on this "solution".

Good luck.

jonaskellens · 05-14-2013, 09:43 AM

Quote:

Originally Posted by szboardstretcher

Hi. Why are you trying to import the rest of the file into a sql database? I dont like the idea. I make a shell script, and make a sql file, then import the sql file with the shell script.

We have software that produces csv-files.

What I wanted is a bash script that puts the content of these csv-files into a remote MySQL-database.

But I was getting the error in my original post, which seemed to be related to the lack of the "FILE"-permission of the database user.

Adding the "FILE"-permission to the user seemed unsafe.

So that is where I stranded with the bash-script.

Found another way to implement using php and bash.

Thanks.

szboardstretcher · 05-14-2013, 09:49 AM

Quote:

Originally Posted by jonaskellens

Found another way to implement using php and bash.

Good to hear. Mind sharing the php/bash way with us, so this thread can be useful to someone in the future?

Tinkster · 05-14-2013, 09:18 PM

Merged the two VERY closely related threads.