Backup and restore mySQL (MariaDB) database

Read more about Backup and restore mySQL (MariaDB) database
Log in or register to post comments

Backup:
/usr/bin/mysqldump --user=dbuser --password=dbpass --host=localhost --add-drop-table dbname > backups/mydbdump.sql

Restore:
(if the db exist)
# mysql -u root -p[root_password] [database_name] < dumpfilename.sql

mysql -u root -ps3cre3t

mysql> create database dbname;
Query OK, 1 row affected (0.02 sec)

# mysql -u root -ps3cre3t db < /tmp/mydbdump.sql

Motorcycle battery (R1100RS)

Read more about Motorcycle battery (R1100RS)
Log in or register to post comments

Yuasa YT19BL-BS

Length (in) 7.438 in.

Width (in) 3.250 in.

Height (in) 6.875 in.
WestCo 12V20P

51814, 51913 BMW
SEALED VRLA, AGM, 12V 20AH, 275 CCA, NON-HAZARDOUS NON-SPILLABLE BATTERIES
$126.95
SEALED VRLA, AGM, 12V 20AH, 275 CCA, NON-HAZARDOUS NON-SPILLABLE BATTERIES

WPS 51913 49-1208

Meet Lima

Read more about Meet Lima
Log in or register to post comments

It appears the 'beacon' is their service:
strings on beacon got a lot... what makes me feel this is their 'stuff':
could not read eth0 IPv4...
beacon.api.meetlima.com
/home/denis/lima/git/lima-wanserr-firmware/openwrt/staging

A quick look it appears that

	pin	signal
9	TX
8	RX
7	gnd

This is the unpopulated set of through-hole pads on the daughter card near the RJ45 end of the card. With jtagulator connected

Update mail server filtering with sieve

Read more about Update mail server filtering with sieve
Log in or register to post comments

Get the filter rules

Steps to update the sieve filter rules.

Using 7zip to archive a directory

Read more about Using 7zip to archive a directory
Log in or register to post comments

Here is the 7zip command I use to create a series of 7z files to archive a directory tree. To archive /home/user/foo into 650MB files named foo.7z* in /var/tmp:
7za a -t7z -v650m /var/tmp/foo.7z /home/user/foo -mx5 -mmt
That's all!

Changing the wallpaper on the login screen

Read more about Changing the wallpaper on the login screen
Log in or register to post comments

Run these commands to change the GDM login screen's wallpaper.
xhost +local:gdm sudo -u gdm dbus-launch gnome-appearance-properties xhost -local:gdm

Renew expired cyrus IMAPd on April 1st

Read more about Renew expired cyrus IMAPd on April 1st
Log in or register to post comments

This is the command I used (as root) to renew my imap server certicates:
/etc/pki/tls/certs/renew-dummy-cert /etc/pki/cyrus-imapd/cyrus-imapd.pem
To check the date:
openssl x509 -enddate -in cyrus-imapd.pem

Using the Linux alternatives command to manage multiple Arduino IDE versions

Read more about Using the Linux alternatives command to manage multiple Arduino IDE versions
Log in or register to post comments

The Arduino package contains an IDE that can be used to develop and upload code to the micro-controller.

Install from the repositories:

sudo yum -y install arduino

Run the Arduino IDE and set your preferences, etc. and test that it works. Your user may need to be added to some groups (dialout and lock in Fedora 20) to have permissions to write to the serial interface on your computer.

Optionally, install the alternatives graphical user interface. You can use this interface to switch between your options rather than using the command.

Firewall rules for HDHomeRun on Fedora 20

Read more about Firewall rules for HDHomeRun on Fedora 20
Log in or register to post comments

$ sudo firewall-cmd --direct --add-rule ipv4 filter INPUT 0 -m state --state NEW -m udp -p udp --sport 5002 -j ACCEPT
success
$ sudo firewall-cmd --direct --add-rule ipv4 filter INPUT 0 -m state --state NEW -m udp -p udp --sport 5004 -j ACCEPT
success
$ sudo firewall-cmd --direct --add-rule ipv4 filter INPUT 0 -m state --state NEW -m udp -p udp --sport 65001 -j ACCEPT
success
$ sudo firewall-cmd --reload

Fixed clamav logging error

Read more about Fixed clamav logging error
Log in or register to post comments

service clamd start
Starting Clam AntiVirus Daemon: ERROR: Can't open /var/log/clamav/clamav.log in append mode (check permissions!).
ERROR: Can't initialize the internal logger
[FAILED]

# grep clam /etc/selinux/targeted/contexts/files/file_contexts

/var/log/clamav.* system_u:object_r:antivirus_log_t:s0

# semanage fcontext -a -t antivirus_log_t "/var/log/clamav(/.*)?"
# restorecon -R /var/log/clamav
# chown clam:clam /var/log/clamav *log

Subscribe to