Blogs

getting started mysql db backup script

Getting started with mysql backup script....

[root@fedora ~]# for i in `mysql -e 'show databases'|awk '{print $1}'`; do echo $i; done

Database
information_schema
fundamentals
mysql
performance_schema
test
[root@fedora ~]# for i in `mysql -e 'show databases'|awk '{print $1}'`; do mysqldump --add-drop-table $i > $i.sql && echo $i >> dblist; done

mysqldump: Got error: 1049: Unknown database 'Database' when selecting the database
mysqldump: Got error: 1044: Access denied for user 'root'@'localhost' to database 'information_schema' when using LOCK TABLES
mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES

[root@fedora ~]# ls *.sql
Database.sql  fundamentals.sql  information_schema.sql  mysql.sql  performance_schema.sql  test.sql

 

Help on mysql

 

[root@fedora ~]# mysql --help


-e, --execute=name  Execute command and quit. (Disables --force and history file.)

systemctl enable mysqld service

Example:

systemctl enable mysqld service

 

[root@fedora ~]# systemctl enable mysqld.service
ln -s '/usr/lib/systemd/system/mysqld.service' '/etc/systemd/system/multi-user.target.wants/mysqld.service'

[root@fedora ~]# cat /etc/systemd/system/multi-user.target.wants/mysqld.service

# It's not recommended to modify this file in-place, because it will be
# overwritten during package upgrades.  If you want to customize, the
# best way is to create a file "/etc/systemd/system/mysqld.service",
# containing
#    .include /lib/systemd/system/mysqld.service
#    ...make your changes here...
# For more info about custom unit files, see
# http://fedoraproject.org/wiki/Systemd#How_do_I_customize_a_unit_file.2F_...

# For example, if you want to increase mysql's open-files-limit to 10000,
# you need to increase systemd's LimitNOFILE setting, so create a file named
# "/etc/systemd/system/mysqld.service" containing:
#    .include /lib/systemd/system/mysqld.service
#    [Service]
#    LimitNOFILE=10000

# Note: in F-17 and beyond, /usr/lib/... is recommended in the .include line
# though /lib/... will still work.

[Unit]
Description=MySQL database server
After=syslog.target
After=network.target

[Service]
Type=simple
User=mysql
Group=mysql

ExecStartPre=/usr/libexec/mysqld-prepare-db-dir %n
# Note: we set --basedir to prevent probes that might trigger SELinux alarms,
# per bug #547485
ExecStart=/usr/bin/mysqld_safe --basedir=/usr
ExecStartPost=/usr/libexec/mysqld-wait-ready $MAINPID

# Give a reasonable amount of time for the server to start up/shut down
TimeoutSec=300

# Place temp files in a secure directory, not /tmp
PrivateTmp=true

[Install]
WantedBy=multi-user.target

====

[root@fedora ~]# systemctl start mysqld.service

[root@fedora ~]# systemctl status mysqld.service

mysqld.service - MySQL database server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled)
Active: active (running) since Sun, 03 Feb 2013 12:43:05 +0530; 7s ago
Process: 4147 ExecStartPost=/usr/libexec/mysqld-wait-ready $MAINPID (code=exited, status=0/SUCCESS)
Process: 4124 ExecStartPre=/usr/libexec/mysqld-prepare-db-dir %n (code=exited, status=0/SUCCESS)
Main PID: 4146 (mysqld_safe)
CGroup: name=systemd:/system/mysqld.service
? 4146 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
? 4290 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-d...

Feb 03 12:43:00 fedora.example.com mysqld_safe[4146]: 130203 12:43:00 mysqld_safe Logging to '/...'.
Feb 03 12:43:01 fedora.example.com mysqld_safe[4146]: 130203 12:43:01 mysqld_safe Starting mysq...ql

[root@fedora ~]# pgrep mysql
4146
4290
[root@fedora ~]#

Cpanel Mysql Upgrade problem libmysqlclient not found

Cpanel Mysql Upgrade problem libmysqlclient not found

