Re: MySQL sock file is missing: server doesn't start
Hi, This can be useful... http://mafiree.com/blg/?p=124 -Partha www.mafiree.com - Original Message From: spacemarc spacem...@gmail.com To: MySQL mysql@lists.mysql.com Sent: Mon, 11 October, 2010 12:37:24 AM Subject: MySQL sock file is missing: server doesn't start hi MySQL server doesn't start because #2002 the /var/run/mysqld/mysqld.sock is missing. The server only start with sudo mysqld_safe but without the mysqld.sock file. I've checked my /etc/mysql/my.cnf file and the paths are correct for [client] and [mysqld]: /var/run/mysqld/mysqld.sock I run 5.1.41 on Ubuntu 10.04 How to resolve this issue? thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=par...@mafiree.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Backup
Do keep in mind that what you get there is going to be useless if your database doesn't already contain all the previous data. The inserts will work, of course, but any data modification may fail because the rows you modify aren't there when you restore. Make sure you know exactly what you want and what you're doing before implementing this. On Mon, Oct 11, 2010 at 5:10 PM, kranthi kranthikiran@gmail.com wrote: I get, I use following mysqlbinlog --start-date=2010-10-09 9:55:00 \ --stop-date=2010-10-10 10:05:00 \ /var/log/mysql/bin.123456 \ /tmp/mysql_restore.sql Thanks all From: andrew.2.mo...@nokia.com [mailto:andrew.2.mo...@nokia.com] Sent: Sunday, October 10, 2010 4:46 AM To: kranthikiran@gmail.com Subject: Re: Backup hmm a yesterday backup? MySqldump using where clauses? Why do you only want yesterday? -- Sent from my HTC Desire on 3 -- - Reply message - From: ext kranthi kranthikiran@gmail.com Date: Sun, Oct 10, 2010 04:51 Subject: Backup To: bac...@lists.mysql.com bac...@lists.mysql.com Hi , My database size is 900GB.i don't want full database backup. I need only yesterday backup. how can I take, please help me. Thanks Regards, Kranti -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
Re: Backup
Hi kranthi, Take a look at LVM and xtrabackup. http://www.mysqlperformanceblog.com/2009/02/24/xtrabackup-open-source-alternative-for-innodb-hot-backup-call-for-ideas/ http://marcus.bointon.com/archives/87-MySQL-backups-with-Perconas-XtraBackup.html Krishna CGI (cgi.com) On Sun, Oct 10, 2010 at 10:30 AM, kranthi kranthikiran@gmail.comwrote: Hi , My database size is 900GB.i don't want full database backup. I need only yesterday backup. how can I take, please help me. Thanks Regards, Kranti
Re: innodb backup
I'm interested in InnoDB backups. Does anyone use PHPMyAdmin ? I've a MySQL server on a shared hosting server. Cheers Neil On Sat, Oct 9, 2010 at 3:21 AM, short.cut...@yahoo.com.cn wrote: Hello, Is there any good document for backup of InnoDB? includes the increment backup and full backup. Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=neil.tompk...@googlemail.com
Re: innodb backup
Hi, On Sat, Oct 9, 2010 at 4:21 AM, short.cut...@yahoo.com.cn wrote: Hello, Is there any good document for backup of InnoDB? includes the increment backup and full backup. There is an overview of backups here http://dev.mysql.com/doc/refman/5.1/en/backup-methods.html XtraBackup supports incremental backups for InnoDB/XtraDB. http://www.percona.com/software/percona-xtrabackup/ Ewen Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=ewen.fort...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL sock file is missing: server doesn't start
2010/10/11 partha sarathy par...@mafiree.com: Hi, This can be useful... http://mafiree.com/blg/?p=124 i've checked your link but it doesn't work. mysqld server is not running and if i want to start it i obtain 2002 error because the /var/run/mysqld/mysqld.sock file is missing. If i start it with sudo mysqld_safe start the server starts for some seconds, the /var/run/mysqld/ dir is created and after it stops by itself. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL sock file is missing: server doesn't start
More often than not, this is a file permission issue. Does the MySQL user have permission to create a socket in /var/run/mysqld ?try ls -ld /var/run/mysqld ls -l /var/run/mysqld and make sure everything is owned by the MySQL user. - michael dykman On Mon, Oct 11, 2010 at 2:09 PM, spacemarc spacem...@gmail.com wrote: 2010/10/11 partha sarathy par...@mafiree.com: Hi, This can be useful... http://mafiree.com/blg/?p=124 i've checked your link but it doesn't work. mysqld server is not running and if i want to start it i obtain 2002 error because the /var/run/mysqld/mysqld.sock file is missing. If i start it with sudo mysqld_safe start the server starts for some seconds, the /var/run/mysqld/ dir is created and after it stops by itself. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org