[BioSQL-l] Unable to access BioSQL

[Peter Cock]

Happy to help.

Peter

On Mon, Jun 15, 2020 at 8:08 AM Amihan Camson <acamson at hawaii.edu> wrote:

> 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/20200615/4be4867e/attachment.htm>