Category Archives: MySQL

Some MySQL Stuff

Linux: Install LAMP Stack on Debian 10 (Buster)

Hi ,

this post describes the steps to install a lamp stack on debian linux. This is the base for many content management systems like Joomla, WordPress or Drupal.
Continue reading Linux: Install LAMP Stack on Debian 10 (Buster)

MySQL, MariaDB: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Hi,

I use a powershell script to write some data to a MySQL Database table.

The time the script is running increases every day and the point is reached were it runs in an timeout 🙁
Continue reading MySQL, MariaDB: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

MSSql: Database cannot be opened. Marked as suspected

Hi,

the WSUS DB (MSSQL Express 2005) of a customer won’t start after a hardware failure and bluescreen. Here are the steps which recovers the database back in an usable state.

The SQL Server Instance logs errors like this

"Could not redo log record (183366:6166:54), for transaction ID (0:117029942), on page (1:657511), database 'SUSDB' (database ID 5). Page: LSN = (183267:2976:260), type = 2. Log: OpCode = 2, context 3, PrevPageLSN: (183366:1717:287). Restore from a backup of the database, or repair the database."


in “C:\Windows\SYSMSI\SSEE\MSSQL.2005\MSSQL\LOG\ERRORLOG” and the database is down.

First connect to the DB Instance using a named pipe


c:\> sqlcmd -S np:\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

Continue reading MSSql: Database cannot be opened. Marked as suspected

Powershell: Some examples to use a MySQL Database

Hi,

sometimes it makes sence to write Data in a “real” Databasesystem instead of writing to a text- or xml file.

MySQL offers an native Windows .NET Connector to its Database. You can get it here.

Continue reading Powershell: Some examples to use a MySQL Database