356 reputation
516
bio website dotancohen.com
location
age 37
visits member for 3 years, 4 months
seen 2 days ago

Dec
10
awarded  Notable Question
Dec
9
comment Cannot ALTER TABLE
Sure enough, the issue was disk space. Thanks.
Dec
9
accepted Cannot ALTER TABLE
Dec
9
comment Cannot ALTER TABLE
@Michael-sqlbot: Thank you. I understand that rebooting an EC2 instance does move it, so I assumed that is valid for RDS as well.
Dec
8
comment Cannot ALTER TABLE
Yes, I think so too. However the console shows that there is space. I've now filed an issue with Amazon support.
Dec
8
comment Cannot ALTER TABLE
Thank you, in fact I did try this. I could make the new table, but in populating it I get the error he table 'replacement_tasks' is full.
Dec
8
comment Cannot ALTER TABLE
Thank you. When I try to repair the table I get the message The storage engine for the table doesn't support repair. And since this is a managed server in RDS, I cannot access the configuration file.
Dec
8
asked Cannot ALTER TABLE
Nov
24
awarded  Popular Question
Sep
12
awarded  Popular Question
Sep
11
accepted ON DUPLICATE KEY UPDATE faster than UPDATE
Aug
24
accepted Set MySQL option to restore MySQL server after deleting ibdata1
Aug
24
comment Set MySQL option to restore MySQL server after deleting ibdata1
Thank you. I've bitten the bullet and installed an older version of the OS (Ubuntu 12.04). Thank you, I have learned much from this post.
Aug
18
comment Cannot configure nor start MySQL
Yes, of course! Only the grep process itself shows up.
Aug
18
comment Cannot configure nor start MySQL
Thanks. In fact, mysqld_safe dies right away: 40818 16:52:52 mysqld_safe Logging to '/var/lib/mysql/bruno.err'. , 140818 16:52:52 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql , 140818 16:52:54 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended.
Aug
18
comment Cannot configure nor start MySQL
Thank you. I completely removed any trace of 5.6, rm'ed both /var/lib/mysql and /var/log/mysql. The mysql_install_db command failed because resolveip was not found. I then installed mysql-server-5.5 (which apparently is not installed along with mysql-server-core-5.5) to get resolveip. During the install of mysql-server-5.5 I got the Unable to set password for the MySQL "root" user error again, back to square one!
Aug
18
comment Cannot configure nor start MySQL
Actually, I would prefer 5.6 and I don't use eclipse.
Aug
18
comment Cannot configure nor start MySQL
Thank you, if I cannot get through this then I'll try the instructions that you link to.
Aug
18
comment Cannot configure nor start MySQL
@Vérace: No, there is neither my.cnf nor .my.cnf in /home/dotancohen.
Aug
18
revised Cannot configure nor start MySQL
added 4570 characters in body