Results 1 to 9 of 9
Thread: Can't start mysql
-
08-31-2011, 05:29 PM #1Junior Guru Wannabe
- Join Date
- Feb 2010
- Posts
- 78
Can't start mysql
I have a linux centos vps hosting and several hours ago my site was down for an unknown reason. I couldn't access even the plesk control panel. I have contacted my hosting provider and they made some changes as it seems. Now I can access plesk but my site is still down... As far as I can figure out there are some problems with the database. I can't connect to mysql. I tried to restart mysql and the whole server as well but it didn't help. I have no idea what should I do next. It's already several hours I haven't heard anything from the hosting provider!
Any help would be appreciated!
-
08-31-2011, 05:32 PM #2Web Hosting Master
- Join Date
- Jul 2010
- Location
- ~/
- Posts
- 1,382
Anything interesting in /var/log/mysqld.log ? try to start it then 'tail /var/log/mysqld.log'
█ -> INCEPTION HOSTING LIMITED Since 2010!
█ -> I am most active on the lowendspirit hosting forum Come join us!
█ -> PHOENIX USA & THE NETHERLANDS & UK EU
-
08-31-2011, 05:51 PM #3Web Hosting Master
- Join Date
- May 2011
- Location
- New York, USA
- Posts
- 4,019
Try to reboot the vps and see what happens
- Nexus Bytes LLC- Ryzen powered NVME VPS and web hosting, packed with perks and love!
- Entry Bytes - Affordable VPS ≠ Cheap quality
- USA (NYC | Miami | LA) | Europe (London, UK | Naaldwijk, NL) | Asia Pacific (Singapore | Japan | Australia)
-
08-31-2011, 05:52 PM #4Junior Guru Wannabe
- Join Date
- Feb 2010
- Posts
- 78
Here is the log from latest attempt to restart mysql (I used command "service mysqld restart" from ssh):
110901 1:50:34 [Note] /usr/libexec/mysqld: Normal shutdown
110901 1:50:34 [Note] /usr/libexec/mysqld: Shutdown complete
110901 01:50:34 mysqld ended
110901 01:50:34 mysqld started
110901 1:50:34 [Warning] option 'innodb_additional_mem_pool_size': signed value 512000 adjusted to 524288
InnoDB: Error: auto-extending data file ./ibdata1 is of a different size
InnoDB: 0 pages (rounded down to MB) than specified in the .cnf file:
InnoDB: initial 640 pages, max 0 (relevant if non-zero) pages!
InnoDB: Could not open or create data files.
InnoDB: If you tried to add new data files, and it failed here,
InnoDB: you should now edit innodb_data_file_path in my.cnf back
InnoDB: to what it was, and remove the new ibdata files InnoDB created
InnoDB: in this failed attempt. InnoDB only wrote those files full of
InnoDB: zeros, but did not yet use them in any way. But be careful: do not
InnoDB: remove old data files which contain your precious data!
110901 1:50:34 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
-
08-31-2011, 06:38 PM #5Web Hosting Master
- Join Date
- Jul 2010
- Location
- ~/
- Posts
- 1,382
hmm idd, is it listening on the local address? 'telnet localhost 3306' ?
Do you have it binding to the local ip or 0.0.0.0?█ -> INCEPTION HOSTING LIMITED Since 2010!
█ -> I am most active on the lowendspirit hosting forum Come join us!
█ -> PHOENIX USA & THE NETHERLANDS & UK EU
-
08-31-2011, 10:39 PM #6Aspiring Evangelist
- Join Date
- Oct 2006
- Location
- State College, PA USA
- Posts
- 370
Cheap VPS Hosting with minimum 99.9% SLA.
State College, PA VPS Hosting
-
08-31-2011, 10:47 PM #7Web Hosting Master
- Join Date
- Apr 2009
- Location
- inside wht
- Posts
- 746
Please check Dave's suggestion . Check the /var/lib/mysql/ folder and see what permissions and ownerships the databases and ibdata files have.
24x7 PROACTIVE SERVER MANAGEMENT | OUTSOURCED WEB HOSTING SUPPORT
Sales : sales @ syslint.com | Call us : (+91)9447607799 | Are you looking for DevOps Admins ?
-
09-01-2011, 12:01 AM #8(formerly WhichGunDotCom)
- Join Date
- Jun 2011
- Location
- Woodbridge, NJ
- Posts
- 840
Yup, permissions problem.
Verify that the user & group MySQL is running under (in most cases both are 'mysql') have permissions to read and write files in /var/lib/mysql.
If not, run these commands (assuming that the MySQL user and group are both 'mysql'):
Code:sudo chown -R mysql:mysql /var/lib/mysql/ib* sudo chmod -R 660 /var/lib/mysql/ib*
-
09-01-2011, 12:04 AM #9(formerly WhichGunDotCom)
- Join Date
- Jun 2011
- Location
- Woodbridge, NJ
- Posts
- 840
If that still doesn't work, check /etc/my.cnf for the value of innodb_data_file_path. That is where MySQL is attempting to write to.
Similar Threads
-
MySQL Cannot Start
By M Nour in forum Dedicated ServerReplies: 11Last Post: 11-01-2010, 05:00 AM -
Cannot get MYSQL to start
By Matt Holme in forum Hosting Security and TechnologyReplies: 3Last Post: 12-15-2006, 01:27 PM -
Where do you start with mySQL?
By Cath in forum Programming DiscussionReplies: 3Last Post: 07-28-2004, 07:33 AM -
RaQ550 and MySQL - MySQL will not start
By BooBoo in forum Dedicated ServerReplies: 19Last Post: 03-08-2003, 07:11 AM -
how to get mysql to start again
By enrique in forum Dedicated ServerReplies: 6Last Post: 01-21-2002, 01:05 PM