Mysql Alter Table Select all Tables

Submitted by CoolGoose on

In case you wanted for eg: change all your innodb tables into myisam, and you didn't want to go over the tables one by one, you can do the following queries.

  1. USE information_schema;
  2. SELECT TABLE_SCHEMA, TABLE_NAME FROM TABLES WHERE TABLE_SCHEMA = "your_table_name";

If it returns what you need ?

  1. SELECT CONCAT("ALTER TABLE `", TABLE_SCHEMA,"`.`", TABLE_NAME, "` ENGINE = MYISAM; ") as MySQLCMD FROM TABLES WHERE TABLE_SCHEMA = "your_table_name";

Technology: 

virtualmin/webmin BIND not starting on CentOS 6.2

Submitted by johnny on

webmin and centos will usually default to bind-chroot installation and webmin will have the chroot paths set for named.conf
for some reason, in my centos 6.2 setup there was a folder permission issue which prevented the pid file from being created.
chmod 770 /var/named/chroot/etc/
and then it started

one more thing to pay attention to. if you setup virtualmin and use the local named for your domains, then you have to set 127.0.0.1 as the first entry in /etc/resolv.conf

Technology: 

Why using "or die()" in PHP is a bad practice

Submitted by CoolGoose on

Daniel wrote a nice article on phpfreaks.com describing why it's bad practice to use "or die()" in your php code.

Reasons such as:

  1. It's not a very nice way to present the user with an error message.
  2. Using for instance the mysql_error() call with it, as many people do, exposes information that should never get output in a production environment
  3. You cannot catch the error in any way.
  4. You cannot log the error.
  5. You cannot control whether it should be output to the screen or not. It's okay to do that in a development environment, but certainly not in a production environment.
  6. It prevents you from doing any sort of cleanup. It just ends the script abruptly.

Technology: 

How to get output of a php function into a variable

Submitted by CoolGoose on

It's pretty simple, and it can be very helpfull when for some reason you need to do a conditional display on an output from a function, but for legacy/compatibility reasons you can't modify that function.

  1. <?php
  2.     ob_start();
  3.     echo 'I like cookies';
  4.     $myStr = ob_get_contents();
  5.     ob_end_clean();
  6. ?>

Technology: 

CSS3 Required input form styling removal

Submitted by CoolGoose on

If you ever wondered how the hell to style/disable the input styling when using the new CSS3 required selectors you can do it with:

  1. input:valid {
  2.     box-shadow:             #0f0 0 0 1.5px 1px;
  3. }
  1. input:invalid {
  2.     box-shadow:             #f00 0 0 1.5px 1px;
  3. }

From my testing, webkit browsers seem to fallback to outline in case box-shadow: is set to none;
So you can use outline: none; to disable that as well.

Technology: 

Pages

Subscribe to