Re: [Support] Database

Scott Kveton <[email protected]> Sat, 26 Mar 2005 07:19:35 -0800
Newsgroups gmane.linux.arklinux.webdevelopment
Message-ID <[email protected]>
> 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 :-)