Re: MySQL sock file is missing: server doesn't start

2010-10-11 Thread Michael Dykman
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, spacemar

Re: MySQL sock file is missing: server doesn't start

2010-10-11 Thread spacemarc
2010/10/11 partha sarathy : > 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 mysq

Re: innodb backup

2010-10-11 Thread ewen fortune
Hi, On Sat, Oct 9, 2010 at 4:21 AM, 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

Re: innodb backup

2010-10-11 Thread Tompkins Neil
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, wrote: > Hello, > > Is there any good document for backup of InnoDB? > includes the increment backup and full backup. > > Thanks. > > > --

Re: Backup

2010-10-11 Thread Krishna Chandra Prajapati
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 a

Re: Backup

2010-10-11 Thread Johan De Meersman
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 an

Re: MySQL sock file is missing: server doesn't start

2010-10-11 Thread partha sarathy
Hi, This can be useful... http://mafiree.com/blg/?p=124 -Partha www.mafiree.com - Original Message From: spacemarc To: MySQL 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/my