Backup and restore mySQL (MariaDB) database
- Read more about Backup and restore mySQL (MariaDB) database
- Log in 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 to post comments
Yuasa YT19BL-BS
WestCo 12V20P
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 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
Using 7zip to archive a directory
- Read more about Using 7zip to archive a directory
- Log in 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 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 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
The Arduino package contains an IDE that can be used to develop and upload code to the micro-controller.
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.
Fixed clamav logging error
- Read more about Fixed clamav logging error
- Log in 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
Installing Sun Java with Fedora/RedHat alternatives
Download java:
http://java.com/en/download/linux_manual.jsp?locale=en
Install with rpm:
rpm -Uvh jre-7u67-linux-x64.rpm
Set alternatives:
update-alternatives --install "/usr/bin/java" "java" "/usr/java/latest/bin/java" 1 \
--slave "/usr/bin/keytool" "keytool" "/usr/java/latest/jre/bin/keytool" \
--slave "/usr/bin/unpack200" "unpack200" "/usr/java/latest/bin/unpack200" \
--slave "/usr/bin/pack200" "pack200" "/usr/java/latest/bin/pack200" \
--slave "/usr/bin/rmid" "rmid" "/usr/java/latest/bin/rmid" \
Fastest DNS
- Read more about Fastest DNS
- Log in to post comments
Ran some tests and found these DNS entries for my router are faster:
However, they are managed by TimeWarner, and are not very reliable.
So, maybe I go back to OpenDNS
or
Google DNS