php: /usr/lib64/libmysqlclient.so.15: version `libmysqlclient_15' not found

You may then have to re-run EasyApache to recompile PHP, which will automatically compile with the new libraries.

 

The /etc/host.conf file

The /etc/host.conf file

Linux uses a resolver library to obtain the IP address corresponding to a host name. The /etc/host.conf file specifies how names are resolved. The entries in the etc/host.conf file tell the resolver library what services to use, and in what order, to resolve names. Edit the host.conf file vi /etc/host.conf and add the following lines:

           # Lookup names via DNS first then fall back to /etc/hosts.
           order bind,hosts
           # We have machines with multiple IP addresses.
           multi on
           # Check for IP address spoofing.
           nospoof on
           

The order option indicates the order of services. The sample entry specifies that the resolver library should first consult the name server to resolve a name and then check the /etc/hosts file. It is recommended to set the resolver library to first check the name server, bind and then the hosts file (hosts) for better performance and security on all your servers. Of course you must have the DNS/BIND software installed or this configuration will not work.

The multi option determines whether a host in the /etc/hosts file can have multiple IP addresses i.e.multiple interface ethN. Hosts that have more than one IP address are said to be multiomed, because the presence of multiple IP addresses implies that host has several network interfaces. As an example, a Gateway Server will always have multiple IP address and must have this option set to ON.

The nospoof option indicates to take care of not permitting spoofing on this machine. IP-Spoofing is a security exploit that works by tricking computers in a trust relationship that you are someone that you really aren't. In this type of attack, a machine is set up to look like a legitimate server and then issue connections and other types of network activities to legitimate end systems, other servers or large data repository systems. This option must be set ON for all types of servers.

Razor-qt 0.5.0 is out!

Razor-qt 0.5.0 is out!

The free and open source lightweight desktop environment

There have been several improvements and added features for 0.5.0, as noted in the Change Log, but the most noticable are:

  • New Appearance GUI for configuring themes
  • Several new plugins for added functionality
  • Many bug fixes resulting in better performance
  • New Notification daemon

Razor-qt is an advanced, easy-to-use, and fast desktop environment based on Qt technologies. It has been tailored for users who value simplicity, speed, and an intuitive interface. Unlike most desktop environments, Razor-qt also works fine with weak machines.

While still a new project, Razor-qt already contains the key DE components:

  • Panel
  • Desktop
  • Application launcher
  • Settings center
  • Sessions

Fedora/Redhat/CentOS users could use up-to-date packages from QtDesktop repository.

 

Reference:  - http://razor-qt.org/

 

top command Batch mode operation

top command Batch mode operation

 

-b : Batch mode operation - Starts  top  in  'Batch mode', which could be useful for sending output from top to other programs or to a file.  In this mode, top will not accept input and runs until the iterations limit you've set with the '-n' command-line option or until killed.

-c : Command line/Program name toggle - Starts top with the last remembered 'c' state reversed.  Thus, if top was displaying command lines, now that  field  will  show program names, and visa versa.  See the 'c' interactive command for additional information.

[root@fedora ~]# top -b -n1 -c | head -n15
top - 09:02:32 up 44 min,  1 user,  load average: 0.31, 0.47, 0.35
Tasks: 119 total,   1 running, 118 sleeping,   0 stopped,   0 zombie
Cpu(s): 24.4%us,  9.2%sy,  0.3%ni, 63.9%id,  2.1%wa,  0.0%hi,  0.1%si,  0.0%st
Mem:    767356k total,   689300k used,    78056k free,    18936k buffers
Swap:  1540092k total,    14800k used,  1525292k free,   259524k cached

PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND                                                                          
2493 root      20   0 40492  11m 6436 S 25.2  1.6   1:29.28 /usr/bin/X -background none :0 vt01 -nolisten tcp                                
3785 fedora    20   0  523m 209m  33m S 23.5 27.9  11:02.55 /home/fedora/Desktop/firefox-Linux/firefox                                       
4013 root      20   0  2920  980  760 R  3.4  0.1   0:00.05 top -b -n1 -c                                                                    
1 root      20   0 16908 2740 1912 S  0.0  0.4   0:05.90 /usr/lib/systemd/systemd                                                         
2 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [kthreadd]                                                                       
3 root      20   0     0    0    0 S  0.0  0.0   0:01.10 [ksoftirqd/0]                                                                    
6 root      RT   0     0    0    0 S  0.0  0.0   0:00.00 [migration/0]                                                                    
7 root      RT   0     0    0    0 S  0.0  0.0   0:00.03 [watchdog/0]

cPanel Announces the Launch of 11.34

10/15/12
For Immediate Release

Houston, TX-
cPanel Inc. announced today the release of version 11.34 of cPanel & WHM software to the CURRENT tier with many improvements and upgrades.

 

-A brand new User Interface for WHM, which brings a slick new look and easier functionality, as demonstrated at the recent cPanel Conference.
-Web Disk support has been updated for Windows Vista, 7 & 8, and Mountain Lion. In addition to the Web Disk support update, we will soon be releasing Android and iOS clients.
-Email client auto configuration utilities have been updated to support the latest mail clients, as well as added support for Mountain Lion.     
-Email Archiving makes its appearance in 11.34, so email users now have the option to more efficiently track, store, and access email with our vastly improved email tracking, and message retrieval, to the Mail Delivery Reports functionality we recently delivered.
-In addition, we overhauled the service monitoring system to provide better notifications, and improved the robustness of the automatic repair feature.
-New Hooks Management interface built into WHM.
-Feature Showcase page of WHM will alert you at login to any recent changes made by upgrading cPanel & WHM.

Upon updating or installing cPanel & WHM version 11.34, you will no longer be able to downgrade to a previous version.

For details regarding version 11.34 User Guide, Release Notes, Change Log and FAQ’s, please visit http://docs.cpanel.net.

Please pre-register for our upcoming webinar on version 11.34 at http://go.cpanel.net/1134webinar.

To update cPanel & WHM manually:
Log into WHM as the root user.
Click on the WHM 11.32.X (build X) link on the top right corner of the screen.
Click the button labeled Click to Upgrade.

Linux Foundation Offers Solution for UEFI Secure Boot

Linux Foundation Offers Solution for UEFI Secure Boot

Ever since news broke last year that Microsoft would require Windows 8 machines to have UEFI secure boot enabled, there were concerns that it would be used to block the installation of other operating systems, such as Linux distributions.

"The Linux Foundation has announced plans to provide a general purpose solution suitable for use by Linux and other non-Microsoft operating systems. The group has produced a minimal bootloader that won't boot any operating system directly. Instead, it will transfer control to any other bootloader — signed or unsigned — so that can boot an operating system." The announcement adds, "The pre-bootloader will employ a 'present user'; test to ensure that it cannot be used as a vector for any type of UEFI malware to target secure systems. This pre-bootloader can be used either to boot a CD/DVD installer or LiveCD distribution or even boot an installed operating system in secure mode for any distribution that chooses to use it."

Flash Friendly File System from Samsung

Samsung's F2FS filesystem

Tools for Flash-Friendly File System (F2FS)

A flash-friendly filesystem from Samsung. "F2FS is a new file system carefully designed for the NAND flash memory-based storage devices.

This is a new patch set for the f2fs file system.

NAND flash memory-based storage devices, such as SSD, eMMC, and SD cards, have been widely being used for ranging from mobile to server systems. Since they are known to have different characteristics from the conventional rotational disks, a file system, an upper layer to the storage device, should adapt to the changes from the sketch.

F2FS is a new file system carefully designed for the NAND flash memory-based storage devices. We chose a log structure file system approach, but we tried to adapt it to the new form of storage. Also we remedy some known issues of the very old log structured file system, such as snowball effect of wandering tree and high cleaning overhead.

Reference: http://sourceforge.net/projects/f2fs-tools/

Leap Seconds in Red Hat Enterprise Linux

Leap Seconds in Red Hat Enterprise Linux

Systems running NTP

Systems running any version of Red Hat Enterprise Linux should automatically account for leap second corrections if they are using the NTP (Network Time Protocol) daemon to synchronize their local timekeeping with an NTP server. During the last day before a leap second correction, NTP servers should notify their clients that a leap second will occur, and at 23:59:59 UTC, the Linux kernel should add or remove an extra second by making the 60th second twice as long or removing it entirely. Thus, Red Hat Enterprise Linux systems running an NTP client during the last leap second correction should have counted time as follows:

2008-12-31 23:59:59 UTC
2008-12-31 23:59:59 UTC
2009-01-01 00:00:00 UTC

When the leap second occurs, the kernel prints a message to the system log.  There is a chance that the printing of this message can cause the kernel to crash in Red Hat Enterprise Linux 4 and 5.  To avoid this situation, please update to the latest version of the kernel available:

 

Red Hat Enterprise Linux (RHEL) Version Minimum Kernel Version Minimum RHEL Update Red Hat Errata
RHEL 4 kernel-2.6.9-89.EL 4.8 RHSA-2009:1024-1
RHEL 5 kernel-2.6.18-164.el5 5.4 RHSA-2009:1243-3
RHEL 6

RHEL 6 kernel is not affected by this problem

 

 

More at - https://access.redhat.com/knowledge/articles/15145

Syndicate content

Syndicate

Syndicate content