Get size of all databases and tables in MySQL
Code first: This simple SQL query will return the size of all databases of your MySQL Server, listing the largest…
Category: SQL
Insufficient access rights error when doing backup
All of sudden SQL Server Management studio gives me the following error message when I’m trying to browse for the…
How to transfer logins and passwords between instances of SQL Server
To transfer logins and passwords between different versions of SQL Server, follow these steps: Run the following script on the…
Fix: Cannot load from mysql.proc. The table is probably corrupted
After upgrading MySQL from version 5.0 to 5.5 I started getting the following message trying to edit table structure in…
How to Back Up and Restore a MySQL Database
If you’re storing anything in MySQL databases that you do not want to lose, it is very important to make regular…
Structured Query Language (SQL)
Structured Query Language (SQL) SQL is a computer language aimed at accessing, manipulating, and querying data stored in relational databases.…
Determine MYSQL Version From the Command Line
Determining MySQL version is not very difficult but the command line is a quick trick and its useful. Once you…
Microsoft Access Specifications and Limitations
Just as any application, MS Access has specifications and limitations that should be remembered. The following tables specify the maximum…