CREATE TABLE CREATE TABLE `fact_retention` ( `stats_date` date NOT NULL, `date` date NOT NULL, `period` int NOT NULL, `age` int NOT NULL, `new_users` int DEFAULT NULL, `retained_users` int DEFAULT NULL, `retention` float DEFAULT NULL, PRIMARY KEY (`stats_date`,`date`,`period`,`age`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 수집 CREATE PROCEDURE `db_canmore_statistics`.`us..

DROP DATABASE IF EXISTS db_test; CREATE DATABASE db_test; USE db_test; DROP PROCEDURE IF EXISTS usp_dummy_create; DELIMITER $$ CREATE PROCEDURE usp_dummy_create(IN table_cnt INT, IN rows_cnt INT) BEGIN DECLARE i INT; DECLARE j INT; SET i = 1; SET j = 1; WHILE i

Verify the existing MySQL installtion:From the MySQL prompt, do:You should see the current data directory:Exit the MySQL mode: exit /var/lib/mysql/ select @@datadir; mysql -u root -p Stop MySQL: sudo systemctl stop mysql Verify that MySQL is stopped: sudo systemctl status mysql Copy the data to the new location:(or whatever volume you've created to store the data) sudo rsync -av /var/lib/mysql /..

update.sh DATABASE=your-data-base DB_USER=your-user-id PASSWORD=your-password wget files-cdn.liferay.com/mirrors/geolite.maxmind.com/download/geoip/database/GeoIPCountryCSV.zip unzip -j GeoIPCountryCSV.zip mv GeoIPCountryWhois.csv geoip_countries.csv mysql -u$DB_USER -p$PASSWORD $DATABASE < db-setup.sql mysqlimport -u$DB_USER -p$PASSWORD --fields-terminated-by=, --columns='@x,@x,ip_from,ip_to,co..