The Helpdesk For I.T. Administrators
This howto guide will step you through how to restore a MySQL database from a backup file, using the MySQL client command line tools on a Linux machine. Backing up databases is important, but it is useless if you don’t know how to restore the backup. Regular restores should be done to ensure that your …
This howto guide will step you through how to backup a MySQL database using the MySQL client command line tools on a Linux machine. Backing up databases should be done regularly to prevent any data loss due to disk crashes, data corruption, accidental deletion, etc. The more use the database gets, the more regularly the …
This howto outlines the steps to optimize a MySQL table, and shrink the physical file size of the file. This can be useful if you have removed a large number of records from a table, but the actual file size of that table on the disk hasn’t changed.
A default installation of MySQL server on a Linux machine will only listen for connections on the local interface (localhost or 127.0.0.1), so any remote connections can not be established. This how to article outlines the steps to change the configuration to listen on a specific, or all interfaces on the machine.
This howto will outline the steps to create a new blank MySQL database.
If you have a existing MySQL user account that you want to grant permissions to for a specific database, this howto will outline the steps required.
This howto outlines the steps to add a new user to MySQL, and grant the new user permissions on a specific database.
The Microsoft SQL database server supports the use of Triggers on its tables. Triggers are a special kind of stored procedure that can be executed when records in a table are either inserted, updated, or deleted.
The Firebird database engine supports the use of Triggers on its tables. Triggers are basically a set of SQL scripts that can be executed when data in a table is either inserted, updated, or deleted. Sometimes you may want to temporarily disable a trigger without completely removing it. The steps to do this, and enable …
After making structure changes to a database table, you need to update any views that may be using those tables, otherwise the views may reference the wrong field, and cause all sorts of issues. The T-SQL script below will refresh all views on a database. Run this in a new query window in Microsoft SQL …