Tag: mysql

MySQL not starting – unknown variable table_cache

I’ve upgraded my dev server to latest version of Debian. Everything was going smoothly until I’ve got an error from mysql-server that it cannot be installed due to an error. I checked few websites that I have there running and all of

It's only fair to share...Buffer this pageShare on FacebookTweet about this on TwitterShare on Google+Share on LinkedInShare on RedditPin on PinterestEmail this to someone
Posted in Servers, Unix Tagged with: , , ,

Consistent dates in PHP?

It’s really interesting how small changes in core PHP functionality could break whole website and take hours to find the cause of the bug. I am building website which takes some use of dates, stored in MySQL database as Date

It's only fair to share...Buffer this pageShare on FacebookTweet about this on TwitterShare on Google+Share on LinkedInShare on RedditPin on PinterestEmail this to someone
Posted in PHP Tagged with: , , ,

MySQL – Delete/Drop all tables with specific prefix

MySQL is great database especially for small and mid size web applications. You can do loads of stuff with it but not everything is possible with regular SQL query. Imagine you have a database and you want to delete set

It's only fair to share...Buffer this pageShare on FacebookTweet about this on TwitterShare on Google+Share on LinkedInShare on RedditPin on PinterestEmail this to someone
Posted in Small Tips, SQL Tagged with: , , ,