User Tools

Site Tools


dba:mysql:oracle_2_mysql_data_transfer

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
dba:mysql:oracle_2_mysql_data_transfer [2022/02/11 11:12] – ↷ Page moved from mysql:oracle_2_mysql_data_transfer to dba:mysql:oracle_2_mysql_data_transfer dodgerdba:mysql:oracle_2_mysql_data_transfer [2022/02/11 11:36] (current) – external edit 127.0.0.1
Line 162: Line 162:
 MYSQL="mysql -u${MYUSER} -p${MYPASSWD}" MYSQL="mysql -u${MYUSER} -p${MYPASSWD}"
  
-ORA2MY="python /home/scripts/Infrastructure.Database.MySQL/ora2my_transfer/ora2my_sync.py"+ORA2MY="python /home/scripts/The_fucking_bofh.Database.MySQL/ora2my_transfer/ora2my_sync.py"
  
 TABLELIST="VW_FINDER_RESTAURANTS USER_PREFERRED_UNITS VW_FINDER_PARKINGS VW_FINDER_GAS_STATIONS" TABLELIST="VW_FINDER_RESTAURANTS USER_PREFERRED_UNITS VW_FINDER_PARKINGS VW_FINDER_GAS_STATIONS"
Line 348: Line 348:
 User apache User apache
 Group apache Group apache
-ServerAdmin sysadmin@voxelgroup.net+ServerAdmin sysadmin@ciberterminal.net
  
 # CGI-BIN LONG TIMEOUT # CGI-BIN LONG TIMEOUT
Line 430: Line 430:
 Add users: Add users:
 <code bash> <code bash>
-htpasswd -bc .basic_pw jholgado <thepassword>+htpasswd -bc .basic_pw dodger <thepassword>
 </code> </code>
  
 Launch Script: Launch Script:
 <code bash> <code bash>
-cp /home/scripts/Infrastructure.Database.MySQL/ora2my_transfer/launch_sync.sh /var/www/cgi-bin+cp /home/scripts/The_fucking_bofh.Database.MySQL/ora2my_transfer/launch_sync.sh /var/www/cgi-bin
 chmod +x /var/www/cgi-bin/launch_sync.sh chmod +x /var/www/cgi-bin/launch_sync.sh
 </code> </code>
Line 446: Line 446:
 Sample run: Sample run:
 <code bash> <code bash>
-curl -s -u jholgado:<thepassword> --basic "http://10.63.3.170/cgi-bin/launch_sync.sh?mode=sync&tables=USER_PREFERRED_UNITS" | jq .+curl -s -u dodger:<thepassword> --basic "http://10.63.3.170/cgi-bin/launch_sync.sh?mode=sync&tables=USER_PREFERRED_UNITS" | jq .
 </code> </code>
  
dba/mysql/oracle_2_mysql_data_transfer.1644577953.txt.gz · Last modified: 2022/02/11 11:12 by dodger