HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (
-   General (
-   -   Import sql ispconfig shell user (

skoena 7th August 2012 16: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:

mysql -u username -p
I get:

bash: mysql: command not found

todx 8th August 2012 00: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 08: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 09: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:


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

mysql -h -u username -p

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

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