newtomysql
Technical User
Dear All,
Is there a method to encrypt the results from a mysqldump process on windows environment? Thanks.
Is there a method to encrypt the results from a mysqldump process on windows environment? Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Encrypting mysqldump results?
- Thread starter newtomysql
- Start date
- Status
Use any encrypting program. As the results are basically a flat text file, any program will do.
You can also use windows own Encryption provided the file system is set as NTFS.
Just right click the folder where the mysqldump contents is located and then click on the advanced button, the last option should be "Encrypt Contents to secure data".
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.
You can also use windows own Encryption provided the file system is set as NTFS.
Just right click the folder where the mysqldump contents is located and then click on the advanced button, the last option should be "Encrypt Contents to secure data".
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.
- Thread starter
- #3
newtomysql
Technical User
Dear Vacunita,
What I plan is that part of my windows application I want to have a menu where user click on the backup menu where it should be able to mysqldump and also encrypt the file. Any idea about this? Thanks.
What I plan is that part of my windows application I want to have a menu where user click on the backup menu where it should be able to mysqldump and also encrypt the file. Any idea about this? Thanks.
Depending on what language you are using to create this application it may or may not have an encryption option.
For example if you where using Visual Basic, you could create an encryption routine:
But of course this is no longer a mysql question, but a programming question. So it is now off topic for this forum.
Perhaps asking in the relevant forum for the programming language you are using may yield better results.
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.
For example if you where using Visual Basic, you could create an encryption routine:
But of course this is no longer a mysql question, but a programming question. So it is now off topic for this forum.
Perhaps asking in the relevant forum for the programming language you are using may yield better results.
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.
- Thread starter
- #5
newtomysql
Technical User
Dear Vacunita,
I am planning to use c#. I would just like to ask you can I like run a windows application to do mysqldump job then I will get a .sql file output then I can encrypt that file using C# encryption what is your idea about this? Thanks.
I am planning to use c#. I would just like to ask you can I like run a windows application to do mysqldump job then I will get a .sql file output then I can encrypt that file using C# encryption what is your idea about this? Thanks.
Sure, you can have a Windows application execute the mysqldump and then encrypt the resulting file.
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.
- Thread starter
- #7
newtomysql
Technical User
Dear Vacunita,
Do you have any site or link where I can learn how to call mysqldump from my application? I guess I will settle this part first then only do encryption. Thanks.
Do you have any site or link where I can learn how to call mysqldump from my application? I guess I will settle this part first then only do encryption. Thanks.
Unfortunately I don't. As I don't really use C#. But maybe some of these results will work for you.
Remember to pass all user, password and filename to the mysqldump executable when you call it.
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.
Remember to pass all user, password and filename to the mysqldump executable when you call it.
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.
Could you knock out a C (or whatever language) module that reads from the stdin and encrypts then writes to the stdout. You might be able to do a mysqldump | youmod.exe > out.dump
Never tried it but I'm sure you can do such things as piping under windows
Never tried it but I'm sure you can do such things as piping under windows
- Status