Home / Tag Archives: database

Tag Archives: database

July, 2010

  • 12 July

    Troubleshooting Database Connections

    database connection error

    When MySQL works correctly, it can be a thing of beauty, but when something goes wrong, it can drive you mad. Here are a few things you can do to troubleshoot connection problems: 1. Make sure your username and password are correct. 2. Double-check the hostname. Although “localhost” works on …

  • 8 July

    How to Search a MySQL Database

    With web-based control panels and web software like phpMyAdmin, you have numerous options available for searching a MySQL Database. If the need should ever arise where those tools are not available, however, it is a good idea to know how to search a database from the command line. To search …

  • 2 July

    MySQL Optimization: Part 2

    1. Query cache – On most servers, there are certain MySQL queries that you and/or your scripts will run more often than others. In fact, you may run the same query hundreds or even thousands of times in a single day. The query_cache setting will save the most used queries …

June, 2010

  • 30 June

    MySQL Server Optimization

    If you are running a dedicated server, optimization is very important to maximize speed, efficiency, and save time and energy. We have already looked at ways to optimize Apache web server, but many dynamic websites also use databases that hold the data for their dynamic web applications. You can accomplish …

May, 2010

  • 19 May

    MySQL Enterprise Released

    Monday, the database giant, Oracle, announced the release of MySQL Enterprise. In addition to the standard, freely available database software, this new packaged version of MySQL will include comprehensive support and monitoring tools. The primary tool available with this release is MySQL Monitor 2.2, which monitors performance and security. Other …

  • 6 May

    SQLite for Your Database Needs

    In the web hosting world, certain database software is commonplace. Most system administrators, even the new ones, have heard of MySQL, MSSQL, and/or PostgreSQL. Using SQL databases typically requires a database server to be running on the system. MySQL, for example, runs as a service in Linux called mysqld, or …

April, 2010

  • 28 April

    PHP: How to Select Multiple Database Tables

    Selecting a MySQL database table with a PHP document is a quick way to get certain output onto a web page with very little coding or effort. You may want nothing more than a simple printout of the database table or something more complex like a full web application. Regardless …

  • 19 April

    How to create a table using phpMyAdmin

    After you create a MySQL database, the next thing you will most likely want to do is to fill it with data. To do that, you need to setup tables. If you are installing a content management system or other type of script with an installer, it will probably create …

  • 14 April

    How to create a database in phpMyAdmin

    In a previous post, we learned how to create a MySQL database from the Linux command line. Today, we will learn how to accomplish the same task with a graphical interface using the free web-based MySQL administration tool: phpMyAdmin. Just follow these steps. 1. Login to phpMyAdmin either through your …

  • 12 April

    Finding Linux files with "locate"

    There are a few of ways to find files on a Linux server, but most of them involve actually searching through each file in the filesystem until the correct one is located. This can be time consuming and taxing on the server’s CPU load, especially if you have a lot …

Powered by Namesco
© Copyright InternetBlog.Org.Uk 2024, All Rights Reserved