Results 1 to 7 of 7

Thread: Error while backing up database XXX: The sql file is 0 bytes in size

  1. #1
    Join Date
    Feb 2016
    Posts
    6

    Error while backing up database XXX: The sql file is 0 bytes in size

    Hi folks!

    After upgrading to MariaDB (instead of MySQL) I get this error.

    Error while backing up database XXX
    Error while backing up database XXX: The sql file is 0 bytes in size: /home/tmp/admin.933/admin/backup/XXX.sql
    mysqldump error output: /usr/bin/mysqldump: unknown variable 'max_connections=5000'


    What's the best way to fix this?

    Cheers!

  2. #2
    Join Date
    Aug 2015
    Posts
    302
    show us your /etc/my.cnf file here.
    Kind regards, Fred

    Alentejo Webdesign
    Webdesign with Passion is what we do
    Web development, Hosting, Speed Optimizing & More......

  3. #3
    Join Date
    Feb 2016
    Posts
    6
    It's pretty empty...

    Code:
    #
    # This group is read both both by the client and the server
    # use it for options that affect everything
    #
    [client-server]
    
    #
    # include all files from the config directory
    #
    !includedir /etc/my.cnf.d
    
    max_connections=5000

  4. #4
    Join Date
    Aug 2015
    Posts
    302
    and etc/my.cnf.d/server.cnf
    Kind regards, Fred

    Alentejo Webdesign
    Webdesign with Passion is what we do
    Web development, Hosting, Speed Optimizing & More......

  5. #5
    Join Date
    Apr 2005
    Location
    GMT +7.00
    Posts
    12,133
    Hello,

    Move

    Code:
     max_connections=5000
    under section

    Code:
    [mysqld]
    in /etc/my.cnf


    Code:
    #
    # This group is read both both by the client and the server
    # use it for options that affect everything
    #
    [client-server]
    
    #
    # include all files from the config directory
    #
    
    !includedir /etc/my.cnf.d
    
    [mysqld]
    max_connections=5000

  6. #6
    Join Date
    Feb 2016
    Posts
    6
    Thanks, did the trick.

    Any idea why this happened?

  7. #7
    Join Date
    Apr 2005
    Location
    GMT +7.00
    Posts
    12,133
    Directadmin does not add anything of that in MySQL config.

    I will need root access to SSH on your server to investigate the incident if you want to know how it happened. It will cost you some money.

Posting Permissions

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