MySQL、MariaDB 資料庫匯入與匯出

匯出資料庫

mysqldump -u username -p database_name > data-dump.sql
  • username 資料庫的使用者名稱
  • database_name 要匯出的資料庫名稱
  • data-dump.sql 要匯出的sql檔案名稱

匯入資料庫

mysql -h hostname -u username -ppassword --default-character-set=utf8 database_name < data-import.sql
  • hostname 伺服器名稱或IP位址
  • username 資料庫的使用者名稱
  • password 資料庫的使用者密碼(注意,密碼和-p之間沒有空格)
  • database_name 要匯入的資料庫名稱
  • data-import.sql 要匯入的sql檔案名稱

LAMP on CentOS 7

Apache

  • Step 1: Install Apache
    yum clean all
    yum -y update
    yum -y install httpd
  • Step 2: Allow Apache Through the Firewall
    firewall-cmd --zone=public --add-port=80/tcp --permanent
    firewall-cmd --zone=public --add-port=443/tcp --permanent
    firewall-cmd --reload
  •  Step 3: Configure Apache to Start on Boot
    systemctl start httpd
    systemctl enable httpd

PHP 7

  • CentOS/RHEL 7.x:
    rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
    rpm -Uvh https://mirror.webtatic.com/yum/el7/webtatic-release.rpm
  • Install php 7
    yum -y install php70w php70w-opcache

MySQL / MariaDB

  • Install MySQL / MariaDB
    yum -y install mariadb-server mariadb
    systemctl start mariadb
    systemctl enable mariadb

phpMyAdmin

  • Step 1: Add the EPEL Repository
    rpm -iUvh http://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
  • Step 2: Install phpMyAdmin
    yum -y update
    yum -y install phpmyadmin
  • Step 3: Basic Configuration for phpMyAdmin
    vi /etc/httpd/conf.d/phpMyAdmin.conf
    systemctl restart httpd

SELinux

  • Disabled SELINUX
  • vi /etc/sysconfig/selinux
    set SELINUX=disabled

SQL Server 開放外部連結設定

  • web.config 連線設定確認是否輸入正確
  • SQL伺服器驗證開啟 SQL Server & Windows 驗證模式
  • SQL Server組態管理員開啟TCP/IP通訊協定
  • 防火牆進階設定允許輸入TCP 1433 port