Installing a mysql DB via SSH
This is a discussion on Installing a mysql DB via SSH within the Server / Technical Administration Tips and Queries forums, part of the Webmaster Help category; Hi guys, I have a SSH session open on my VPS. I have cd'd into the httpdocs folder in which ...
| |||||||
| Register | Forum Rules | FAQ | Donate | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
16-08-2008, 06:01 PM
| |||||
| |||||
 Installing a mysql DB via SSH Hi guys, I have a SSH session open on my VPS. I have cd'd into the httpdocs folder in which I have placed a file called db.sql. I have created a DB via my control panel with the necessary username and password. I'm running this command: mysql -u DBusername -p DBpassword DBname < db.sql But I'm getting an error stating "command not found". What am I doing wrong?         |
|
16-08-2008, 06:50 PM
| |||||
| |||||
| Is the command "mysql" in your path? ie. if you start typing mysql and hit the tab key, does it autocomplete?
__________________ Hosting & Domains|Plesk Vps Hosting|Geek / Cool Stuff|Films.ie|Cool Sites|Monetisation Tips|Movie Chat Energise your forum! Click here for info |
|
16-08-2008, 07:16 PM
| |||||
| |||||
| No, the command mysql isn't in the path. After looking into SSH further it seems that I have to be in the mysql directory in order to run the command (makes sense now of course!) but I can't actually find the mysql directory. Quote:
|
|
16-08-2008, 07:30 PM
| |||||
| |||||
| Hi Paul, I'm logged in as a user with /bin/bash (chrooted) access on Plesk. |
|
16-08-2008, 07:51 PM
| |||||
| |||||
| When you say root do you mean the root account of the server or a root account relating to the specific domain? I have logged in as the root of the server but then I am clueless as to do next. I'm not sure how I navigate to the msql directory from there. |
|
16-08-2008, 09:04 PM
| |||||
| |||||
| Mmm, when I login and run the command mysql -u DBuser -p DBpass DBname < blog.sql I get the error -bash: blog.sql: No such file or directory That's why I thought I might need to be in the httpdocs root or a similar dir to run the command successfully. (thanks for the help btw) |
|
16-08-2008, 09:10 PM
| ||||
| ||||
| Well, I was going to mention that :-) You can give the full path to the file if you like. I _think_ the vhosts are in /var/www/vhosts/ but I can't recall. Paul |
 |
| Tags |
| installing, mysql, ssh |
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Analytics - Installing UTM tracking code? | Wenlock | Search Engine Optimisation | 1 | 19-07-2008 11:16 AM |
| Installing Ubuntu | TheMenace | Desktop Computer Issues | 4 | 23-11-2007 02:35 PM |
| Installing ISAPI Rewrite | glengara | Server / Technical Administration Tips and Queries | 4 | 01-10-2007 11:38 AM |
| Installing MySQL on Mac? | ButtermilkJack | Coding Help | 6 | 25-01-2007 09:46 PM |
| Installing a Web Mail Client | Cormac | Server / Technical Administration Tips and Queries | 10 | 18-08-2006 04:51 PM |
| ||||||||
| |  |  | ||||||
All times are GMT +1. The time now is 11:59 AM.
