Jump to content
MaxCheaters Official Group on Discord
Top.MaxCheaters.com is now OPEN – Lineage 2 Top Listing

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.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing


  • Posts

    • l2naylondev
      L2naylonDev

      By l2naylondev · Posted

      Lineage 2 Interlude Developer – Cliente + Datapack Hola, soy developer especializado en Lineage 2 Interlude con experiencia tanto en cliente como datapack/core. ✔ Desarrollo datapack (Java, scripts, quests, balance PvP/PvE) ✔ Fixes core / geodata / exploits ✔ Sistemas custom (events, Olympiad, instancias, mods PvP) ✔ Cliente: interface mods, system patches, .dat edits, UI personalizada ✔ Optimización y estabilidad de servidor ✔ Trabajo freelance o colaboración fija Si necesitáis soporte dev o mejoras para vuestro servidor Interlude, podéis contactarme por DM. Portfolio y ejemplos disponibles bajo petición.
    • bomarket
      ⭐️BUYING CSGO SKINS⭐️INSTANT CRYPTO / BANK

      By bomarket · Posted

      Bump
    • drakenn
      I need help i pay lucera

      By drakenn · Posted

      pmed
    • NeoPacket0041
      HQ Photoshop | Verify Accs KYC, AML | Antiban 100% | PSD Tem

      By NeoPacket0041 · Posted

      THEY DON’T COME BACK FOR NO REASON. HERE’S WHY Our clients come from different countries and with very different tasks. But the strongest indicator of quality is simple — when a client comes back **for a second time**. This case is exactly that. The client returned with a request for a **German ID**. The requirement was clear: a document **in a male hand**, with a natural live scene and correct geographic context. What we did: ▪ accepted source files and data without unnecessary bureaucracy ▪ selected a **real street**, not a generic background ▪ built a print-ready mockup with correct scene logic ▪ sent it for approval ▪ after confirmation, delivered the **final file for printing** No templates. No “good enough”. Only solutions tailored to a specific task. Result: ▪ mockup approved on the first try ▪ client fully satisfied ▪ stays in touch We work **worldwide** — and that’s exactly why clients return. Contact us › TG: @mustang_service ( https:// t.me/ mustang_service ) › Channel: Mustang Service ( https:// t.me/ +6RAKokIn5ItmYjEx ) *All data is published with the client’s consent.* #redraw #verification #documents #case #ID
    • l2naylondev
      I need help i pay lucera

      By l2naylondev · Posted

      Lineage 2 Interlude Developer – Cliente + Datapack Hola, soy developer especializado en Lineage 2 Interlude con experiencia tanto en cliente como datapack/core. ✔ Desarrollo datapack (Java, scripts, quests, balance PvP/PvE) ✔ Fixes core / geodata / exploits ✔ Sistemas custom (events, Olympiad, instancias, mods PvP) ✔ Cliente: interface mods, system patches, .dat edits, UI personalizada ✔ Optimización y estabilidad de servidor ✔ Trabajo freelance o colaboración fija Si necesitáis soporte dev o mejoras para vuestro servidor Interlude, podéis contactarme por DM. Portfolio y ejemplos disponibles bajo petición.

  • Topics

×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..