[root@test /]$ mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib h socket '/var/lib/mysql/mysql.sock' (2)service mysqld statusSQL server through
-bash: syntax error near unexpected token `('
[root@test /]$ service mysqld status
mysqld is stopped
[root@test /]$ ps fax | grep mysqld
5636 pts/1 S+ 0:00 \_ grep mysqld
[root@test /]$ service mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]
[root@test /]$
Moderator's Comments:
Use code tags please, ty. See PM.
Last edited by zaxxon; 12-29-2011 at 10:10 AM..
Reason: code tags
I just moved a dedicated server, which included moving to a new subnet, and new IP address. Now my server is not reconnecting - I've tried ifconfig, altering the etc/hosts file with the new ip address, with no luck. (5 Replies)
Hi. First of all, would 4 or 5 websites, 1 ftp server (when downloading by someone or a few persons or one, concretize) and one mail server (not many emails, just to sound official and have a nice, spam-free email for myself). Websites with not that many, but some, later more visitors, quite... (0 Replies)
Hi guys.
I am gonna buy a dedicated server and make it a public mirror for some distributions.
but how much RAM, Hard Disk, Band Width, ... will suffice? It will be a mirror for CentOS and Ubuntu both. (3 Replies)
Hi,
Any one please suggest me the best mysql, apache settings for the given below scenario.
My Server config:
Intel(R) Xeon(R) CPU E5504 @ 2.00GHz
8GB RAM
300GB HDD
Website:
It's a famous wordpress blog
Mysql DB size: 235MB
Expectations:
Server should be handle 600+ concurrent... (0 Replies)
Dear Friends,
We have a 4 dedicated servers. All are working but the thing is one server is not working. when i go to network tools and after i enter my host domain i cant able to ping. it is showing host not found. But remaining servers are working. I terminate my account and re-again create... (4 Replies)
Hi there,
I have a dedicated server that sends mail with own smtp (obviously).
On this server I have a web platform for music artists that allows entries for each enrollment and sends confirmation e-mails and so on ...
Now I have purchased a service smtp (like those of smtp.com) because I... (3 Replies)
Retro Games has announced that the C64 is back, this time full-sized with a working keyboard for the dedicated retro home-computer fan, available December 2019.
See also:
CNN:
Iconic 80s computer The Commodore 64 to return with fully-functional keyboard
YouTube:
The C64 | Trailer
... (2 Replies)
Discussion started by: Neo
2 Replies
LEARN ABOUT DEBIAN
save_binary_logs
SAVE_BINARY_LOGS(1p) User Contributed Perl Documentation SAVE_BINARY_LOGS(1p)NAME
save_binary_logs - Concatenating binary or relay logs from the specified file/position to the end of the log. This command is automatically
executed from MHA Manager on failover, and manual execution should not be needed normally.
SYNOPSIS
# Test
$ save_binary_logs --command=test --binlog_dir=/var/lib/mysql --start_file=mysqld-bin.000002
# Saving binary logs
$ save_binary_logs --command=save --binlog_dir=/var/lib/mysql --start_file=mysqld-bin.000002 --start_pos=312
--output_file=/var/tmp/aggregate.binlog
# Saving relay logs
$ save_binary_logs --command=save --start_file=mysqld-relay-bin.000002 --start_pos=312 --relay_log_info=/var/lib/mysql/relay-log.info
--output_file=/var/tmp/aggregate.binlog
save_binary_logs concatenates binary or relay logs from the specified log file/position to the end of the log. This tool is intended to be
invoked from the master failover script(MHA Manager), and manual execution is normally not needed.
DESCRIPTION
Suppose that master is crashed and the latest slave server has received binary logs up to mysqld-bin.000002:312. It is likely that master
has more binary logs. If it is not sent to the slave, slaves will lose all binlogs from mysqld-bin.000002:312. The purpose of the
save_binary_logs is to save binary logs that are not replicated to slaves. If master is reachable through SSH and binary logs are readable,
saving binary logs is possible.
Here is an example:
$ save_binary_logs --command=save --start_file=mysqld-bin.000002 --start_pos=312 --output_file=/var/tmp/aggregate.binlog
Then all binary logs starting from mysqld-bin.000002:312 are concatenated and stored into /var/tmp/aggregate.binlog. If you have binary
logs up to mysqld-bin.000004, the following mysqlbinlog outputs are written.
mysqld-bin.000002:Format Description Event(FDE), plus from 312 to the tail mysqld-bin.000003:from 0 to the tail, excluding FDE
mysqld-bin.000004:from 0 to the tail, excluding FDE
perl v5.14.2 2012-01-08 SAVE_BINARY_LOGS(1p)
12-29-2011
