2. NEW
  3. 618
  4. starsliao

php

NEW 

yum install https://rpms.remirepo.net/enterprise/remi-release-7.rpm
remi-php71.repo
remi-safe.repo

FG

yum install php-bcmath.x86_64 php-common.x86_64 php-devel.x86_64 php-fpm php php-gd.x86_64 php-mbstring.x86_64 php-pecl-redis php-phpiredis php-pecl-swoole.x86_64 php-pecl-yac.x86_64 php-pecl-yaconf.x86_64 php-pecl-zip.x86_64 php-pgsql.x86_64 php-xmlrpc.x86_64

vi /etc/php.d/40-yaconf.ini
yaconf.directory='/data/www/conf/pro/'

douyu

yum install php-bcmath.x86_64 php-common.x86_64 php-devel.x86_64 php-fpm php php-gd.x86_64 php-mbstring.x86_64 php-pecl-redis php-phpiredis php-pecl-mongodb.x86_64 php-pecl-yac.x86_64 php-pecl-yaconf.x86_64 php-pecl-zip.x86_64 php-pgsql.x86_64 php-xmlrpc.x86_64 php-pecl-swoole4.x86_64

mysql dump

mysqldump -uadmin -padminFG1@3 public -d --lock-all-tables > public.sql
mysqldump -uadmin -padminFG1@3 slot_statistics -d --lock-all-tables > slot_statistics.sql
mysqldump -uadmin -padminFG1@3 statistics -d --lock-all-tables > statistics.sql
mysqldump -uadmin -padminFG1@3 statistics_18 -d --lock-all-tables > statistics_18.sql

mysqldump -uadmin -padminFG1@3 public -t --ignore-table=public.player_chips --ignore-table=public.player_details --ignore-table=public.player --ignore-table=public.t_cash_flow --ignore-table=public.transfer_out_in --ignore-table=public.transfer --ignore-table=public.userinfo --lock-all-tables > public_data.sql

CREATE DATABASE public DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE slot_statistics DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE statistics DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE statistics_18 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

mysql -uroot public <public.sql
mysql -uroot slot_statistics <slot_statistics.sql
mysql -uroot statistics <statistics.sql
mysql -uroot statistics_18 <statistics_18.sql
mysql -uroot public <public_data.sql