Hey I ordered by dedi on saturday and when I got it a few days ago I installed torrentflux. I don't have a control panel so I used SSH to make the database and load the SQL files into it. It seemed to work okay, but when I try and use torrentflux it just gives me a blank page. Apache is running, so is PHP, and MySQL, and Python. So I think it's something to do with the database. Can anyone tell me the SSH commands to read whats inside the database? Or where the database files are stored in sftp? Cheers!
It won't help reading the raw database files. You'll need to use the "mysql" command after logging in. Like this: mysql -u <username> -p<password> <database> (no space after the "-p") Code (markup): This will take you to the mysql prompt where you can run your queries. Also, you might want to check out Apache's error logs to see what the issue might be.
I've never been a fan of the -p flag. You're putting a plaintext password in your ~/.bash_history. =(
Same here. I always leave the "-p " without specifying the password on the command line and enter it at the prompt. However, most instructions and HOWTOs tell you to use it with the password and I didn't want to confuse anyone.
Here is a basic list of SSH commands : http://www.keralpatel.com/using-ssh-and-its-commands/ It might help you