How TECH

Using in the Azure Database for MySQL server Got the error 1  when I tried to migrate the database ERROR 1030 (HY000) at line   Got error 1 from storage engine Why? https://blogs.msdn.microsoft.com/azuresqldbsupport/2017/06/08/azure-database-for-mysql-cant-restore-database-with-error-got-error-1-from-storage-engine/ "Got error 1 from storage engine" While indicated to be a storage capacity issue on a MySQL server when researching this error, in Azure Database for MySQL this error is most commonly seen when the MyISAM storage engine is being used. Currently, MyISAM is not supported on Azure Database for MySQL. In this scenario, you will need to modify the tables to utilize a supported engine such as InnoDB. This is the engine that Azure Database for MySQL uses by default. This article Converting MyISAM to InnoDB will help you understand the implications of changing from MyISAM and the suggested conversion steps to InnoDB. The most common method is t...

Mysql Error connections. ERROR 9002 (28000): The connection string may not be right. Please visit portal for references. OR ERROR 9999 (28000): An internal error has occurred. Please retry or report your issues.

"How to" aumentando o tamanho máximo de upload para base SQL no phpmyadmin. Ambiente Ubuntu Server 14.04 php5 apache2 e Mysql5.6. Como o phpmyadmin está ligado as configurações web do PHP, o aumento do tamanho máximo de upload é geral para todos os itens que trabalha junto com o PHP5. Abra o arquivo php.ini sudo vim /etc/php5/apache2/php.ini Procure a linha max file *(para procurar dentro do arquivo de configuração utilize a /"oque procura" e enter) ; Maximum allowed size for uploaded files. ; http://php.net/upload-max-filesize upload_max_filesize = 2M No nosso exemplo aumentamos de 2MB para 50MB (sim tem clientes com base maiores que 2MB) Procure a linha post e edite! post_max_size = 8M Salve a configuração saia do arquivo, execute o restart do apache sudo service apache2 restart Verifique dentro do phpmyadmin