Tag Archives: MySQL

Incremental Backup in MySQL

To get a consistent backup, do a LOCK TABLES on the relevant tables, followed by FLUSH TABLES for the tables. You need only a read lock; this allows other clients to continue to query the tables while you are making … Continue reading

Posted in MySQL | Tagged , , , , , , , , , , | Leave a comment

Hibernate Development Environment

Hibernate Development Environment Obtain Hibernate https://www.hibernate.org/ Locate the Download link in the left navigational bar. Click it to bring up the download page. Download compressed file & extract it. Add Hibernate’s dependencies to the classpath; they’re distributed along with Hibernate … Continue reading

Posted in Hibernate | Tagged , , , , , , , | Leave a comment

Why ORM Frameworks?

Why ORM Frameworks We are forced to download data from a database many times, transfer them to an application and save the data converted by a system to a database. It is obviously possible to do it using SQL and … Continue reading

Posted in Hibernate | Tagged , , , , , , , | Leave a comment

Open Source ILS: Installation Guide for Koha on Ubuntu 11.10 or Ubuntu 11.04 or Ubuntu 10.10 or Ubuntu 10.04 LTS with MySQL 5

According to Wikipedia.com, An integrated library system (ILS), also known as a library management system (LMS), is an enterprise resource planning system for a library, used to track items owned, orders made, bills paid, and patrons who have borrowed. An … Continue reading

Posted in How To..., MySQL, Ubuntu, What is? | Tagged , , , , , , , , , , , , | 17 Comments

MySQL-Executing SQL Statements from a .sql File

However, it is also possible to put your SQL statements in a file and then tell mysql to read its input from that file. If you are already running mysql, you can execute an SQL script file using the source … Continue reading

Posted in How To..., MySQL | Tagged , , , , , , , , , | Leave a comment

Solution of Error in MYSQL installation on Ubuntu

Error Solution sudo apt-get update sudo apt-get dist-upgradesudo apt-get install mysql-server

Posted in How To... | Tagged , , , , , , , | Leave a comment

Install phpMyAdmin on Ubuntu 11.10 or Ubuntu 11.04 or Ubuntu 10.10 or Ubuntu 10.04 LTS

phpMyAdmin is an open source tool written in PHP intended to handle the administration of MySQL with the use of a Web browser. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing … Continue reading

Posted in How To..., Ubuntu | Tagged , , , , , , , , , , , , | 1 Comment

Install PHP 5 on Ubuntu 11.10 or Ubuntu 11.04 or Ubuntu 10.10 or Ubuntu 10.04 LTS

PHP is a general-purpose server-side scripting language originally designed for web development to produce dynamic web pages. For this purpose, PHP code is embedded into the HTML source document and interpreted by a web server with a PHP processor module, … Continue reading

Posted in How To..., Ubuntu | Tagged , , , , , , , , , , | 1 Comment

Install MySQL Server on Ubuntu 11.10 or Ubuntu 11.04 or Ubuntu 10.10 or Ubuntu 10.04 LTS

MySQL is a relational database management system (RDBMS)that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius‘ daughter, My. The SQL phrase stands for Structured Query Language. Free-software-open source projects … Continue reading

Posted in How To..., Ubuntu | Tagged , , , , , , , , , , | 4 Comments

Magento(Any) Database Backup by PHPMyAdmin

Enable phpMyAdmin By default, you can only access phpMyAdmin from the same computer. You can enable it by editing the “opt/bitnami/apps/phpmyadmin/conf/phpmyadmin.conf” file: Alias /phpmyadmin “/installdir/apps/phpmyadmin/htdocs” installdir/apps/phpmyadmin/htdocs”> AuthType Basic AuthName phpMyAdmin AuthUserFile “/installdir/apache2/users” Require valid-user Order allow,deny Allow from all  #Change … Continue reading

Posted in Private Cloud | Tagged , , , , , , , | 1 Comment