Difference between revisions of "Sybase Dumps"
Jump to navigation
Jump to search
(How to modify the nightly sybase dumps) |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 8: | Line 8: | ||
## sqsh-sybprod-new | ## sqsh-sybprod-new | ||
# Add the query you want to run along with the others that are currently in the file | # Add the query you want to run along with the others that are currently in the file | ||
| − | ##'''Note:''' It is important to name the temporary text document that the data is being pulled into the '''same name as the destination table''' | + | ## '''Note:''' It is important to name the temporary text document that the data is being pulled into the '''same name as the destination table''' |
| − | # Edit the pipleline-sybase-new file and add ''tablename''.txt to the end of the mysqlimport line | + | # Edit the '''pipleline-sybase-new''' file and add ''tablename''.txt to the end of the mysqlimport line |
# Run ./pipeline-sybase-new on the cron server to populate the table | # Run ./pipeline-sybase-new on the cron server to populate the table | ||
Latest revision as of 16:49, 11 July 2006
Every night a cronjob runs that pulls information from Sybase into local tables on the ECE MySQL database servers. The following tables, in one form or another, are currently being pulled. The data in these Sybase tables is cleared nightly, though the table structure remains intact.
Creating New Sybase Dumps
- Create a table in the Sybase database
- Edit the file sybase_data_pre and add the line that you want to populate/repopulate with Sybase information.
- Depending on which Sybase database the information is being pulled from open up either:
- sqsh-sybextract-new
- sqsh-sybprod-new
- Add the query you want to run along with the others that are currently in the file
- Note: It is important to name the temporary text document that the data is being pulled into the same name as the destination table
- Edit the pipleline-sybase-new file and add tablename.txt to the end of the mysqlimport line
- Run ./pipeline-sybase-new on the cron server to populate the table