Databases

1 comment on "ManageEngine ServiceDeskPlus MSP: Change Starting Request ID (Postgres)"

The procedure to change the request ID for ServiceDeskPlus MSP product (v10.5 and later) is outlined below. Navigate to the location of ServiceDeskPlus MSP installation and change into the pgsql\bin directory in a command prompt. C:\ManageEngine\ServiceDeskPlus-MSP\pgsql\bin> psql -U sdpadmin -p 65432 -d servicedesk -h 127.0.0.1 Enter the password sdp@123 Queries for the respective modules: REQUEST…

Read More ManageEngine ServiceDeskPlus MSP: Change Starting Request ID (Postgres)
0 comments on "ServiceDesk Plus MSP 10.5 Postgre SQL password"

The latest release of ManageEngine ServiceDesk Plus MSP changes the default user and password of the Postgres SQL database. Previously, the command to connect to the database was: psql -U postgres -p 65432 -d servicedesk -h 127.0.0.1 The new change shows that there is a change in username and password as follows: psql -U sdpadmin…

Read More ServiceDesk Plus MSP 10.5 Postgre SQL password
0 comments on "WordPress SQLite to MySQL Migration Complete"

Just finished migrating my website from SQLite to MySQL. What a rush. (lol) It was actually not as bad as I thought. A lot of sed, grep and other sorcery involved; especially in transforming of SQLite statements to MySQL. Some quick commands I used: sqlite techish.db .dump > production_2018-08-23.dump.sql I found that it used quotes…

Read More WordPress SQLite to MySQL Migration Complete
0 comments on "SQL Server 2016 SP1 Edition Limit Changes"

Microsoft made the following changes in their documentation (see screenshot above) to accurately reflect the memory limits on lower editions of SQL Server. Edition Information:  https://www.microsoft.com/en-us/sql-server/sql-server-editions Estimate Memory Requirements for Memory-Optimized Tables Key Points The limits for In-Memory OLTP data is per database. The limits for Columnstore segment cache is per SQL Server instance across all the…

Read More SQL Server 2016 SP1 Edition Limit Changes
0 comments on "Change WordPress Password using MySQL"

If the Forgot password option doesn’t work for you (which it really should), then you can change the password of your self-hosted WordPress login. Check the contents of wp-config.php for the database login. Use that login information for MySQL login. define(‘DB_NAME’, ‘wpdatabase’); define(‘DB_USER’, ‘wpdbuser’); define(‘DB_PASSWORD’, ‘wpdbpassword’); Replacing DB_USER and DB_NAME from that command with the…

Read More Change WordPress Password using MySQL
0 comments on "Calculate Date Differences in MySQL"

There is a function in MySQL that will calculate the number of days between two given dates:  datediff Example mysql> select datediff(‘2014-06-09′,’2014-07-07’); +———————————————-+ | datediff(‘2014-06-09′,’2014-07-07′) | +———————————————-+ | -28 | +———————————————-+ 1 row in set (0.00 sec) Calculate Days Between Now and Specific Date mysql> select datediff(now(),’2014-07-01′); +——————————+ | datediff(now(),’2014-07-01’) | +——————————+ | 6 |…

Read More Calculate Date Differences in MySQL