[Product] Unable to use the POD .sql database

Thu Apr 24 16:55:16 UTC 2014

Hi Bertrand,

This link should help :
http://fr.openclassrooms.com/informatique/cours/pour-aller-plus-loin-41/lancer-le-client

Sincerely

Guillaume

On 24/04/2014 17:00, Bertrand Toulas wrote:
> 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 
> <mailto: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 <mailto:product at lists.okfn.org>
>         https://lists.okfn.org/mailman/listinfo/product
>
>
>     _______________________________________________
>     product mailing list
>     product at lists.okfn.org <mailto: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/57dc38c6/attachment-0002.html>