Nick57
- Total activity 63
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 16
Comments
Recent activity by Nick57-
Still not solved, what keeps me puzzled is that this VPS is just a few weeks old, running on STABLE 11.40.1.11 Clean install no problems, then suddenly over night high load and running out of memor...
-
Yes, some errors about charactersets in /etc/my.cnf, i removed the lines which gaves errors... This is the mysql errror log after a mysql restart. 140226 23:56:28 mysqld_safe mysqld from pid file...
-
Re: INNODB issue, tables exist but in phpmyadmin it gives error #1146 Table xxx doesn't exist. Howdy, see above...
-
I would not recommend to do a hotswap, it is more then enough risky to swap from innodb to myisam
-
I had same settings, but an update from cPanel overruled it, as you can see in the nightly updates, it 'tries' to fix any errors in the /etc/my.cnf file, but no idea what 'criteria' they use as bei...
-
You need to add that setting as I have explained, then restart mysql. Sorry, no script, don't want to be responsible for your databases ;-)
-
The new setting is only working after you restart mysql and only effective for new database/tables created. One remark, if the software to create a new DB with tables is NOT expliciet saying what ...
-
For simple reason that many cms are not having set correct relationships in tables, it will break with InnoDB. Perhaps in a few years time when everything is more ready for InnoDb it might be benif...
-
Re: Advanced install, I need to make an exact copy of a cPanel server, but how to do the MySQL versi None of these settings worked, the mysql installed is 5.5, this is a problem, i need to have it...
-
Re: Advanced install, I need to make an exact copy of a cPanel server, but how to do the MySQL versi Sure, From this file the mysql setting did work, which was my main worry so I was pleased with...