giovedì, Settembre 16, 2021
Advertisement

SQL – the ‘PRIMARY’ filegroup is full

Di seguito la risoluzione ad un problema che mi è recentemente capitato soprattutto con ambienti SQL di tipo Express: "Could not allocate space for object 'X' in database 'Your Datase' because the...

SQL 2005 – Migrate Express edition to Std edition

Microsoft so very graciously provides a free version of SQL 2005, SQL Express, with MOSS. If you install MOSS using the Basic option or Single Server under Advanced you get SQL...

How to increment the Mysql 5.5’s max_connections value on RHEL 5

Default limit of 214 connections. mysql show variables like 'max_connections'; +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | max_connections | 214 | +-----------------+-------+ 1 row in set (0.00 sec) The problem is that the maximum...

MySQL – modifica dell’engine su ogni tabella

Di seguito la procedura per eseguire la modifica dell'Engine per le tabelle presenti nel nostro DB (in questo esempio modificheremo l'Engine da MyISAM a InnoDB). La procedura non è automatica, occorre...

mysqldump: Got packet bigger than ‘max_allowed_packet’ bytes

When you dump table data from MySQL, you may end up pulling a large chunk of data and it may exceed the MySQL client’s max_allowed_packet variable. If that happens, you might...

SQL Server Setup failure. The SQL Server license agreement cannot be located for the...

Nel caso vi imbattiate nel seguente errore durante l'installazione di un SQL Server.... TITLE: SQL Server Setup failure. ------------------------------ SQL Server Setup has encountered the following error: The SQL Server license agreement...

How-to – Manage Multiple MySQL Servers using PHPmyAdmin

Download PHPmyAdmin PHP source at http://www.phpmyadmin.net/home_page/downloads.php . In this case, I will download this version phpMyAdmin-3.4.7-english.tar.gz. I assume you download the installer under /usr/local/src directory. We will need to rename the folder and...