[Product] Unable to use the POD .sql database

Thu Apr 24 15:00:58 UTC 2014

Hi Guillaume,

Thank you for your reply. Unfortunately, being a complete novice to this
kind of thing I don't understand of what you typed. I did install mysql,
launched mysql.exe and typed "use <db name>" but all I got was this:
"ERROR 1044 <42000>: Access denied for user ' ' @' localhost' to database"

More generally I'm not really comfortable with all this to be honest...

Any more advice maybe?

Regards,
Bertrand

2014-04-24 16:10 GMT+02:00 Guillaume - Hiboutik <g at hiboutik.com>:

>
> Hi,
>
> The easiest way is to use command line.
>
> Under Linux :
> cat pod_web.sql | mysql -hlocalhost -uusername -ppassword db_name
>
> Under Windows, the command might look like this:
> cd C:\MYSQL\bin\
> mysql.exe -u username -p password
> USE db_name;
> source 'pod_web.sql';
> quit
>
>
> Sincerely
>
> Guillaume
>
>
>
>
> On 24/04/2014 15:10, Bertrand Toulas wrote:
>
>> Hello,
>>
>> I have been trying to use the POD database dump found here:
>> http://www.product-open-data.com/download/
>>
>> However, everything I have tried so far has failed. As suggested on the
>> page, I used WAMP with Big Dump, and everything works fine up until the
>> point where Big Dump says - as far as I can understand - that the .sql
>> file
>> contains lines that are too big for it handle them.
>>
>> I have tried using various SQL database viewing programs as well, but all
>> of them either give me an error message ('out of memory'), garbled
>> characters or an empty page
>>
>> I am a complete layman when it comes to MySQL and php, so I might be
>> doing something wrong, but do you know how to solve my problem?
>>
>> Thank you very much.
>>
>>
>> Regards,
>>
>> Bertrand Toulas
>>
>>
>>
>> _______________________________________________
>> product mailing list
>> product at lists.okfn.org
>> https://lists.okfn.org/mailman/listinfo/product
>>
>>
> _______________________________________________
> product mailing list
> product at lists.okfn.org
> https://lists.okfn.org/mailman/listinfo/product
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/product/attachments/20140424/fb5bc09f/attachment-0002.html>