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

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

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

 

Did you check the log to see if there is any errors?

 

its backup process using ssh, how to check the error log? there is no error message after that command btw, just stopped like that

 

Check your folders /var/log for errors (maybe mysqld.log ?). Also sometimes you can see errors at /var/log/mysql/ etc

As for optimizing, I suggest using mysqltuner. Just do "wget mysqltuner.pl" in shell and then execute the file by typing "perl mysqltuner.pl"

Enter the root and pass and it'll give you tips on what to do. You'll have to slowly do this over the month. Won't get a perfect answer right away.

Also I can help you but obviously I'll need your ssh access. Its up to you. You can PM me the info if you want.

 

Try this one:

mysqldump --debug-check --opt --extended-insert --quick --max_allowed_packet=1G --verbose db_name > ./db_name.sql

Code (markup):

If everything is okay you'll see "Dump completed" at the end of the dump file.

And yes, it might be useful to check MySQL log in /var/log/mysqld.log. There should be some errors or warnings.
Hope it will help you.

 

try this.it works fine for me on the same server specs

mysqldump -u username -p password dbname > dbbackup.sql.gz