Re: [Support] Database

Luke wrote:

> Scott Kveton wrote:
> 
>>> Hey guys, Im trying to login to the database server via ssh, to install
>>> the database. But I can't seem to get in to the server. The connection
>>> times out. Is there a certain way I am supposed t o manage the mysql
>>> database other then ssh. I have an updated back up of the database on
>>> the arlinux.org server in /var/www/www.arklinux.org/geeklog/backups
>> 
>> Actually you won't connect to the database server via ssh; you would use
>> the 'mysql' command-line tools on arklinux to populate the database.
>>  
>>> The backups should be ordered by date, and the site has been takin
>>> offline.
>> 
>> You should be able to take one of those databases and do:
>> 
>> mysql -u username -p -h db1.osuosl.org --database yourdb < yourdata.sql
>> 
>> and then enter the password and it will upload the data to the database.
>> 
>> You can also use phpmyadmin at https://emma.osuosl.org/db1/ to connect
>> to the database and manipulate it.
>> 
>> Scott :-)
> 
> Ah excellent that'll work for me
> 
> Sorry Ive nevver really delt with offsite mysql systems before always
> local.

Harhar, yes im an idiot, so I was puting in the wrong password even though I
was looking at the darn thing. YES ! I can feel the donkey ears just
growing as I write this.