Skip to main content
prosoxi.com
  • Programming
    • ASP / ASP.net
    • .htaccess
    • PHP
    • JavaScript – Ajax
    • Facebook
    • HTML – XHTML
    • MySQL
    • node js
    • CSS
    • SEO
    • Flash
  • Mobile / Tablet
    • ionic framework
    • Android
    • cordova
    • ios
  • Graphics
    • After Effects
  • OS
    • Windows
    • MAC
    • Linux
  • Network
    • Trixbox
    • Plesk
    • Dreambox
  • News
    • Hack
    • Tutorials
    • Tips & Tricks
    • promo codes

Category: MySQL

How to set time zone of mysql?

September 26, 2014September 26, 2014 Prosoxi.com Webmaster Leave a comment

in the file “my.cnf” in the [mysqld] section default_time_zone=’+00:00′

Read More

Cannot load from mysql.proc. The table is probably corrupted

September 18, 2014September 18, 2014 Prosoxi.com Webmaster Leave a comment

After upgrading MySQL from version 5.0 to 5.5 I started getting the following message trying to edit table structure in Navicat:

Read More

Sorting a VARCHAR column as FLOAT using the CAST operator

June 10, 2014June 10, 2014 Prosoxi.com Webmaster Leave a comment

Solution 1 SELECT guid, number FROM table ORDER BY number * 1 DESC  

Read More

Plesk 11.0 to 11.5 Upgrade

March 7, 2014March 7, 2014 Prosoxi.com Webmaster Leave a comment

ERROR while trying to upgrade APSC SQL database from 11.1.0

Read More

mysql unknown variable ‘init_connect=set names utf8’

October 3, 2013October 2, 2013 Prosoxi.com Webmaster Leave a comment

To set the default to UTF-8, you want to add the following to my.cnf

Read More

mysql cli dump and repair commands

October 2, 2013October 2, 2013 Prosoxi.com Webmaster Leave a comment

some usefull mysql commands for cli

Read More

Posts navigation

1 2 … 12 Older posts

Archives

  • May 2018
  • October 2017
  • August 2017
  • July 2017
  • February 2017
  • January 2017
  • November 2016
  • August 2016
  • July 2016
  • June 2016
  • February 2016
  • November 2015
  • October 2015
  • June 2015
  • May 2015
  • March 2015
  • February 2015
  • December 2014
  • November 2014
  • October 2014
  • September 2014
  • June 2014
  • May 2014
  • April 2014
  • March 2014
  • February 2014
  • January 2014
  • December 2013
  • November 2013
  • October 2013
  • September 2013
  • August 2013
  • July 2013
  • June 2013
  • May 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • December 2012
  • November 2012
  • October 2012
  • September 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
  • March 2012
  • February 2012
  • January 2012
  • December 2011
  • November 2011
  • October 2011
  • September 2011
  • August 2011
  • July 2011
  • June 2011
  • May 2011
  • April 2011
  • March 2011
  • February 2011
  • January 2011
  • December 2010
  • November 2010
  • October 2010
  • September 2010
  • August 2010
  • July 2010
  • June 2010
  • May 2010
  • April 2010
  • March 2010
  • February 2010
  • January 2010
  • December 2009
  • November 2009
  • October 2009
  • September 2009
  • August 2009
  • July 2009
  • June 2009
  • May 2009
  • April 2009
  • March 2009
  • February 2009
  • January 2009
  • December 2008
  • November 2008
  • October 2008
  • September 2008
  • August 2008
  • July 2008

Meta

  • Log in
  • Programming
    • ASP / ASP.net
    • .htaccess
    • PHP
    • JavaScript – Ajax
    • Facebook
    • HTML – XHTML
    • MySQL
    • node js
    • CSS
    • SEO
    • Flash
  • Mobile / Tablet
    • ionic framework
    • Android
    • cordova
    • ios
  • Graphics
    • After Effects
  • OS
    • Windows
    • MAC
    • Linux
  • Network
    • Trixbox
    • Plesk
    • Dreambox
  • News
    • Hack
    • Tutorials
    • Tips & Tricks
    • promo codes
sparkling Theme by Colorlib Powered by WordPress