Forum Moderators: phranque

Message Too Old, No Replies

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

         

basketmen

12:09 am on Nov 13, 2010 (gmt 0)

10+ Year Member



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 [pctipsbox.com...] , 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

sublime1

1:16 am on Nov 13, 2010 (gmt 0)

10+ Year Member



This is an Apache forum, not a MySQL forum.

In any case, if you have access to it, check the error log, which will most definitely tell you why MySQL stopped. Unless you don't have enough free disk space for the dump file, it's probably one of the memory settings.

Tom