Menu

Revamped Script for MySQL Backup

2009-12-08
2013-05-29
  • Vijay Kiran Kamuju

    I have made a new project for this one.
    I just put in some fixes for the existing one and renamed it.
    Its now available here https://sourceforge.net/projects/autobackupmysql/files/
    This time the project will be active and submit your patches and feature requests there.
    I am trying to integrate some old interesting patches, so please send ur fixes there

     
  • Jorge Andrés Cañón Sierra

    Hello, I want to know if there is a backup limit size, becouse I'm getting only the structure with a few records. 8(

    My configuration file has this:

    quick
    quote-names
    max_allowed_packet = 3000MB

    But with big DB I only get 18.5MB

    If any body can help me, thanks a lot.

     
  • Johannes Kolter

    Johannes Kolter - 2010-07-03

    @jorge-canon:
    Please check the syntax for mysql option files at:
    http://dev.mysql.com/doc/refman/5.1/en/using-system-variables.html


    When you use a startup option to set a variable that takes a numeric value, the value can be given with a suffix of K, M, or G (either uppercase or lowercase) to indicate a multiplier of 1024, 10242 or 10243; that is, units of kilobytes, megabytes, or gigabytes, respectively.

    The current defaults can be obtained by "mysqldump ..help".

    IMHO 3000MB cannot return a valid number. Try 3G instead!

     

Log in to post a comment.