Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2007
    Posts
    292

    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

  2. #2
    Join Date
    Mar 2009
    Location
    Gods Own Country
    Posts
    681
    Are you coming to a conclusion only taking account of the low file size? Do you see any error while taking mysqldump?

    If the dump is successful and complete, then you should see something like "dump complete" at the end of backup file
    Fabin Mundattil @ Xieles Support
    High Quality Server Management | support @ xieles.com
    https://xieles.com

  3. #3
    Join Date
    Aug 2010
    Location
    Prague, Czech Republic
    Posts
    404
    Try options --debug-check and --verbose and check mysql logs.
    Supportex.Net server management, full range of services. EU-based outsourced company. Since 1998.
    Outstanding quality for high performance projects; clustering and high-availability solutions, DDoS protection.
    Cisco/Juniper network management & deployment assistance. Network design and monitoring.

Similar Threads

  1. Mysqldump question to make backup
    By hbhb in forum Hosting Security and Technology
    Replies: 6
    Last Post: 12-30-2009, 04:20 PM
  2. Replies: 7
    Last Post: 09-19-2009, 12:28 PM
  3. mysqldump in ssh
    By apacheMan in forum Hosting Security and Technology
    Replies: 4
    Last Post: 01-27-2008, 03:45 PM
  4. mysql backup: mysqldump or copy datadir?
    By MrAlien987 in forum Hosting Security and Technology
    Replies: 3
    Last Post: 07-07-2005, 07:02 PM
  5. GRR: Scheduled backup completed
    By Eagle in forum Dedicated Server
    Replies: 0
    Last Post: 07-21-2001, 06:27 AM

Posting Permissions

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