Script-/var/lib/mysql every 3 days to a physical backup of the database directory to back up the data to the system/opt/dbbak directory

physical Backup of database directory/var/lib/mysql every 3 days back up the data to the system/opt/dbbak directory#!/bin/bashDay= ' date+%y-%m-%d 'Size= ' Du-sh/var/lib/mysql 'Cd/opt/dbbak 2>/dev/null | | Mkdir/opt/dbbakecho "Date: $DAY"

Bill: navicat MySQL database connected to server via HTTP

First, go to the Navicat official website to download the latest version of Navicat. When the installation is complete, open Navicat as shown in:Then click on the connection in the upper left corner to bring up the new key connection information as

MySQL Error: Unknown table engine ' InnoDB '

Problem:Zabbix server Restart, enter the Zabbix Web Discovery login does not go in and the Web report mysql error, after viewing the day of MySQL, found an error:[Email protected] ~]# tail-f/var/log/mysqld.log140820 16:24:43

MySQL optimized MySQL explain

Let's take a look at the table structure of Arena_match_index, and notice the index structure of the table.CREATE TABLE ' Arena_match_index ' (' Tid ' int (ten) unsigned not NULL DEFAULT ' 0 ',' Mid ' int (ten) unsigned not NULL DEFAULT ' 0 ','

MySQL host 127.0.0.1 and localhost difference summary

1. Mysql-h 127.0.0.1, when using TCP/IP connection, MySQL server considers the connection to be from 127.0.0.1 or "Localhost.localdomain"2. When mysql-h localhost, it is not using TCP/IP connection, but the use of UNIX sockets, at this time, MySQL

Ubuntu under MySQL connection (reprint)

Ubuntu under MySQL default only from locally connected solutionsudo gedit/etc/mysql/my.cnfModify a fieldBind-address = 127.0.0.1-Bind-address=xxx.xxx.xxx.xxx (Your IP)(FROM:HTTP://HI.BAIDU.COM/VINCENT_HCL)First, connect MySQL.Format: mysql-h host

MySQL Create new user method

1. CREATE USERGrammar:CREATE USER 'username ' @ ' host' identified by ' password ';Example: CREATE USER ' dog ' @ ' localhost ' identified by ' 123456 ';CREATE USER ' pig ' @ ' 192.168.1.101_ ' idendified by ' 123456 ';CREATE USER ' pig ' @ '% '

Ways to modify the MySQL default character set

Disclaimer: This article is reproduced from the Internet(1) The simplest method of modification is to modify the character set key values in the MySQL My.ini file,such as Default-character-set = UTF8Character_set_server = UTF8After the modification,

CentOS config mysql allows remote login

MySQL for security, by default users are allowed to log on locally only, but in this case, you still need to use the user for remote connection, so that they can be remotely required to do the following: First, allow the root user to telnet

Actual combat Use Saltstack source installation configuration MySQL

Environment:salt_master:192.168.100.228salt_client1:192.168.100.245Master client version consistent [[email protected]_server base]# Salt--versions-report salt:0.17.5 python:2.6.6 (R2  66:84292, June, 14:18:47) Jinja2:unknown m2crypto:0.20.2 msgpack-

MySQL Trigger Example (two table sync additions and deletions)

The following two examples are from:Http://www.cnblogs.com/nicholas_f/archive/2009/09/22/1572050.htmlThe actual measurement is valid, but the original post delimiter is not correct, so modify it slightly.Where old means tab2 (passive trigger), new

Delete MySQL on Mac Ben

The steps:First need to edit the file in: /etc/hostconfig and remove the lineSince This is a system file I advise your to open it with the Nano in Terminal: Open Terminal sudo nano/etc/hostconfig Enter your password if you ' re not

MySQL skip-name-resolve skip-grant-tables

Skip-name-resolveThis statement is used to bypass DNS domain name resolution, which is faster on LAN connections, but with this command, the host in the MySQL library's user table must be changed from localhost to%, otherwise it cannot connect to

Add a column to MySQL at one point in the table

If you want to add a column to a table that has already been built, you can use the following example:ALTER TABLE t1 add column addr varchar (a) not null;This statement adds a column of addr to the existing table T1, which is the last column in the

Linux environment MySQL cluster configuration

First, Introduction========This document is intended to show you how to install a MySQL cluster that is configured on 2 servers. and MySQL can continue to run when any server is having problems or downtime.Attention!Although this is a MySQL cluster

Convert PDM to MYSQl Databases in powerdesigner

Convert PDM to MYSQl Databases in powerdesigner Use PowerDesigner to design and build a MySQL database1. Create a database creation script using PowerDesigner1. Design CDM (Conceptual Data Model)2. Select Tools> Generate Physical Data Model, select

Have you forgotten mysql history or mysql history?

Have you forgotten mysql history or mysql history? To view mysql statements, we usually use the show processlist command. However, this command makes sense for statements with a long query time, the statement that can be executed at once cannot be

Export and Import mysql Data in linux

Export and Import mysql Data in linux Export all data in the entire database 1. Enter the following in the linux Command Line: Mysqldump-u userName-p dabaseName> fileName. SQL FileName. It is best to add the path name to SQL. Export the data of

Use the mss2sql tool to convert SqlServer to Mysql full records, mss2sqlmysql

Use the mss2sql tool to convert SqlServer to Mysql full records, mss2sqlmysql Today, I want to use ruby on rails to build a small project. I need to use the mysql database. The data in the project already exists, but is saved in SQL Server. I can

Tigase database structure (1), tigase database structure

Tigase database structure (1), tigase database structure There are many tables in the Tigase database. The most important tables are three: tig_users, tig_nodes, and tig_pairs. 1. tig_users Tig_users stores user information, including uid (primary

Total Pages: 3233 1 .... 1014 1015 1016 1017 1018 .... 3233 Go to: GO

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.