automatic imp/exp [message #349643] |
Mon, 22 September 2008 08:29  |
abdulaziz
Messages: 102 Registered: May 2008 Location: Douala
|
Senior Member |
|
|
Hello,
I have a bit of a coding problem. We're working on a dev server and the backup method we use at this stage is a normal export of the schema on which the developments are made. After every major dev, a dump is made. Now management wants to automate the export and schedule it every 9PM. Haven't done that that way before. Can anyone help me?
Thanks in advance.
|
|
|
|
Re: automatic imp/exp [message #349656 is a reply to message #349648] |
Mon, 22 September 2008 09:26   |
abdulaziz
Messages: 102 Registered: May 2008 Location: Douala
|
Senior Member |
|
|
Michel Cadot wrote on Mon, 22 September 2008 08:58 | export is NOT a database backup strategy.
| Thank you for correcting me. Can we call it a backup method?
Thanks for the tip.But how do we do that on LINUX?
[Updated on: Mon, 22 September 2008 09:53] Report message to a moderator
|
|
|
Re: automatic imp/exp [message #349670 is a reply to message #349656] |
Mon, 22 September 2008 10:36   |
 |
Michel Cadot
Messages: 68733 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
abdulaziz wrote on Mon, 22 September 2008 16:26 | Michel Cadot wrote on Mon, 22 September 2008 08:58 | export is NOT a database backup strategy.
| Thank you for correcting me. Can we call it a backup method?
Thanks for the tip.But how do we do that on LINUX?
|
1/ You can call it a logical backup or a data backup keeping in mind that you can only restore what you saved, that is some data at the backup date.
2/ Why do you want to know how to do it on Linux when you said you are working on Windows?
Regards
Michel
[Updated on: Mon, 22 September 2008 10:37] Report message to a moderator
|
|
|
Re: automatic imp/exp [message #349818 is a reply to message #349670] |
Tue, 23 September 2008 03:58   |
abdulaziz
Messages: 102 Registered: May 2008 Location: Douala
|
Senior Member |
|
|
1/ Go for "data backup" then.
2/ You know what they say: "Prevention is better than cure".We never know...I might need to do it someday on Linux. In addition, I have a db on my laptop that runs on Linux(RHEL4), and every new thing I do on Windows, I try and repeat it on Linux.I can put automatic import in practice the same way, so when the time comes, I am ready. Besides, That'd be a plus in my knowledge.
So do you know how to do it in Linux?
|
|
|
|
|