[BioSQL-l] Unable to access BioSQL

[Amihan Camson]

Hi Peter,

Thanks for your speedy reply! You helped me realize I didn't change
directory and had assumed creating Biosql made it an empty file.

Cheers,
Amihan

On Sun, Jun 14, 2020 at 11:28 AM Peter Cock <p.j.a.cock at googlemail.com>
wrote:

> Oh good.
>
> Peter
>
> PS Do you want to reply to the Mailing list?
>
> On Sat, 13 Jun 2020 at 22:26, Amihan Camson <acamson at hawaii.edu> wrote:
>
>> Hello Peter,
>>
>> Thank you for your quick reply. I'm just an idiot. Didn't change
>> directory. I assumed creating biosql made it an empty file.
>>
>> Thanks again!
>>
>> Amihan
>>
>> On Sat, Jun 13, 2020 at 1:59 AM Peter Cock <p.j.a.cock at googlemail.com>
>> wrote:
>>
>>> Hello Amihan,
>>>
>>> Apologies if I have pitched my answer at the wrong level. The error is
>>> probably about the missing SQL file, but it could be failing to find the
>>> mysql command.
>>>
>>> So first, is mysql installed properly? Try running it and asking the
>>> version:
>>>
>>> $ mysql -V
>>>
>>> Next, does the biosqldb-mysql.sql file exist in the current directory
>>> where the terminal is running?
>>>
>>> i.e. Try:
>>>
>>> $ pwd
>>> $ ls biosqldb-mysql.sql
>>>
>>> You might find the terminal starts in your home directory, but the file
>>> is in a Downloads subdirectory?
>>>
>>> Peter
>>>
>>>
>>> On Fri, Jun 12, 2020 at 9:16 PM Amihan Camson <acamson at hawaii.edu>
>>> wrote:
>>>
>>>> Hello,
>>>>
>>>> I am having trouble accessing BioSQL. I am using PUTTY as a terminal
>>>> with MySQL as my database. I am having trouble accessing BioSQL from my
>>>> terminal even though I have unzipped the downloaded file on my computer. Do
>>>> you have any suggestions on what to do? When I type "mysql -u root -p
>>>> biosqldb <  biosqldb-mysql.sql" into my terminal it returns an error: file
>>>> or directory does not exist. But I can open it manually on my laptop.
>>>>
>>>> Thank you for your time.
>>>>
>>>> Best regards,
>>>> Amihan
>>>> _______________________________________________
>>>> BioSQL-l mailing list
>>>> BioSQL-l at mailman.open-bio.org
>>>> https://mailman.open-bio.org/mailman/listinfo/biosql-l
>>>
>>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.open-bio.org/pipermail/biosql-l/attachments/20200614/35453463/attachment.htm>