#maria Log v0.1

logs Catalogue

This page loads from the db, refresh as and when. It displays 24 hrs
For older data http://marialog.archivist.info/previous.php, logs go back to 2009-01-18
Some user stats
Table logs
date_time
user
message
2017-07-27 10:26:07
woy
g'day
2017-07-27 10:36:55
hargut
Hello.
2017-07-27 10:38:02
hargut
I'm quite new to mariadb, and I'm wondering what the point with the documentation is. Is it on all distributions that there is hardly any documentation shipped with mariadb?
2017-07-27 10:41:38
hargut
hmm.. looks like most of that is incorporated in the --help --verbose of mysqld
2017-07-27 11:00:01
serg
hargut: it's online only, https://mariadb.com/kb/en/
2017-07-27 11:01:16
hargut
serg, is there any specific reason for beeing online only. A mariadb-doc package could be helpful as well. At least I'm used to checking local docs first.
2017-07-27 11:03:15
serg
KB is a wiki, and as of know, export of KB into some offline format is not implemented yet :(
2017-07-27 11:04:12
woy
Anyone familiar with xtrabackup around?
2017-07-27 11:04:54
woy
I tried a partial backup/restore (of one table) to an internal staging galera cluster (which is not in active use), which worked fine. However I guess the cluster is now inconsistent about this data
2017-07-27 11:04:55
hargut
serg, thanks for the info :)
2017-07-27 11:05:35
woy
do I need to full-SST all slaves now again?
2017-07-27 13:20:55
houst0n
Hi guys, my galera cluster is binding to 0.0.0.0 for :4567 even when I specify the correct address as wsrep_node_address in my.cnf -- any suggestions where I can look? all the wsrep*address vars I've found in the docs appear to be correctly set
2017-07-27 15:03:40
pprkut
serg: poking again about my pull requests :)
2017-07-27 16:11:36
DrSlony
Hello, in a statement like "INSERT INTO tab1 (row1, row2, row3) VALUES (val1, val2, val3)" how do I replace val1 with a "SELECT valx FROM tab2"?
2017-07-27 16:15:15
Naktibalda
you have to replace VALUES with SELECT
2017-07-27 16:15:20
Naktibalda
!m DrSlony insert select
2017-07-27 16:15:41
Naktibalda
it would work in #mysql
2017-07-27 16:20:16
DrSlony
thank you Naktibalda, trying that now
2017-07-27 16:26:10
DrSlony
Naktibalda I don't understand how to mix SELECT with other values which are constant. val1 should be valx from tab2, but val2 and val3 I will provide in the query
2017-07-27 16:27:07
DrSlony
all examples in the docs assume I'm selecting all values from some other table, not just one of the values
2017-07-27 16:29:32
Naktibalda
you can select constant values
2017-07-27 16:29:45
Naktibalda
SELECT column, 'text', 5, NULL
2017-07-27 16:39:26
DrSlony
Naktibalda this https://paste2.org/Bxf2wAnH
2017-07-27 16:45:49
Naktibalda
DrSlony: https://dev.mysql.com/doc/refman/5.6/en/insert-select.html
2017-07-27 16:47:09
DrSlony
I figured it out, had to move FROM `tab1` to the end of the statement: INSERT INTO `tab2` (`id`, `col3`, `col4`, `col5`) SELECT `id` , 1, 'Foo', 'Bar' FROM `tab1`;
2017-07-27 17:47:02
xaa
hi, on debian9 using mariadb10 it is unclear for me if still have to add rules in apparamor.d/user.sbin.mysqld if I want move /var/lib/mysql to /home/mysql ?