Differences

This shows you the differences between two versions of the page.

--- portainer:dockers:mysql [2024/07/28 14:10] – created dirk
+++ portainer:dockers:mysql [2024/08/22 15:38] (current) – [Load Football pool] dirk
@@ Line 29: / Line 29: @@
 ===== Load Football pool =====
   * Create csv file
-  * Cyberduck it over to tmp folder on unraid server
+  * copy it over to the transfer folder on unraid backup share
-  * copy it to tmp folder on docker <code>docker cp /tmp/2021.csv mysql:/tmp/2021.csv</code>
+  * copy it to datalink folder on mysql appdata folder<code>sudo cp /mnt/backup/xfer/2024.csv /mnt/nvme/appdata/mysql/datalink/</code>
-  * go back to docker console, copy it to mysql-files directory <code> cp /tmp/2021.csv /var/lib/mysql-files/2021.csv</code>
+  * log into mysql shell
-  * log into mysql
   * check LOCAL INFILE var <code> mysql> show global variables like 'local_infile';</code>
   * fix it if need be <code> mysql> set global local_infile=true;</code>
   * log out of mysql and back in with proper option <code> mysql --local_infile=1 -u root -ppassword DB_name</code>
-  * Use normal commands <code>LOAD DATA LOCAL INFILE "/var/lib/mysql/2021.csv" INTO TABLE games COLUMNS TERMINATED BY ',';
+  * Use normal commands <code>LOAD DATA LOCAL INFILE "/var/lib/mysql/datalink/2024.csv" INTO TABLE games_nfl COLUMNS TERMINATED BY ',';
-UPDATE games SET vscore = NULL where year = 2021;
+UPDATE games SET vscore = NULL where year = 2024;
-UPDATE games SET hscore = NULL where year = 2021;</code>
+UPDATE games SET hscore = NULL where year = 2024;</code>
+  * DON'T FORGET TO ADD A NEW COLUMN FOR THE NEW YEAR IN "OVERALL_NFL"!!!
 ===== Adjust Max Connections =====

brimble.com

User Tools

Site Tools

Differences

Page Tools