HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   General (http://www.howtoforge.com/forums/forumdisplay.php?f=25)
-   -   Import sql ispconfig shell user (http://www.howtoforge.com/forums/showthread.php?t=58201)

skoena 7th August 2012 15:18

Import sql ispconfig shell user
 
How can I import a sql file (db and user created with ispconfig) as a jailkit shell user?
(in which folder should I put the sql file?)

When I try this:
Quote:

mysql -u username -p
I get:
Quote:

bash: mysql: command not found

todx 7th August 2012 23:53

My best guess is that you haven't installed MySQL yet, that's what "command not found" usually means.

Edit: Once you've installed MySQL and configured it properly this command should work fine: "mysql -u USERNAME DATABASE < DATABASE.sql", where DATABASE.sql is located in directory you are executing the command from. Also this is not really an ISPConfig question =)

skoena 8th August 2012 07:29

Hi there,
My server is running for 3 years now and i do have it installed :)
Just the shell user has this issue.

till 8th August 2012 08:43

The error means that mysql is not installed in the jail of this user. You can install it e.g. with the jk_cp command:

http://olivier.sessink.nl/jailkit/jk_cp.8.html

e.g.:

jk_cp -j /var/www/clients/client1/web1 /usr/bin/cvs /usr/bin/mysql

to connect to mysql from within the jail, use the parametr -h 127.0.0.1

mysql -h 127.0.0.1 -u username -p


All times are GMT +2. The time now is 20:03.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.