in MySql
Error: MySQL shutdown unexpectedly. 11:11:48 AM [mysql] This may be due to a blocked port, missing dependencies, 11:11:48 AM [mysql] improper privileges, a crash, or a shutdown by another method. 11:11:48 AM [mysql] Press the Logs button to view error logs and check 11:11:48 AM [mysql] the Windows Event Viewer for more clues 11:11:48 AM […]
in MySql
A database is represented by a directory under the data directory (usually /var/lib/mysql), and the directory is intended for storage of table data. The DROP DATABASE statement will remove all table files and then remove the directory that represented the database. It will not, however, remove non-table files, whereby making it not possible to remove the directory. MySQL […]
in MySql, Tips and Tricks
1101 – BLOB, TEXT, GEOMETRY or JSON column ‘answer’ can’t have a default value Probably your development environment allows the defaults and the production environment doesn’t. You can either upgrade your production system or not use that feature. How to disable strict mode in MySQL 5 (Windows): Edit /my.ini and look for linesql-mode=”STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION” Replace it […]
in MySql, Tips and Tricks
MySQL/MariaDB related: wait_timeout – Time in seconds that the server waits for a connection to become active before closing it. interactive_timeout – Time in seconds that the server waits for an interactive connection. max_allowed_packet – Maximum size in bytes of a packet or a generated/intermediate string. Set as large as the largest BLOB, in multiples of 1024. Example […]
in Laravel, MySql, Tips and Tricks
They do the SQL DATE() work for you, and manage the differences of SQLite. Your result can be achieved as so: Though the above method is convenient, as noted by Arth it is inefficient on large datasets, because the DATE() SQL function has to be applied on each record, thus discarding the possible index. Here are some ways to […]
in MySql, Technology
Digitalocean DigitalOcean is a values-driven organization. Here is what we believe in. Our community is bigger than just us We foster the global developer and entrepreneurial communities because they are the source of our ideas and innovation and essential to our sustained growth. Simplicity in all we DO We make decisions that eliminate complexity and […]
You must be logged in to post a comment.