If you have faced a problem when importing your data to MySQL from a large file and it said:
ERROR 1118 (42000) at line xxx: Row size too large (> 8126)
This is a known bug for MySQL versions 22.214.171.124, 126.96.36.199 and I noticed that I didn’t have this problem at version 5.6.24.
In order to make it work also on MySQL 188.8.131.52 edit your “my.ini” configuration file and increase the innodb log size like this:
innodb_log_file_size = 256M
Hope it solves you the problem, like it helped me, one beer is always welcomed :-).
There are a lot of system stuff that just eat important space in Windows on disk C (if you have SSD and smaller C partition you don’t want to run out of space).
The best way is to create a junction (symbolic link) and to move some big folder to another partition (you need to have one first).
By doing this Windows will be fooled because you will get the same path but it will be shortcut (pointer) to another real location.
To do this move completely chosen folder to another partition and create symbolic link like this:
mklink /j c:\windows\MyMovedFolder d:\MyMovedStuff\MyMovedFolde
Summer vacation is coming in a few months. Ever been in Corsica? You should go to see it if you didn’t.
It is a beautiful island with amazing beaches, villages and mountains. Ajaccio, born place of Napoleon, has the best city beach I have seen in my life. Usually you try to avoid them.
The best beach on island is Capo di Feno. Don’t miss to visit Bonifacio.
Here are some photos…
You need to be in the centre of these circles.
Ikigai is a Japanese concept meaning “a reason to get up in the morning”, that is, a reason to enjoy life.
(Source: found somewhere in Facebook posts)
To solve this in your Entity database this is what you need to do:
- Double click on edmx file to open diagram
- Right mouse click > Model browser
- [Your database] > EntityContainer > Function Imports
- Delete problematic Function import
Sometimes you want to create folder alias for your website like this: /images to be mapped to /home/your_account/public_html/images.
To do this, you need to edit Apache httpd.conf file which is located at /etc/httpd/conf
It is clever to put all aliases in one file in the same directory and name them aliases.conf and then only to reference this file from httpd.conf.
You will include aliases.conf in httpd.conf like this:
You define alias in aliases.conf file like this:
Alias /images /home/your_account/public_html/images
Options Indexes FollowSymLinks ExecCGI Includes
Allow from all
- Copy original (default) CPanel php.ini file from location: /usr/local/lib/php.ini to your account folder: /home/account_username/path_to_php_ini/
- Add the following code to the .htaccess file within your account’s public_html folder: suPHP_ConfigPath /home/account_username/path_to_php_ini/
- Change this php.ini file to suits your needs and That’s all folks!
replace everywhere ‘/home/account_username/path_to_php_ini/‘ with the appropriate path to your custom php.ini file)