MySQL

Linux Web Hosting 

PhpMyAdmin MySQL Table Export SQL Format Missing

webmaster 2332 Views 0 Comments , , ,

PhpMyAdmin MySQL Table Export SQL Format Not Available phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web, it’s a very popular tool included with many server control panels such as Plesk and cPanel.  Recently an incident was sent my way where a large customer was advising the ability to export single MySQL tables within PhpMyAdmin was no longer providing the expected SQL format by default. In fact,

Read more
Linux Web Hosting 

MySQL Buffered warning: Changed limits: max_connections: 214 (requested 800)

webmaster 2658 Views 0 Comments ,

This is always an interesting one, comes up from time to time especially if you run a server with heavy database traffic. Possibly you’ve modified you my.cnf with various tweaked settings for ‘max_connections’ or ‘open_files_limit’ but your your ‘mysqld.log’ you start getting: [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000) [Warning] Buffered warning: Changed limits: max_connections: 214 (requested 800) [Warning] Buffered warning: Changed limits: table_open_cache: 400 (requested 2000) What gives ? Well the values

Read more