Menu
Forums
All threads
Latest threads
New posts
Trending threads
New posts
Search forums
Trending
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Upgrades
Log in
Register
What's new
Search
Search
Search titles only
By:
All threads
Latest threads
New posts
Trending threads
New posts
Search forums
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
Server Development
Habbo Retros
Habbo Tutorials
(Guide) Navicat and DropBox automatic backup
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="GodFather" data-source="post: 237946" data-attributes="member: 28646"><p><img src="http://picuza.com/i/HgJO7.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p></p><p>Hello, thought I would share this smart way to store automatic backups of your database in the cloud. Personally I don't like Navicat or Windows Server but I spent some time learning the basics in Navicat.</p><p></p><p><strong>What do I need?</strong></p><p>- Windows OS</p><p>- Navicat Premium</p><p>- Dropbox Free(or Pro)</p><p></p><p><strong>How does it work?</strong></p><p>It is very simple, you create a batch job that will take backup and give it a schedule so it will repeat. Now this is where Dropbox comes in, after installing Dropbox on your server you will get a folder that will sync all the files you upload. This means after the files are synced you can access them anywhere even if your server is off.</p><p></p><p>I will show you how to change destination folder for your backups. All your backups will be compressed in a .PSC file. This is why you don't really need a Pro user at Dropbox. My database is on 2 gb~ but after the backup is compressed and uploaded to Dropbox it's only 180 MB.</p><p></p><p><strong>Let's start</strong></p><p>1. Right-click on your connection and click Connection Properties</p><p><img src="http://picuza.com/i/2YTVDCq.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p></p><p>2. Click Advanced, then change "Settings Save Path" to your Dropbox folder.</p><p><img src="http://picuza.com/i/6tNRDvlO7.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p><em>My Dropbox folder is on my Desktop but you did maybe put your's somewhere else.</em></p><p></p><p>3. Go back to Navicat and press "Schedule", then click New Batch Job.</p><p></p><p></p><p><img src="http://picuza.com/i/JdRg8.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p></p><p>4. Double click on "Backup (yourdatabasename)" so it will show up in the field under.</p><p></p><p></p><p><img src="http://picuza.com/i/t7CGq.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p></p><p>5. Now let's save! press CTRL+S and type in a name ex. Backup and then Ok.</p><p></p><p>6. The backup is now ready but with no function. Press Set Task Schedule and go to "Schedule".</p><p></p><p>You can now enter when you would like to take automatic backups. I choosed Daily and 8 PM because then it's night where I live so few users are online.</p><p></p><p></p><p><img src="http://picuza.com/i/CTM5QBNWD.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p></p><p>7. After you have set your schedule press Ok and enter your server password.</p><p></p><p><strong>Pro tips:</strong> Create another Batch Job that empty your chatlog 5 minutes before the backup.</p><p></p><p>You can now access your backups anywhere and through all your devices!</p><p></p><p>This is also really smart in many ways, let's say your server gets hacked and they wipe your database. You will still have the database from last schedule. Just make sure to store Dropbox another place then your Desktop.</p><p></p><p>Enjoy!</p></blockquote><p></p>
[QUOTE="GodFather, post: 237946, member: 28646"] [IMG]http://picuza.com/i/HgJO7.png[/IMG] Hello, thought I would share this smart way to store automatic backups of your database in the cloud. Personally I don't like Navicat or Windows Server but I spent some time learning the basics in Navicat. [B]What do I need?[/B] - Windows OS - Navicat Premium - Dropbox Free(or Pro) [B]How does it work?[/B] It is very simple, you create a batch job that will take backup and give it a schedule so it will repeat. Now this is where Dropbox comes in, after installing Dropbox on your server you will get a folder that will sync all the files you upload. This means after the files are synced you can access them anywhere even if your server is off. I will show you how to change destination folder for your backups. All your backups will be compressed in a .PSC file. This is why you don't really need a Pro user at Dropbox. My database is on 2 gb~ but after the backup is compressed and uploaded to Dropbox it's only 180 MB. [B]Let's start[/B] 1. Right-click on your connection and click Connection Properties [IMG]http://picuza.com/i/2YTVDCq.png[/IMG] 2. Click Advanced, then change "Settings Save Path" to your Dropbox folder. [IMG]http://picuza.com/i/6tNRDvlO7.png[/IMG] [I]My Dropbox folder is on my Desktop but you did maybe put your's somewhere else.[/I] 3. Go back to Navicat and press "Schedule", then click New Batch Job. [IMG]http://picuza.com/i/JdRg8.png[/IMG] 4. Double click on "Backup (yourdatabasename)" so it will show up in the field under. [IMG]http://picuza.com/i/t7CGq.png[/IMG] 5. Now let's save! press CTRL+S and type in a name ex. Backup and then Ok. 6. The backup is now ready but with no function. Press Set Task Schedule and go to "Schedule". You can now enter when you would like to take automatic backups. I choosed Daily and 8 PM because then it's night where I live so few users are online. [IMG]http://picuza.com/i/CTM5QBNWD.png[/IMG] 7. After you have set your schedule press Ok and enter your server password. [B]Pro tips:[/B] Create another Batch Job that empty your chatlog 5 minutes before the backup. You can now access your backups anywhere and through all your devices! This is also really smart in many ways, let's say your server gets hacked and they wipe your database. You will still have the database from last schedule. Just make sure to store Dropbox another place then your Desktop. Enjoy! [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
Server Development
Habbo Retros
Habbo Tutorials
(Guide) Navicat and DropBox automatic backup
Top