Done ! Hope it's fine for you :-)
Best.
Julien.
2013/4/16 Jona Christopher Sahnwaldt <j...@sahnwaldt.de>
> On 16 April 2013 20:55, Julien Plu <julien....@redaction-developpez.com>
> wrote:
> > That depends where you install mysql, with the packages from ubuntu
> > repositories it's located in /etc/mysql.
> >
> > I think the "grant all ....." line is useless, the best thing (and most
> > easy) is to ask to users to use root user. Here how I see things :
> >
> > step 1 : install mysql
> > step 2 : open my.cnf file (in mysql root directory if installed by hand
> or
> > in /etc/mysql/ if installed with ubuntu packages)
> > step 3 : add these parametesr in the [mysqld] section to have the utf8
> > encoding by default :
> >
> > character-set-server=utf8
> > skip-character-set-client-handshake
> >
> > step 4 : change max_allowed_packet=16M to max_allowed_packet=1G
> > step 5 : change key_buffer=16M to key_buffer=1G
> >
> > ===> "key_buffer_size" parameter is now deprecated, use "key_buffer"
> > instead.
> >
> > step 6 : change query_cache_size=16M to query_cache_size=1G
> >
> > These next step are made for those who installed mysql by hand :
> >
> > step 7 : set socket parameter to "$MYDIR/mysqld.sock"
> >
> > ====> now it's mysqld.sock and not mysql.sock
> >
> > step 8 : set datadir parameter to "$MYDIR/data"
> >
> > step 9 : open your ~/.bashrc file to add : export
> > MYDIR=/path/where/you/installed/mysql
> >
> > What do you think ?
>
> Looks good! You're welcome to add these instructions to
>
> https://github.com/dbpedia/extraction-framework/wiki/Dbpedia-Abstract-Extraction-step-by-step-guide
> , maybe in a new section to keep the page manageable.
>
> Thanks!
>
> JC
>
> >
> > Best.
> >
> > Julien.
> >
> >
> >
> >
> > 2013/4/16 Andrea Di Menna <ninn...@gmail.com>
> >>
> >> Actually MySQL should be looking for configuration files in different
> >> locations
> >>
> >>
> >>
> http://dev.mysql.com/tech-resources/articles/mysql_intro.html#SECTION0001500000
> >>
> >> Cheers
> >> Andrea
> >>
> >> Il giorno 16/apr/2013 20:24, "Julien Plu"
> >> <julien....@redaction-developpez.com> ha scritto:
> >>
> >>> Yes I think it's the best idea, and I think too that mysql is
> configured
> >>> only by the "/etc/mysql/my.cnf" file.
> >>>
> >>> Best.
> >>>
> >>> Julien.
> >>>
> >>>
> >>> 2013/4/16 Jona Christopher Sahnwaldt <j...@sahnwaldt.de>
> >>>>
> >>>> On 16 April 2013 19:56, Julien Plu <
> julien....@redaction-developpez.com>
> >>>> wrote:
> >>>> > As you wish, it's just a standard configuration with 3-4
> modifications
> >>>> > nothing more.
> >>>> > But at least I can precise in the guide the parameters that
> >>>> > they must change ?
> >>>>
> >>>> Just copy the parameters used in mysql.sh to the config file, without
> >>>> the leading '--'. Thus:
> >>>>
> >>>> mysql.sh:
> >>>>
> >>>> ./bin/mysqld_safe --no-defaults --character-set-server=utf8
> >>>> --socket="$MYDIR/mysql.sock" --bind-address=localhost
> >>>> --datadir="$MYDIR/data" --max_allowed_packet=1G --key_buffer_size=1G
> >>>> --query_cache_size=1G >>"$MYDIR/mysql.log" 2>&1 &
> >>>>
> >>>> config file:
> >>>>
> >>>> socket="$MYDIR/mysql.sock"
> >>>> bind-address=localhost
> >>>> character-set-server=utf8
> >>>> datadir="$MYDIR/data"
> >>>> max_allowed_packet=1G
> >>>> key_buffer_size=1G
> >>>> query_cache_size=1G
> >>>>
> >>>> Maybe that works, I don't know. Maybe you have to replace '-' by '_'.
> >>>> Or maybe the names are actually different.
> >>>>
> >>>> Also, I don't remember what no-defaults does and if should be in a
> >>>> config file.
> >>>>
> >>>> I think MySQL uses different config files for client and server, so
> >>>> you may have to edit them both.
> >>>>
> >>>> JC
> >>>>
> >>>> >
> >>>> > And I think you right for (at least) your LocalSettings.php because
> it
> >>>> > doesn't work with me :-( And I have to test the solution from
> >>>> > Dimitris.
> >>>> >
> >>>> > Best.
> >>>> >
> >>>> > julien.
> >>>> >
> >>>> >
> >>>> > 2013/4/16 Jona Christopher Sahnwaldt <j...@sahnwaldt.de>
> >>>> >>
> >>>> >> The problem with having a whole configuration file in the repo is
> >>>> >> that
> >>>> >> the file probably contains many other settings besides the ones we
> >>>> >> need, and it changes with each MySQL version. When we use command
> >>>> >> line
> >>>> >> parameters, we don't have to change any MySQL config files, we just
> >>>> >> add the three or four settings that we need, and they don't change
> >>>> >> between MySQL versions.
> >>>> >>
> >>>> >> Maybe there is a way to tell MySQL, "here's an addtional config
> file
> >>>> >> whose settings should override the ones in the main config file".
> >>>> >> Then
> >>>> >> we could check in a minimal config file with just our settings. But
> >>>> >> taking a large config file from a MySQL installation, changing a
> few
> >>>> >> lines and then putting the modified version into the repo leads to
> >>>> >> more problems than it solves.
> >>>> >>
> >>>> >> We have the same problem with MediaWiki: we once took
> >>>> >> LocalSettings.php and ApiParse.php from a MediaWiki installation,
> >>>> >> modified a few lines and put the whole files into our repo. But in
> >>>> >> newer versions, the files look quite different, and the versions
> from
> >>>> >> our repo just don't work. Users have to edit the files and add the
> >>>> >> stuff needed for the abstract extractor.
> >>>> >>
> >>>> >> Cheers,
> >>>> >> JC
> >>>> >>
> >>>> >> On 16 April 2013 15:39, Julien Plu
> >>>> >> <julien....@redaction-developpez.com>
> >>>> >> wrote:
> >>>> >> > Ok thank you :-)
> >>>> >> >
> >>>> >> > I finish all the extraction process, and after I will modify the
> >>>> >> > guide
> >>>> >> > to
> >>>> >> > include what I think is missing. For the conf file I will make a
> >>>> >> > pull
> >>>> >> > request with mine if everything is ok during all the process.
> >>>> >> >
> >>>> >> > Best.
> >>>> >> >
> >>>> >> > Julien.
> >>>> >> >
> >>>> >> >
> >>>> >> > 2013/4/16 Dimitris Kontokostas <jimk...@gmail.com>
> >>>> >> >>
> >>>> >> >> Hi Julien,
> >>>> >> >>
> >>>> >> >> You are free to improve any page on our wiki :)
> >>>> >> >>
> >>>> >> >> Regarding the MySQL script, if you think a conf file is easy to
> >>>> >> >> create
> >>>> >> >> and
> >>>> >> >> use, you can make a pull request and we 'll make the necessary
> >>>> >> >> tests.
> >>>> >> >>
> >>>> >> >> Best,
> >>>> >> >> Dimitris
> >>>> >> >>
> >>>> >> >>
> >>>> >> >> On Tue, Apr 16, 2013 at 1:14 PM, Julien Plu
> >>>> >> >> <julien....@redaction-developpez.com> wrote:
> >>>> >> >>>
> >>>> >> >>> Ok so if I have your approval I will modify the step-by-step
> >>>> >> >>> guide.
> >>>> >> >>>
> >>>> >> >>> And maybe instead of using a script we can put a copy of a
> mysql
> >>>> >> >>> configuration file that users must have, no ? Less work (you
> >>>> >> >>> don't
> >>>> >> >>> have a
> >>>> >> >>> script to maintain) and more easy for users. What do you think
> ?
> >>>> >> >>> Unless
> >>>> >> >>> there is a minimal or maximal version of mysql to use ?
> >>>> >> >>>
> >>>> >> >>> Best.
> >>>> >> >>>
> >>>> >> >>> Julien.
> >>>> >> >>>
> >>>> >> >>>
> >>>> >> >>> 2013/4/16 Jona Christopher Sahnwaldt <j...@sahnwaldt.de>
> >>>> >> >>>>
> >>>> >> >>>> PS: It would be cool if you could add a few lines to
> >>>> >> >>>>
> >>>> >> >>>>
> >>>> >> >>>>
> >>>> >> >>>>
> https://github.com/dbpedia/extraction-framework/wiki/Dbpedia-Abstract-Extraction-step-by-step-guide
> >>>> >> >>>> or even improve the script itself with better error and usage
> >>>> >> >>>> messages
> >>>> >> >>>> and send a pull request.
> >>>> >> >>>>
> >>>> >> >>>>
> https://github.com/dbpedia/extraction-framework/wiki/Contributing
> >>>> >> >>>> Thanks!
> >>>> >> >>>>
> >>>> >> >>>> On Apr 16, 2013 12:02 PM, "Jona Christopher Sahnwaldt"
> >>>> >> >>>> <j...@sahnwaldt.de>
> >>>> >> >>>> wrote:
> >>>> >> >>>>>
> >>>> >> >>>>> I quickly put that script together when I ran the abstract
> >>>> >> >>>>> extraction
> >>>> >> >>>>> last year, and I never expected it to have so many users. :-)
> >>>> >> >>>>>
> >>>> >> >>>>> I'm sorry that it's so badly documented and not really
> >>>> >> >>>>> finished.
> >>>> >> >>>>> I'll
> >>>> >> >>>>> improve it in May. Don't have time now. :-(
> >>>> >> >>>>>
> >>>> >> >>>>> JC
> >>>> >> >>>>>
> >>>> >> >>>>> aaaa ok we need to download the MySQL archive before I
> thought
> >>>> >> >>>>> the
> >>>> >> >>>>> script did it for us. Maybe add this precision in the
> >>>> >> >>>>> documentation
> >>>> >> >>>>> ?
> >>>> >> >>>>>
> >>>> >> >>>>> Thanks :-)
> >>>> >> >>>>>
> >>>> >> >>>>> Best.
> >>>> >> >>>>>
> >>>> >> >>>>> Julien.
> >>>> >> >>>>>
> >>>> >> >>>>>
> >>>> >> >>>>> 2013/4/16 Andrea Di Menna <ninn...@gmail.com>
> >>>> >> >>>>>>
> >>>> >> >>>>>> Hi Julien,
> >>>> >> >>>>>>
> >>>> >> >>>>>> reading the mysql.sh script you should first set the env
> >>>> >> >>>>>> variable
> >>>> >> >>>>>> MYSQL_HOME to you MySQL installation folder.
> >>>> >> >>>>>> The script is first accessing that folder and then launching
> >>>> >> >>>>>> some
> >>>> >> >>>>>> MySQL scripts/commands, link mysql_install_db [1]
> >>>> >> >>>>>>
> >>>> >> >>>>>> Cheers
> >>>> >> >>>>>> Andrea
> >>>> >> >>>>>>
> >>>> >> >>>>>> [1]
> >>>> >> >>>>>>
> http://dev.mysql.com/doc/refman/5.0/en/mysql-install-db.html
> >>>> >> >>>>>>
> >>>> >> >>>>>>
> >>>> >> >>>>>> 2013/4/16 Julien Plu <julien....@redaction-developpez.com>
> >>>> >> >>>>>>>
> >>>> >> >>>>>>> Hi,
> >>>> >> >>>>>>>
> >>>> >> >>>>>>> The extraction tool has finished to compile and to download
> >>>> >> >>>>>>> the
> >>>> >> >>>>>>> dumps
> >>>> >> >>>>>>> so now I install MySQL with the
> "dump/src/main/bash/mysql.sh"
> >>>> >> >>>>>>> script, and
> >>>> >> >>>>>>> when I run this script with the "sudo
> >>>> >> >>>>>>> ./src/main/bash/mysql.sh
> >>>> >> >>>>>>> install
> >>>> >> >>>>>>> /etc/mysql/" command I fall on this error :
> >>>> >> >>>>>>>
> >>>> >> >>>>>>> ./src/main/bash/mysql.sh: ligne 51:
> >>>> >> >>>>>>> ./scripts/mysql_install_db: No
> >>>> >> >>>>>>> such file or directory
> >>>> >> >>>>>>>
> >>>> >> >>>>>>> And indeed this script doesn't exist in the repo. I have to
> >>>> >> >>>>>>> download
> >>>> >> >>>>>>> it somewhere ?
> >>>> >> >>>>>>>
> >>>> >> >>>>>>> Best.
> >>>> >> >>>>>>>
> >>>> >> >>>>>>> Julien.
> >>>> >> >>>>>>>
> >>>> >> >>>>>>>
> >>>> >> >>>>>>>
> >>>> >> >>>>>>>
> >>>> >> >>>>>>>
> ------------------------------------------------------------------------------
> >>>> >> >>>>>>> Precog is a next-generation analytics platform capable of
> >>>> >> >>>>>>> advanced
> >>>> >> >>>>>>> analytics on semi-structured data. The platform includes
> APIs
> >>>> >> >>>>>>> for
> >>>> >> >>>>>>> building
> >>>> >> >>>>>>> apps and a phenomenal toolset for data science. Developers
> >>>> >> >>>>>>> can use
> >>>> >> >>>>>>> our toolset for easy data analysis & visualization. Get a
> >>>> >> >>>>>>> free
> >>>> >> >>>>>>> account!
> >>>> >> >>>>>>> http://www2.precog.com/precogplatform/slashdotnewsletter
> >>>> >> >>>>>>> _______________________________________________
> >>>> >> >>>>>>> Dbpedia-discussion mailing list
> >>>> >> >>>>>>> Dbpedia-discussion@lists.sourceforge.net
> >>>> >> >>>>>>>
> >>>> >> >>>>>>>
> https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
> >>>> >> >>>>>>>
> >>>> >> >>>>>>
> >>>> >> >>>>>
> >>>> >> >>>>>
> >>>> >> >>>>>
> >>>> >> >>>>>
> >>>> >> >>>>>
> >>>> >> >>>>>
> ------------------------------------------------------------------------------
> >>>> >> >>>>> Precog is a next-generation analytics platform capable of
> >>>> >> >>>>> advanced
> >>>> >> >>>>> analytics on semi-structured data. The platform includes APIs
> >>>> >> >>>>> for
> >>>> >> >>>>> building
> >>>> >> >>>>> apps and a phenomenal toolset for data science. Developers
> can
> >>>> >> >>>>> use
> >>>> >> >>>>> our toolset for easy data analysis & visualization. Get a
> free
> >>>> >> >>>>> account!
> >>>> >> >>>>> http://www2.precog.com/precogplatform/slashdotnewsletter
> >>>> >> >>>>> _______________________________________________
> >>>> >> >>>>> Dbpedia-discussion mailing list
> >>>> >> >>>>> Dbpedia-discussion@lists.sourceforge.net
> >>>> >> >>>>>
> https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
> >>>> >> >>>>>
> >>>> >> >>>
> >>>> >> >>>
> >>>> >> >>>
> >>>> >> >>>
> >>>> >> >>>
> >>>> >> >>>
> ------------------------------------------------------------------------------
> >>>> >> >>> Precog is a next-generation analytics platform capable of
> >>>> >> >>> advanced
> >>>> >> >>> analytics on semi-structured data. The platform includes APIs
> for
> >>>> >> >>> building
> >>>> >> >>> apps and a phenomenal toolset for data science. Developers can
> >>>> >> >>> use
> >>>> >> >>> our toolset for easy data analysis & visualization. Get a free
> >>>> >> >>> account!
> >>>> >> >>> http://www2.precog.com/precogplatform/slashdotnewsletter
> >>>> >> >>> _______________________________________________
> >>>> >> >>> Dbpedia-discussion mailing list
> >>>> >> >>> Dbpedia-discussion@lists.sourceforge.net
> >>>> >> >>>
> https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
> >>>> >> >>>
> >>>> >> >>
> >>>> >> >>
> >>>> >> >>
> >>>> >> >> --
> >>>> >> >> Kontokostas Dimitris
> >>>> >> >
> >>>> >> >
> >>>> >
> >>>> >
> >>>
> >>>
> >>>
> >>>
> >>>
> ------------------------------------------------------------------------------
> >>> Precog is a next-generation analytics platform capable of advanced
> >>> analytics on semi-structured data. The platform includes APIs for
> >>> building
> >>> apps and a phenomenal toolset for data science. Developers can use
> >>> our toolset for easy data analysis & visualization. Get a free account!
> >>> http://www2.precog.com/precogplatform/slashdotnewsletter
> >>> _______________________________________________
> >>> Dbpedia-discussion mailing list
> >>> Dbpedia-discussion@lists.sourceforge.net
> >>> https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
> >>>
> >
>
------------------------------------------------------------------------------
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
_______________________________________________
Dbpedia-discussion mailing list
Dbpedia-discussion@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
