Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New Coder
    Join Date
    Mar 2007
    Posts
    92
    Thanks
    2
    Thanked 0 Times in 0 Posts

    mysqldump (Backup using ssh) not completed, & please advice my.cnf

    Hi guys i just move to new server


    in previous server i can running mysql backup using mysqldump with no problem

    mysqldump --opt -u user -p dbname > backup.sql
    but in this new server, its running not completed, stopped in the middle

    the mysql size total are 2.2Gb, but its only get 650Mb



    please advice what should we do, current server's specs are bigger from the previous servers





    here is current server's specs

    Core i7 860 Quad Core - SINGLE CPU QUAD CORE 2.8GHZ FSB 2.5 GT/s (8MB CACHE) w/HT
    Control Panel: CPanel/WHM - Centos 5 64 Bit
    RAM/Memory: 8GB DDR3
    Primary Hard Drive: 1TB SATA





    here is the my.cnf content, from here, and please advice do you think below configuration are good for above server's specs, the server are running vbulletin big enough

    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    skip-innodb
    max_connections = 500
    key_buffer = 16M
    myisam_sort_buffer_size = 64M
    join_buffer_size = 1M
    read_buffer_size = 1M
    sort_buffer_size = 2M
    table_cache = 1024
    thread_cache_size = 64
    wait_timeout = 1800
    connect_timeout = 10
    max_allowed_packet = 16M
    max_connect_errors = 10
    query_cache_limit = 1M
    query_cache_size = 32M
    query_cache_type = 1

    [mysqld_safe]
    err-log=/var/log/mysqld.log
    open_files_limit = 8192

    [mysqldump]
    quick
    max_allowed_packet = 16M

    [myisamchk]
    key_buffer = 64M
    sort_buffer = 64M
    read_buffer = 16M
    write_buffer = 16M

    [mysql.server]
    user=mysql
    Whats up

  • #2
    Senior Coder
    Join Date
    Jul 2009
    Location
    South Yorkshire, England
    Posts
    2,318
    Thanks
    6
    Thanked 304 Times in 303 Posts
    Check your logs. How much free space is there in the directory you're doing the dump to?


  •  

    Posting Permissions

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