Re: [Support] Database

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

Nevermind guys, I got past the syntax error, I just dropped the default
charset from all the statments in the db backup. Everything is good to go
and running.

Thanks for your help
-- 
ArkLinux - Definition: Choice 
http://www.arklinux.org 
IRC channel - #arklinux

Luke Anthony Hebert