0
votes
0answers
11 views

MYSQL Incomplete trigger

BEGIN IF (NEW.chik_updates = 'y') THEN UPDATE chik_subscriptions SET sub_additions = sub_additions + 1; ELSE UPDATE chik_subscriptions SET sub_removals = sub_removals + 1; END IF; END I have ...
0
votes
0answers
205 views

#2002 Cannot log in to the MySQL server / Connection for controluser as defined in your configuration failed

I use PHP/MySQL in Ubuntu 13. To reduce the size of ibdata1, i followed this post What is the best way to reduce the size of ibdata in mysql? and make necessary changes as told in the answer. I did ...
1
vote
1answer
321 views

wordpress table is crashed and should be repaired

I run a wordprees website and use a managed VPS server with cPanel/WHM. Got bellow error log and check the table. I repaired the table with repair table command from phpmyadmin. But this problem occur ...
0
votes
1answer
39 views

Migrating database with views trough phpMyAdmin causes error in second host

I'm trying to migrate a database which contains some views and I'm doing trough phpMyAdmin export feature. MySQL version on servers are: Server to migrate: Server version: 5.5.34-0ubuntu0.12.04.1 ...