Re: [lpi-examdev] Suggestion for 105.3 (Exam 101) mysqldump

2015-02-11 Thread Toru Nakatani
This would be nice for you ! http://www.oss-db.jp/outline/eng_index.shtml On 2015/02/10 23:59, G. Matthew Rice wrote: On Tue, Feb 10, 2015 at 9:58 AM, Harald Maaßen har...@nwa-net.de wrote: There are only funny looking characters and pictures on that page. ;-) This doesn't get all of

Re: [lpi-examdev] Suggestion for 105.3 (Exam 101) mysqldump

2015-02-10 Thread G. Matthew Rice
On Tue, Feb 10, 2015 at 8:57 AM, Harald Maaßen har...@nwa-net.de wrote: Probably basic database management (dump/backup/restore) can be a junior sysadmin task, but at least up to now is not covered in LPI 1. When it will we will have to look at database engine popularity. We have much time

Re: [lpi-examdev] Suggestion for 105.3 (Exam 101) mysqldump

2015-02-10 Thread G. Matthew Rice
On Tue, Feb 10, 2015 at 9:58 AM, Harald Maaßen har...@nwa-net.de wrote: There are only funny looking characters and pictures on that page. ;-) This doesn't get all of those thingies but it helps:

Re: [lpi-examdev] Suggestion for 105.3 (Exam 101) mysqldump

2015-02-10 Thread Harald Maaßen
Am 10.02.2015 um 15:32 schrieb G. Matthew Rice: Or put it in v4.5 of LPIC-2 :) This is a really good idea! mysqldump would fit well under 206.2 Backup operations. :-) Or my favourite option, punt on the whole issue and create DBA certification exams. This is what LPI-Japan did:

Re: [lpi-examdev] Suggestion for 105.3 (Exam 101) mysqldump

2015-02-10 Thread Simone Piccardi
On 10/02/2015 14:57, Harald Maaßen wrote: That's right! Topic 105.3 is named SQL data management. That does not include backup or restoring of data. But no law stops us from changing the name of this topic. It's also possible to increase the weight to 3, so we can put an additional question on

Re: [lpi-examdev] Suggestion for 105.3 (Exam 101) mysqldump

2015-02-10 Thread Marc Baudoin
Harald Maaßen har...@nwa-net.de écrit : while working on topic 105.3 sometimes students ask me, how to backup a mysql database. I think we should add mysqldump to topic 105.3 because IMHO everybody should be able to backup a database. The way it is now, objective 105.3 is

Re: [lpi-examdev] Suggestion for 105.3 (Exam 101) mysqldump

2015-02-10 Thread Anselm Lingnau
Harald Maaßen har...@nwa-net.de wrote: I think we should add mysqldump to topic 105.3 because IMHO everybody should be able to backup a database. Exactly where does topic 105.3 talk about MySQL in the first place? If everybody should be able to backup a MySQL database, shouldn't everybody be

Re: [lpi-examdev] Suggestion for 105.3 (Exam 101) mysqldump

2015-02-10 Thread Anselm Lingnau
Marc Baudoin mbaud...@linagora.com wrote: Anyway you're free to add extra topics to your teachings, such as mysqldump. In my teachings, I use SQLite, because it's much easier to set up than a full-featured RDBMS and I explain students how to use it, even if it's not in the objectives.

Re: [lpi-examdev] Suggestion for 105.3 (Exam 101) mysqldump

2015-02-10 Thread Harald Maaßen
Am 10.02.2015 um 10:19 schrieb Anselm Lingnau: Exactly where does topic 105.3 talk about MySQL in the first place? This is a good question. It doesn't. But I see it on a hight position in this logarithmic(!) ranking. The ranking shows the importance of mysql:

Re: [lpi-examdev] Suggestion for 105.3 (Exam 101) mysqldump

2015-02-10 Thread Harald Maaßen
Am 10.02.2015 um 12:28 schrieb Simone Piccardi As I understood 105.3 is not about database server management, but about using SQL to manage basic operation on the data stored in a database. That's right! Topic 105.3 is named SQL data management. That does not include backup or restoring of

Re: [lpi-examdev] Suggestion for 105.3 (Exam 101) mysqldump

2015-02-10 Thread Harald Maaßen
Am 10.02.2015 um 15:59 schrieb G. Matthew Rice: On Tue, Feb 10, 2015 at 9:58 AM, Harald Maaßen har...@nwa-net.de wrote: There are only funny looking characters and pictures on that page. ;-) This doesn't get all of those thingies but it helps:

Re: [lpi-examdev] Suggestion for 105.3 (Exam 101) mysqldump

2015-02-10 Thread Harald Maaßen
Am 10.02.2015 um 16:01 schrieb Simone Piccardi: I'm totally against changing the topic or raising it weight, in my opinion 2 question on SQL are already too much, I'd prefer 0, like it was. LPI should be a Linux Sysadmin Certification, this is a generic argument, it tell almost nothing about

Re: [lpi-examdev] Suggestion for 105.3 (Exam 101) mysqldump

2015-02-10 Thread Alessandro Selli
On 10/02/2015 at 16:01, Simone Piccardi wrote: [...] I'm totally against changing the topic or raising it weight, in my opinion 2 question on SQL are already too much, I'd prefer 0, like it was. LPI should be a Linux Sysadmin Certification, this is a generic argument, it tell almost

Re: [lpi-examdev] Suggestion for 105.3 (Exam 101) mysqldump

2015-02-10 Thread Ingo Wichmann
Am 10.02.2015 um 16:01 schrieb Simone Piccardi: I'm totally against changing the topic or raising it weight, in my opinion 2 question on SQL are already too much, I'd prefer 0, like it was. LPI should be a Linux Sysadmin Certification, this is a generic argument, it tell almost nothing