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:
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 =)
My server is running for 3 years now and i do have it installed :)
Just the shell user has this issue.
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 127.0.0.1
mysql -h 127.0.0.1 -u username -p
|All times are GMT +2. The time now is 18:27.|
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.