The main reason to not show your MySQL credentials of your live server on RUclips is because it makes it easier to exploit an injection attack if Sendy ever becomes vulnerable, since injected PHP code will still be run as "localhost"
Hello Nick, How to call SQL file(PostGresql) from shell script ? Could you please share a snippet for calling sql file from shell script. Thanks & Regards Raju
Hi, you mean importing a SQL file into postgres? There's an example of that in the gist linked in the description: gist.github.com/nickjj/00b07e522caee02e37951ec6de2a9c95#file-sendy-restore-L39
What if I wanna backup from different server? What do I have to add to the script? And, do I have to install odbc something like that, so destination server can recognize mysql database in other server?
I've never seen that show before. Before looking up the character I thought "wow, what a nice compliment". After looking up the character on fandom, now I'm freaked out because some of his character's description could be in my biography.
@@NickJanetakis By any means did I mean that as an insult either! I love Buster, highest of all compliments :) also on a more relevant matter, your video helped me so much! Very simple yet effective
HI @Nick Janetakis ...... !!!! For (POSTGRES) I need to compress the archive log files (WAL files) in various location kindly and delete the older WAL files periodically... Kindly suggest a better way to compress it in corn job or in manual command... If your willing kindly put a video belongs to this Postgres archive (compression) and do more videos on Postgres DB
It depends. If you're running everything on Windows you'd likely want to use PowerShell and Windows scheduled tasks but the same concepts would apply. If you're calling the mssql client from Linux then everything here would work except you'd only need to change the mysql/postgres commands to use mssql.
![Write Your Own Bash Scripts for Automation [Tutorial]](http://i.ytimg.com/vi/PPQ8m8xQAs8/mqdefault.jpg)
Great video as always! Thanks a lot! It would be nice to have in it a little section about backup behavior under the load (like tables locking, etc.).
Hi, oh yeah that will depend on which DB you're using. For example pg_dump will still allow connections while a dump is going.
@@NickJanetakis yeah I know, just mentioned this, because somebody might not
thank you! will try this on a Shared Dreamhost instance on my custom app.
very useful video, thank you
Thanks for watching.
The main reason to not show your MySQL credentials of your live server on RUclips is because it makes it easier to exploit an injection attack if Sendy ever becomes vulnerable, since injected PHP code will still be run as "localhost"
That's a good point too.
Очень круто, молодец.
very useful, thx !
Hello Nick,
How to call SQL file(PostGresql) from shell script ?
Could you please share a snippet for calling sql file from shell script.
Thanks & Regards
Raju
Hi, you mean importing a SQL file into postgres? There's an example of that in the gist linked in the description: gist.github.com/nickjj/00b07e522caee02e37951ec6de2a9c95#file-sendy-restore-L39
What if I wanna backup from different server? What do I have to add to the script? And, do I have to install odbc something like that, so destination server can recognize mysql database in other server?
The mysql command has a "host" flag where you can set the server (host) you want to connect to. No other tools need to be installed.
You look and sound just like Buster from Arrested Development lol
I've never seen that show before. Before looking up the character I thought "wow, what a nice compliment". After looking up the character on fandom, now I'm freaked out because some of his character's description could be in my biography.
@@NickJanetakis By any means did I mean that as an insult either! I love Buster, highest of all compliments :) also on a more relevant matter, your video helped me so much! Very simple yet effective
@@NickJanetakis This is hilarious!
HI @Nick Janetakis ...... !!!! For (POSTGRES) I need to compress the archive log files (WAL files) in various location kindly and delete the older WAL files periodically... Kindly suggest a better way to compress it in corn job or in manual command...
If your willing kindly put a video belongs to this Postgres archive (compression)
and do more videos on Postgres DB
Hi, the postgres solution provided in this video will compress the file. That's what the -c flag does.
@@NickJanetakis
Sry, could you provide the link 🔗 pls buddy...
@@umarsharief3683 It's near the top of the description gist.github.com/nickjj/00b07e522caee02e37951ec6de2a9c95.
Does it work for mssql??
It depends. If you're running everything on Windows you'd likely want to use PowerShell and Windows scheduled tasks but the same concepts would apply. If you're calling the mssql client from Linux then everything here would work except you'd only need to change the mysql/postgres commands to use mssql.
@@NickJanetakis thanks will try it..