Webmaster Forum

Go Back   Webmaster Forum > Web Development > Web Hosting Forum > Dedicated Servers

Dedicated Servers Dedicated server help.


Closed Thread
 
Thread Tools Display Modes
Share |
  #1  
Old 11-12-2010, 05:06 PM
basketmen basketmen is offline
Contributing Member
 
Join Date: 03-21-07
Posts: 97
iTrader: 0 / 0%
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

Quote:
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

Quote:
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

Quote:
[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
 

Advertisement

Advertisement

  #2  
Old 12-07-2010, 10:20 AM
solomonjago's Avatar
solomonjago solomonjago is offline
Member
 
Join Date: 08-16-10
Location: Los Angeles
Posts: 43
iTrader: 0 / 0%
Are you getting some type of error in the logs or during the process?
 
  #3  
Old 12-13-2010, 01:27 AM
instantit's Avatar
instantit instantit is offline
Contributing Member
 
Join Date: 12-12-10
Posts: 98
iTrader: 0 / 0%
Are you able to dump as root? If yes, then try mysqldump dbname > dbname.sql

Make sure the partition that you dumping having sufficient diskspace.
 
  #4  
Old 08-18-2011, 08:54 AM
PepperAdmi PepperAdmi is offline
Junior Member
 
Join Date: 07-07-11
Posts: 29
iTrader: 0 / 0%
When you got cPanel in your server why should you worry about doing it through backend
 
Go Back   Webmaster Forum > Web Development > Web Hosting Forum > Dedicated Servers

Closed Thread


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Backup Software half_a_nip Tech Talk 18 07-05-2010 10:34 PM
Why and How To Backup Your Blog snakeair Blogging Forum 8 04-06-2010 08:00 AM
Need advice RE online 'hypothetical medical advice' Midwifery Online Internet Legal Issues 10 02-18-2010 05:18 PM
wp-db-backup - Can you send it to me? dcristo Blogging Forum 2 07-20-2007 09:02 PM
How often do you backup your database? Pinyo Web Design Lobby 1 08-20-2004 12:01 PM


V7N Network
Get exposure! V7N I Love Photography V7N SEO Blog V7N Directory


All times are GMT -7. The time now is 01:35 AM.
Powered by vBulletin
Copyright 2000-2014 Jelsoft Enterprises Limited.
Copyright © 2003 - 2018 VIX-WomensForum LLC