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

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 here, 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




Old 12-07-2010, 10:20 AM
solomonjago's Avatar
solomonjago solomonjago is offline
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?
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.
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 10:11 AM.
Powered by vBulletin
Copyright 2000-2014 Jelsoft Enterprises Limited.
Copyright © 2003 - 2018 VIX-WomensForum LLC