Results 1 to 3 of 3
-
11-12-2010, 08:03 PM #1Web Hosting Guru
- 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
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
-
11-13-2010, 01:56 AM #2Web Hosting Master
- 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
-
11-13-2010, 06:23 AM #3Aspiring Evangelist
- 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
-
Mysqldump question to make backup
By hbhb in forum Hosting Security and TechnologyReplies: 6Last Post: 12-30-2009, 04:20 PM -
Advice required about backup hosting with FTP/SSH/Rsync access
By Master Bo in forum Web HostingReplies: 7Last Post: 09-19-2009, 12:28 PM -
mysqldump in ssh
By apacheMan in forum Hosting Security and TechnologyReplies: 4Last Post: 01-27-2008, 03:45 PM -
mysql backup: mysqldump or copy datadir?
By MrAlien987 in forum Hosting Security and TechnologyReplies: 3Last Post: 07-07-2005, 07:02 PM -
GRR: Scheduled backup completed
By Eagle in forum Dedicated ServerReplies: 0Last Post: 07-21-2001, 06:27 AM