mysql學習之旅-資料庫自動備份-測試環境搭建

標籤：

#終於知道什麼叫不會走先會跑了，剛開始接觸第一個case就是資料庫自動備份，我可是都沒安裝過啊？！   發完牢騷開始幹活

首先，因為業務已經上線，不能隨便動，先搭建測試環境吧

規劃一下

版本：mysql-5.7.14-winx64.zip  從官網下載

系統：windows 7   64bit

解壓縮到本地目錄 D:\app\mysql57    #注意，非系統硬碟，非中文

將my-default.ini 複製一份重新命名為my.ini  添加如下內容，先保證能開啟服務

# For advice on how to change settings please see# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html# *** DO NOT EDIT THIS FILE. It‘s a template which will be copied to the# *** default location during install, and will be replaced if you# *** upgrade to a newer version of MySQL.[mysqld]# Remove leading # and set to the amount of RAM for the most important data# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. innodb_buffer_pool_size = 128M# Remove leading # to turn on a very important data integrity option: logging# changes to the binary log between backups.# log_bin# These are commonly set, remove the # and set as required.# basedir = .....# datadir = .....# port = .....# server_id = ..... basedir="D:\app\mysql57" datadir="D:\app\mysql57\data"port=3306max_connections=200character-set-server=utf8default-storage-engine=INNODB# Remove leading # to set options mainly useful for reporting servers.# The server defaults are faster for transactions and fast SELECTs.# Adjust sizes as needed, experiment to find the optimal values.# join_buffer_size = 128M# sort_buffer_size = 2M# read_rnd_buffer_size = 2M sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 

View Code

修改環境變數path，增加bin目錄


在命令列中cd到bin， 輸入mysqld -install MySQL --defaults-file="D:\app\mysql57\my.ini" 添加服務


在命令列中輸入初始化命令 .\mysqld.exe --initialize  會產生data目錄，並且產生初始的root密碼 ，否則net start mysql 會無法開啟服務 #新版本特殊要求


之後服務可以開啟，從尾碼為err的檔案中取得密碼


複製預設密碼，使用預設密碼登入mysql


必須使用命令先修改密碼，否則啥也不讓幹


mysql> alter user ‘root‘@‘localhost‘ identified by ‘redhat‘;
Query OK, 0 rows affected (0.00 sec)
密碼修改成功，可以查詢資料庫了


安裝完成

 ---------

在此要感謝liongis 、卒子和另一位其他部落格的朋友，謝謝你們分享的經驗~

mysql學習之旅-資料庫自動備份-測試環境搭建