понедельник, 22 января 2018 г.

Mysql copy database

sudo apt-get install mysql-utilities

mysqldbcopy \
    --source=root:your_password@localhost \
    --destination=root:your_password@localhost \
    sitedb1:sitedb2

or

mysqldump db_name | mysql new_db_name

пятница, 19 января 2018 г.

Lubuntu Shift + NumPad work like Windows

Set "Keyboard Layout Handler" (in tray) - "Advanced setxkbmap Options" - value = numpad:microsoft
and right click icon for saving.

or

change this option in file ~/.config/lxpanel/Lubuntu/panels/panel

Plugin {
     type=xkb
     Config {
     ......
         AdvancedOpt="numpad:microsoft"
     }
}

среда, 17 января 2018 г.

Mysql and new location for data with Errcode: 13 - Permission denied


For new instance data dir:

mysqld --initialize

mysqld: Can't create directory '/xxxx/mysql/' (Errcode: 13 - Permission denied)

add to file /etc/apparmor.d/ usr.sbin.mysqld new location

# Allow data dir access
  /var/lib/mysql/ r,
  /var/lib/mysql/** rwk,
 /xxxx/mysql/ r,  /xxxx/mysq/** rwk,
and reload apparmor

service apparmor reload


other way

apt install appamor-utils
aa-disable /usr/sbin/mysqld
Disabling /usr/sbin/mysqld.

mysqld --initialize

You can find password for root in /var/log/mysql/error.log
A temporary password is generated for root@localhost: xxxxxxxx

понедельник, 15 января 2018 г.

Lubuntu 16.04 repeat key functionality doesn't work

Fix for notebook Lenovo Ideapad 700-15ISK

sudo su
echo "blacklist peaq_wmi" >> /etc/modprobe.d/50-blacklist.conf

пятница, 12 января 2018 г.

Ubuntu iso and UEFI usb stick

Get etcher app from https://etcher.io and write Ubuntu iso.