Forum

Results 1 to 4 of 4
  1. #1
    EndCrawler Guest

    Create a database backup while server is running

    Hello Server Admin's and Devs,

    is it possible to backup a server (mysqldump of database and exact copy of file system) while it is running?
    Do I need to stop the server to get a working copy of my server?

    It is much nicer if the server does not have to stop for every backup because it take a while to initiate a new database connection.

    Thank you for helping.

  2. #2
    Join Date
    December 2004
    Location
    RF
    Posts
    3,007
    It is strongly recommended to shutdown virtual server before taking a snapshot.
    However, if you aren't changing settings (s.a. group permissions) often, and make backups on a regular basis, it's somewhat safe to make backups from running server.

  3. #3
    Join Date
    October 2018
    Location
    France
    Posts
    19

    How to hot backup ?

    Hello,

    I'd like to backup my TS server (3.4, able to move 3.5 if required) with no shutdown of it.

    I'm under current config :
    - Win Server 2016 (x64 of course) as Root Admin
    - I'm using PowerShell script to copy files to backup servers
    - I can setup new database (Mysql or SQL Server) if required
    - I'm not using any specific software to backup
    - I now how to setup a windows programmed task

    Obviously, the main problem is that TS database files is locked while trying to backup TS directory.

    Maybe is there any possiblity to migrate from sqlitedb to mysql (eg. keep current data in ts database) ? If so, I know how to properly set backups.
    Or any other solution ?

    See you soon,
    Lix [Playing Society]
    Last edited by dante696; November 10th, 2018 at 03:02 PM. Reason: merged

  4. #4
    Join Date
    June 2008
    Posts
    18,255
    There is no supported way with the database.
    If you do you always have defined broken database.
    The server stores some data in RAM and writes them on shutdown into the database.

    Snapshots or a backup while the whole instance was stopped (not killed) are the only supported ways.
    When sending me private messages: Please make sure to include reference link to your forum thread or post.

    TeamSpeak FAQ || What should i report, when i open a client thread?

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [Not Supported] Running server as backup? "is running elsewhere, shutting down!"
    By alexcroox in forum Server Support
    Replies: 5
    Last Post: March 2nd, 2016, 11:22 AM
  2. Backup Server shutdown "running somewhere else"
    By Archness in forum Server Support
    Replies: 11
    Last Post: December 5th, 2013, 01:55 PM
  3. Replies: 2
    Last Post: November 23rd, 2011, 09:53 PM
  4. Backup SQLite while server is running
    By Baraan in forum Server Support
    Replies: 2
    Last Post: June 19th, 2010, 11:25 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •