A few links to SQL tutorials -
SQLCourse has been around for sometime. With Microsoft’s DreamSpark, students can download SQL Server to build databases and to learn how to retrieve data by performing queries (basically asking the database for specific data). SQLCourse gives you step by step instructions on how to run these queries.
If you are a beginner or an expert, MySQL Workbench is a must have if you have installed MySQL. The community edition allows you to Start/Stop your MySQL instance, write queries, monitor performance and has dozens of other features.
With MySQL, the my.conf file normally found in Linux installs is the my.ini file. This configuration file can be found under the ProgramData folder (you have to show hidden files in Windows Explorer to see it). This file can be configured using MySQL Workbench. If you get an error connecting to it, go to the server instance and navigate to the my.ini file. This is a common error when reading the configuration file.
Other features -
SQL Editor – SQL Code Completion, SQL Code Formatter, SQL Syntax Highlighting, SQL Code Generation, SQL History, SQL Snippets, Server-Stop/Start, Server Status, Performance and more.
Dawn and I faced a MySQL Upgrade for our Moodle LMS site and delayed as long as we could. Unlike traditional upgrades of Microsoft SQL, we couldn’t simply click a setup file and the upgrade would replace files and services as needed.
Here’s the easiest process we found to upgrade MySQL
- Stop the existing MySQL service in Services
- Make sure you have a backup of you MySQL database
- Open a command prompt (as administrator)
- change to the MySQL directory and type mysqld –remove (to remove the service under services) you can also remove it by using the SC Delete MySQL command.
- In the Service manager you should see that the service is removed.
- Uninstall MySQL under the Programs and Features menu
- Delete all folders under programdata and program files that are related to MySQL
- Make sure the latest .NET Framework is installed
- Download and run the MySQL Community package Link
- Perform a new install
- Use the Server type: Server (Production deployments)
- Make sure your data directories are specified during the installation
- Use the same root password you had on the old installation
- Add admin users as necessary
- Restore your files if necessary (backups) with MySQL Workbench Link
- Complete the install
- Make sure the service is running
Note: Always make a backup before trying to update the database.
Server 2008 R2
- install Wincache by Microsoft
Edit the my.ini file found in the MySQL installation
- Set the innodb_buffer_pool_size=1G Resource
- Set the Max_Allowed_Packet = 100M
- Set Key_Buffer_Size=512M
- Set query_cache_size = 128MB
query_cache_limit = 4MB
- tmp_table_size = 64MB
Adjust your settings accordingly.
Note: Many of these settings can be made to the my.cnf file in Linux installations
Our performance increast? 50% savings on average (load times)
If you receive the error “!!!Error Writing To Database!!!” during a cron backup, this can be related to
Find the my.ini file which is normally located in the MySql folder under program files
(C:\Program Files\MySQL\MySQL Server 5.1). Edit it by adding or modifying the line -
Max_Allowed_Packet = 100M (adjust as necessary)
Vulnerability is so easily attacked and so prevalent that we’re bound for a bump in database exposures….Expect A Surge In Breaches Following MySQL Vulnerability – Dark Reading.