#mysql error

Table is marked as crashed and should be repaired – MySQL Error

Recently I got the following error while working on a php and mysql based application – Table is marked as crashed and should be repaired This error can be easily fixed by doing a repair operation on the table. Repair can be performed in two ways. Using PHP MyAdmin GUIUsing command line In the Phpmyadmin GUI, select the table which has the problem and select the operation repair. This will…

mysqld dead but subsys locked

mysqld dead but subsys locked

Backup for future Safety:

cp /var/lock/subsys/mysqld /root/mysqld

than delete it

rm /var/lock/subsys/mysqld

then close all services that depends on mysql:

service httpd stop and after that:

service mysqld restart service httpd restart

views changed into tables, while restoring mysql database

  In the backup script the views are first created as tables which are then dropped at the end of the script as each view is being created, so it seems that an error occurs while creating the views at the end of the script. However when a view is created there is a user who is used in the DEFINER clause of the view who may not exist in your database, e.g., [email protected].% I usually…

If you get a too many connections error,Error: 1040 SQLSTATE: 08004 (ER_CON_COUNT_ERROR), when you try to connect to the mysqld server, this means that all available connections are in use by other clients. To increase the concurrent connections what are allowed to connect to the server, change the max_connections system variable value. The default value was 100 prior to MySQL 5.1.15. The default…

http://oguzturk.net/kisisel/starting-mysql-error/

Starting MySQL.. ERROR!

ERROR! MySQL server PID file could not be found! Starting MySQL.. ERROR! hatası alanlar aşağıdaki adımları uygulayarak sorunu çözebilirler.

Hata:

ERROR! MySQL server PID file could not be found!

Starting MySQL... ERROR! The server quit without updating PID file (/var/lib/mysql/server.siteadiniz.com.pid).

Hatanın neden kaynaklandığını bulmak için aşağıdaki komutu çalıştırıyoruz.

nano /var/log/mysqld.log

Bende çıkan hata şu şekilde.

Plugin ‘InnoDB’ is disabled.

Eğer sizde logda aynı hatayı görüyorsanız my.cnf dosyanızda ufak bir düzenleme yapmanız gerekiyor. Eğer farklı bir hataysa farklı bir çözüm yolu bulmanız gerekiyor. Aşağıda yer alan komut ile my.cnf dosyasını açıyoruz.

nano /etc/my.cnf

En alt satıra aşağıdaki komutu ekleyip CTRL+X ve ardından E harfine basıp onayladıktan sonra enter tuşuna basarak değişiklikleri kaydediyoruz.

skip-innodb

Yukarıdaki adımları uyguladıktan sonra MySQLi çalıştırdığınızda hata almayacaksınız.

Cpanel için MySQL çalıştırma komutu:

Being a developement team, sometimes you need to do some simulation on your on notebook but to found that during the mysql migration (i'm using command line to do the import) has give me an error 1153. What is 1153 error?, well it basically inform you that during the migration, you have hit the max allowed packet. In layman term, your sql file is too big to be handled by the mysql.

In order to overwrite this limitation, you can opt to make permanent changes to your mysql setting and change the 'max_allowed_packet' variable or if you like me, since this is a temp process, I would use the following opt:

#load mysql

$ mysql -u <user> -p

$ mysql > set global max_allowed_packet=1000000000;

$ mysql > set global net_buffer_length=1000000;

#open another terminal

$ mysql -u <user> -p <database> < your_large_mysql_data_file.sql

I will take sometimes, please wait until the cursor return to your prompt command.