New answers tagged export
You could also use MySQL events (like internal cron) and select into outfile. Advantages of this method? Your backups will contain this logic. Both approaches are valid IMO just depends on your preference.
To check this out, I did the following - I created a file called my_script.sql [pol@localhost inst]$ more my_script.sql use test; select * from example; [pol@localhost inst]$ Then ran the following [pol@localhost inst]$ ./bin/mysql -S ./mysql.sock -u root -pdba < my_script.sql > xfile Warning: Using a password on the command line interface can ...
After talking to someone more knowledgeable then me I have came up with the following answers to my original questions. TLDR; Cron should be fine for what your doing but don't write a bash script, write a PHP script instead, it's better. Q1. Do I have to worry about putting the database username/password into this >cron script? A1. As long as ...
Your current setup seems to be on the right track. I would cut SSIS out of the equation - the stored procedure INSERTs into the staging table, and then a C# app pulls the data out, creates the XML files, and SFTPs the files off to the destination. I realize that's more a 'developer' solution than an 'DBA' solution, but flat files and SFTP are not things ...
Top 50 recent answers are included