mysqldump Resulting in Incomplete Backup on New Server

  • basketmen
  • Student
  • Student
  • basketmen
  • Posts: 80

Post 3+ Months Ago

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 dot com/a-real-production-mycnf-file-for-mysql-server/ , and please advice do you think below configuration are good for above server's specs, the server are running vbulletin big enough

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

open_files_limit = 8192

max_allowed_packet = 16M

key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M

  • Don2007
  • Web Master
  • Web Master
  • Don2007
  • Posts: 4923
  • Loc: NY

Post 3+ Months Ago

Look at the event viewer for errors. Not knowing anything about it, that would be the first thing that I would do.
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Posts: 9193
  • Loc: Seattle, WA & Phoenix, AZ

Post 3+ Months Ago

Where are you backing the file up to? Try running df and make sure you have enough space on that partition wherever you are backing up to.

Post Information

  • Total Posts in this topic: 3 posts
  • Users browsing this forum: No registered users and 10 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum

© 1998-2017. Ozzu® is a registered trademark of Unmelted, LLC.