If you ever need to backup all your MySQL databases at the same time use the following command mysqldump -u
Category: Databases
MySQL – “unknown” architecture (Windows)
Problem You need to upgrade your MySQL but the state/status is MySQL 5.x has “unknown” architecture Solution Download and run
MySQL – restore databases (command line – Linux)
Methods of restoring MySQL databases To restore a MySQL database you can use one of the following methods after creating
MySQL – Retrieve “lost” MySQL user name and password (Unix/Linux)
Problem You are trying to log into MySQL but you have the wrong credentials and need admin/root access Solution To
SQL – SSPI handshake failed with error code 0x8009030c (eventid 17806)
Problem Repeated errors in EventLog, eventid 17806 SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection
SQL Server – Max Server Memory
Problem How do you set Max Server Memory? Solution The important factor here is that the buffer pool never acquires
SQL – Review Data Type Mapping (SQL Server Import and Export Wizard)
Article Source: Microsoft TechNet Applies To: SQL Server 2016 If you specified a mapping that’s not valid in the Mappings
MS SQL – Change number of rows to edit
Problem You need to edit many rows (>200) with in the Microsoft SQL Server Management Studio but you are limited
Veeam backup error – File does not exist or locked
Problem Veeam back up of a MSSQL DB server throws the following error (some content changed): Error: Client error: File
WordPress login password reset
Problem You cannot remember your password for your wordpress site, but you do have access to the PHPMySQL admin or