How to increase phpMyAdmin upload file size limit in ISPConfig 3?

phpMyAdmin showing an upload limit of 2MB
phpMyAdmin showing an upload limit of 2MB

 

This is a crappy problem, especially when importing & exporting large databases.

To increase the upload file size limit for phpMyAdmin, we’ll need to modify the php settings (php.ini) that it uses on your ISPConfig installation.

  1. Open up your terminal and SSH into your server.
  2. Now run nano to edit your php settings.
    sudo nano /etc/php5/apache2/php.ini
  3. Using Ctrl+W , search for:
    upload_max_filesize
  4. And set it to:
    upload_max_filesize = 64M
    Where 64M means, an upload limit of 64MB.

    nano showing search for upload_max_filesize
    nano showing search for upload_max_filesize
  5. Next, search for:
    post_max_size
  6. And set it to:
    post_max_size = 64M
  7. Save your changes by hitting Ctrl+O and then Y.
  8. Finally, restart apache.
    service apache2 restart

How to remove the Sticky Menu in Genesis Theme, Magazine Pro, the right way?

You know that menu that appears when you scroll down a little or a bit? Yes, this line of code will stop it from appearing.

remove_action( 'wp_enqueue_scripts', 'sp_enqueue_script' );

Add it to the template or function page, and after that, it should stop appearing.

How to fix Chrome Developer tools not showing the correct width (or height?)

Chrome Developer Tools showing width and height of page
Chrome Developer Tools showing width and height of page

Notice your width and height not showing accurate values, and affecting your CSS and/or Javascript work? The latest versions of Chrome (as of 52.0.2743.116) might have this little bug.

To resolve, simply zoom in and out on your current window/page. Hold on to Ctrl while scrolling the mousewheel up or down.

The values should now show working and usable ones.

Alternately, you can use a Chrome Extension that simply does this for you accurately.