Jump to content
--> Place your ad text here <--
Get Free Banners - Giveaway MaxCheaters.com
We're Rebuilding – Join Our Staff Team

Autobackup For Navicat

Deamnd
 Share

Recommended Posts

Deamnd Newbie

Deamnd

Posted
Posted

HgJO7.png

Hello, thought I would share this smart way to store automatic backups of your database in the cloud.

What do I need?

- Windows OS

- Navicat Premium

- Dropbox Free(or Pro)

 

How does it work?

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.

 

Let's start

  • 1. Right-click on your connection and click Connection Properties

2YTVDCq.png

 

  • 2. Click Advanced, then change "Settings Save Path" to your Dropbox folder.

6tNRDvlO7.png

My Dropbox folder is on my Desktop but you did maybe put your's somewhere else.

 

  • 3. Go back to Navicat and press "Schedule", then click New Batch Job.

JdRg8.png

 

  • 4. Double click on "Backup (yourdatabasename)" so it will show up in the field under.

t7CGq.png

 

  • 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.

 

CTM5QBNWD.png

 

  • 7. After you have set your schedule press Ok and enter your server password.

 

Pro tips: 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!

 

Credits:Exonize

Deamnd Newbie

Deamnd

Posted
  • Author
Posted

Nice

Thanks!

I used navicat when i had the cs community and never had a problem with it at all.

Thanks for sharing it with us.

My pleasure!

Awesome! I'm going to reward you for the time you spend on this guide!

+1 karma

Thanks!

CryStaliN Newbie

CryStaliN

Posted
Posted

Awesome! I'm going to reward you for the time you spend on this guide!

+1 karma

 

I haven't seen the credits yet.Hope it's his guide. (ima do a research anyway)

CryStaliN Newbie

CryStaliN

Posted
Posted

 

I found it also. (a simple search on the inet revealed it)

 

Lets see... i'm waiting.

 

Anything else ?

Stewie Newbie

Stewie

Posted
Posted

I found it also. (a simple search on the inet revealed it)

 

Anything else ?

 

Is there a problem that i'm using my rights that i donate for to reward a person who i tough that done great job?

Even if i have an little doubt he do it himself.

CryStaliN Newbie

CryStaliN

Posted
Posted

Is there a problem that i'm using my rights that i donate for to reward a person who i tough that done great job?

Even if i have an little doubt he do it himself.

 

Please i'm not new here.

Abuse your karma privileges once again and we wont talk.

This your first and last warn guys.

 

i told that its my guide?:O

btw credits added!

 

You dont deserve the karma that's all,end.

Stewie Newbie

Stewie

Posted
Posted

Please i'm not new here.

Abuse your karma privileges once again and we wont talk.

This your first and last warn guys.

 

You warn me or what? I accept warn as a serious buisness that should be discuss in report section.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing


  • Posts

    • SocNet
      ⭐SOCNET BOOST⭐ is a new solution among all SMM panels

      By SocNet · Posted

      Dear friends, right now we are holding a grand competition with a prize fund of more than $ 1000 in our stores https://socnet.store , telegram store: https://socnet.shop and SMM panel: https://socnet.pro There are more than 50 prize places in our competition, each lucky person can take one of the places. Important condition: you must make a purchase at any time before June 1, 2025. The more purchases you make - the more chances you have to win the main prize in the community of $ 300! ➡ Our Online Shop: socnet.store  ➡ Our SMM-Boosting Panel: socnet.pro  ➡ Telegram Shop Bot: socnet.shop  ➡ Telegram Support: https://t.me/solomon_bog  ➡ Telegram Channel: https://t.me/accsforyou_shop  ➡ Discord Support: @AllSocialNetworksShop  ➡ Discord Server: https://discord.gg/y9AStFFsrh  ➡ WhatsApp Support: 79051904467 ➡ WhatsApp Channel: https://whatsapp.com/channel/0029Vau0CMX002TGkD4uHa2n  ➡ Email Support: solomonbog@socnet.store 
    • SocNet
      SOCNET | The Social Media acocunts at low prices!

      By SocNet · Posted

      Dear friends, right now we are holding a grand competition with a prize fund of more than $ 1000 in our stores https://socnet.store , telegram store: https://socnet.shop and SMM panel: https://socnet.pro There are more than 50 prize places in our competition, each lucky person can take one of the places. Important condition: you must make a purchase at any time before June 1, 2025. The more purchases you make - the more chances you have to win the main prize in the community of $ 300! ➡ Our Online Shop: socnet.store  ➡ Our SMM-Boosting Panel: socnet.pro  ➡ Telegram Shop Bot: socnet.shop  ➡ Telegram Support: https://t.me/solomon_bog  ➡ Telegram Channel: https://t.me/accsforyou_shop  ➡ Discord Support: @AllSocialNetworksShop  ➡ Discord Server: https://discord.gg/y9AStFFsrh  ➡ WhatsApp Support: 79051904467 ➡ WhatsApp Channel: https://whatsapp.com/channel/0029Vau0CMX002TGkD4uHa2n  ➡ Email Support: solomonbog@socnet.store 
    • xaguR
      REBORN ETERNAL x10

      By xaguR · Posted

      REBORN ETERNAL IL x10 WTS  1gb 8e (a lot in stock) DR set +6 180e Frintezza+6 200e Zaken+6 200e AQ+6 200e You must go first or Pufa middleman service
    • Tryskell
      aCis - another CRAPPY interlude server

      By Tryskell · Posted

      There's many reasons why it would be more NO than YES : Using NCSoft assets is a death wish, they can lawyer any LU3/Unity if they wanted, since it's a plain steal of intellectual property. It's an hobby, as you said it, and it's not specially about money. Money is a way to filter idiots/resellers, nothing more. It's really about trying to replicate old content and optimize it which I find it fun. I just align with the basic idea than an emulator emulates. When you launch Project64 and SuperMario 64, you don't expect to get something more than 120 stars and Bowser boss in the end - which should have been L2J project to begin with Even if I played a lot with TESCS from Morrowind, back in time, it's not enough to handle current engines, and I'm too lazy to learn Unity/Unreal Engine. Moreover, it would mean buying assets. While doing it alone would be a fail, coupling to L2J / L2 community would still be shitty (since the majority is RU/BR) ; people is only about fame/glory/reselling shit on back of others. Opening to others, the project would be leaked day 1, rebranded and resold. MMO genre is basically dead, and that's not a reboot of any game (l2/wow classic :D) which will turn the tide. Regarding L2 or an remastered version of it, you can obviously blatantly copy-cat it (as Propnight did for Dead by daylight).   All frenchies aren't supposed to do Expedition 33 :).
    • ZOUMHS
      PTS Vanganth - Classic Interlude P110

      By ZOUMHS · Posted

      190euro until last month, don't miss it.

  • Topics

×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock