Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 7th August 2012, 16:18
skoena skoena is offline
Senior Member
 
Join Date: Sep 2009
Location: Emmen, Netherlands
Posts: 421
Thanks: 78
Thanked 14 Times in 12 Posts
Send a message via MSN to skoena Send a message via Skype™ to skoena
Default 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
Reply With Quote
Sponsored Links
  #2  
Old 8th August 2012, 00:53
todx todx is offline
Member
 
Join Date: Apr 2012
Posts: 77
Thanks: 33
Thanked 6 Times in 5 Posts
Default

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 =)

Last edited by todx; 8th August 2012 at 00:57.
Reply With Quote
  #3  
Old 8th August 2012, 08:29
skoena skoena is offline
Senior Member
 
Join Date: Sep 2009
Location: Emmen, Netherlands
Posts: 421
Thanks: 78
Thanked 14 Times in 12 Posts
Send a message via MSN to skoena Send a message via Skype™ to skoena
Default

Hi there,
My server is running for 3 years now and i do have it installed
Just the shell user has this issue.
Reply With Quote
  #4  
Old 8th August 2012, 09:43
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,733
Thanks: 840
Thanked 5,596 Times in 4,407 Posts
Default

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
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
skoena (8th August 2012)
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ISPConfig 3.0.3.3 fresh instalation - email tab is empty artur_gib Installation/Configuration 14 28th January 2014 20:02
No dns zone files created? sjau Installation/Configuration 7 13th March 2012 14:15
All files gone after changing quota to 0 spynode General 17 19th January 2012 15:41
PHP warnings after upgrade to ISP config 3.03 stevegjacobs Installation/Configuration 5 30th October 2010 15:31
Chilispot on dd-wrt + freeradius / phpmyprepaid on Centos 5 wrong user password treeman HOWTO-Related Questions 0 31st May 2009 07:49


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


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