MySQL Learning Note 12: Data backup and RecoveryData backup1. Physical Backup and logical backupPhysical backupPhysical backup is to copy the database data files, configuration files, log files and so on to other paths, this backup speed is
Configure and manage MYSQL in ubuntu
BitsCN.com
Configure and manage MYSQL in ubuntu
1. install MySQL
1. online installation:
Command: sudo apt-get install mysql-server
During the installation process, you will be prompted to set a password for
The basic purpose of a good backup is to be able to recover from some errors:
Man-made mistakes
Disk array or hard drive failure
File system crashes
Data center is corrupted and so on.
So, I've listed some open source
Introduction
[Describe the content and purpose of this deployment.]
This document describes how to deploy a MySQL cluster on the Ubuntu Server.Preparations
Before proceeding with this document, complete the following preliminary
Reprint: http://linux.cn/article-4623-weixin.html#rd?sukey= Cbbc36a2500a2e6cb7678c4d38b691a9fa7403b259f898ef85fa4620177de89e521da2071ebd494c71482c97449337f9The basic purpose of a good backup is to be able to recover from some errors:
1. MySQL installation A) MySQL installation: sudoapt-getinstallmysql-servermysql-clientB) start and stop the MySQL service: After MySQL is installed, MySQL is started; if you need to manually start or stop the service, perform the following
First, install the JDK1, first to the official web download jdk-7u79-linux-x64.tar.gz.2, copy the jdk-7u79-linux-x64.tar.gz to the/usr/lib/jdk/directory below, if there is no JDK folder, create the folder, command:1 cd/usr/lib2My JDK is a U-disk
1. Download the MySQL Installation FileThe following two files are required to install MYSQL:MySQL-server-4.0.23-0.i386.rpmMySQL-client-4.0.23-0.i386.rpmTo: http://www.mysql.com/downloads/mysql-4.0.html, open this webpage and pull down the webpage
Here's a list of some software backup tools that are open source on Linux and Unix-like. What do you consider when choosing a backup tool for an enterprise? Make sure that the software you are deploying has the following characteristics Open source
The following article describes how to install and configure a MySQL database in Ubuntu and how to configure the actual operation procedures and precautions of the MySQL database and how to correctly manage the msyql database, the following is the
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.