Script in/home/user/mysql tutorial _ backup. sh
Crontab
# Crontab-l
# M h dom mon dow command
28 16 ***/home/user/mysql_backup.sh
The script is as follows:
#! /Bin/sh
# Mysql_backup.sh: backup mysql databases and keep newest 5 days backup.
#
# Last
This article is almost the same as that on my blog website, and the articles on my website will be updated continuously. If you need to check the latest content, go to my website. (I am too tired to update 2 parts)
Modify eaglePHP to form my current
Red Hat Linux
# Add a userUseradd Username# Set PasswordPasswd Username# Deleting a userUserdel UsernameUserdel-r username # delete a user and the user's home directory# Modify the incorrect configuration at startupPress e when you select a startup
Instructions for using ljg email
System: http://download.csdn.net/detail/afgasdg/3681707
I. Environment Configuration
Environment required by the system: Apache james3.0 mail server, Tomcat server, and mysql5.1 Database
II. Specific environment
Http://blog.csdn.net/doudou8486/article/details/6448928
1. Update the system kernel to the latest version.[Root @ linuxfei ~] # Yum-y updateAfter the system is updated, if an error message is prompted during Yum installation, run the following
Use Microsoft ole db provider for ODBC to link MySQLInstall MySQL ODBC driver myodbc1. Create an ODBC data source for MySQL. For example, set database to test and data source name to mydsn.2. Create a linked DatabaseExec sp_addmediaserver @ Server =
Database Link
10. The biggest characteristic of PHP is its powerful ability to operate databases. php provides support for multiple databases.
With PHP, you can easily connect to the database, request data and display it on your web site, or
Now we start to install and configure:
1. The phpMyAdmin package downloaded from the internet is usually released to the htdocs directory, for example, htdocs \ phpMyAdmin.
2. Open the phpMyAdmin directory and check whether the config. sample.
This article is original. Reprinted Please note:
Author: Utensil
Blog: http://blog.csdn.net/utensil/
Email: utensilcandel@gmail.com
In the past two days, the previous blog website based on XML and PHP has been transplanted to MySQL and ror to
Error message:
Error 2002 (hy000): Can't connect to local MySQL server through socket '/var/lib/MySQL. Sock' (2)
1. Check/etc/rc. d/init. d/mysqld status to see if m y s q l has been started.Check whether the permission is correct.2. Check whether
Install OCSNG-server 2.1.2 on CentOS 6.6
1. Install OCSNG-server 2.1.2 on CentOS 6.62. Install the OCS_Agent for linux client on Redhat, CentOS, Debian, and Ubuntu. [use the one-key automated script I wrote: http://990487026.blog.51cto.com/10133282/1
Msyql TPS v1: Calculate the msyqltps within the specified time
Requirement: Calculate the TPS between-during daily business peaks.
Idea: 1. records TPS-related historical values at every morning. obtain TPS-related values at any current time minus
Error: 'Can't connect to local MySQL server through socket '/var/lib/mysql. sock' (2) ', connectmysql. sock[Root @ luozhonghua ~] #/Usr/bin/mysqladmin-u root password 'aaaaa'/Usr/bin/mysqladmin: connect to server at 'localhost' failedError: 'Can't
PhpMyAdmin is mainly used to manage mysql on the web interface. The Installation Method in Fedora is as follows:
1. yum install phpMyAdmin
The path of phpMyAdmin installed using yum is as follows:
Installation
MySQL remote connection and mysql connection
Overview
This article describes how to create a remote connection table through the federated storage engine.
Test environment: mysql 5.6.21
Procedure
Enable federated storage engine
Check whether the
Ambari Hive cannot be properly queried
1. An error occurred today. After connecting to hive, no command can be executed.
$ Beeline-u "jdbc: hive2: // hostname.domain.cn: 10000/default; principal = hive/_ HOST@domain.com ;"Connecting to jdbc: hive2: /
In PHP website development, it supports various database engines, such as Mysql, Mssql, Pgsql, and sqlite, and provides different functions as interfaces for various database systems, it brings a lot of convenience to PHP website developers.
But it
PHPMyadmin configuration file (configuration ),The content of the PHPMyadmin configuration file config. inc. php is as follows. Related comments are added to the configuration. It is very suitable for database managers who are unfamiliar with
Use backup-manager on Linux for system backup, wiibackupmanager
Whether simple or not, we have the opportunity to understand the importance of backup. Considering that the backup method is really versatile, you may want to know how to effectively
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.