On 16 April 2013 19:56, Julien Plu <[email protected]> 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 <[email protected]> >> >> 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 <[email protected]> >> 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 <[email protected]> >> >> >> >> 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 >> >> <[email protected]> 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 <[email protected]> >> >>>> >> >>>> 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" >> >>>> <[email protected]> >> >>>> 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 <[email protected]> >> >>>>>> >> >>>>>> 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 <[email protected]> >> >>>>>>> >> >>>>>>> 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 >> >>>>>>> [email protected] >> >>>>>>> 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 >> >>>>> [email protected] >> >>>>> 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 >> >>> [email protected] >> >>> 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 [email protected] https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
