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
here is the my.cnf content, from pctipsbox.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
What are the errors from /var/log/mysqld.log when this happens? What do you mean it stops, does it freeze, crash with errors? Gotta bring specifics.
Compare the old my.cnf to the new, I’ve had issues using the quick option before … none of my DBs were 2.2GB though.
i bet his ssh client is closing the connection due to no activity
Run your mysqldump in a screen. If you don’t have it installed yet, I think it can be installed in CentOS by doing:
yum install screen