Did You Know?
Got a tip? Let us know

LFCS - Linux Foundation Certified SysAdmin - Exam Preparation Guide

Archive : MySQL

RSS feed

MySQLDumper: A PHP and Perl Based MySQL Database Backup Tool

MySQLDumper: A PHP and Perl Based MySQL Database Backup Tool
MySQL is one of the most popular database in the world. This database can be installed on the Microsoft Windows platform besides of Linux platform. Why this database is so popular? It may caused by its powerful feature and its free to use. As a database administrator, a database backup is really crucial to maintain the availability of the data. It will minimize the risk if something happens to our database. Install MySQLDumper in Linux Since MySQL...
Filed in: Backups, MySQL

4 Useful Commandline Tools to Monitor MySQL Performance in Linux

4 Useful Commandline Tools to Monitor MySQL Performance in Linux
There are plenty of tools to monitor MySQL performance and troubleshoot a server, but they don’t always perfect match for a MySQL developer or administrator’s for their common needs, or may not work in some situations, such as remote or over the web monitoring. MySQL Monitoring Tools Luckily, there are variety of open source tools created by MySQL community to fill the gaps. On the other hand, it’s very difficult to locate these tools...
Filed in: Monitoring Tools, MySQL

Adminer – A Advanced Web Based Databases Administration Tool for Linux

Adminer – A Advanced Web Based Databases Administration Tool for Linux
We always interact with the databases to perform tasks in various way. We may connect directly and execute the tasks using SQL CLI mode or non-DBA user prefer to use GUI tools called phpMyAdmin or phpPgAdmin. Many of us are aware of phpMyAdmin or phpPgAdmin database management tools. This post will talk about yet another database management tool called Adminer. Adminer Database Administration Tool What is Adminer Adminer (Formerly phpMinAdmin) is...
Filed in: MySQL, Open Source

10 MySQL Database Interview Questions for Beginners and Intermediates

10 MySQL Database Interview Questions for Beginners and Intermediates
In our last article, we’ve covered 15 Basic MySQL Questions, again we are here with another set interview questions for intermediate users. As we said earlier these questions can be asked in Job Interviews. But some of our critics on the last article said, that I don’t give response to my critics and the questions are very basic and will never be asked in any Database Administrator Interview. 10 Mysql Job Interview Questions To them...

15 Basic MySQL Interview Questions for Database Administrators

15 Basic MySQL Interview Questions for Database Administrators
Prior to This Article, three articles has already been published in ‘Linux Interview‘ Section and all of them were highly appreciated by our notable readers, however we were receiving feedback to make this interactive learning process, section-wise. From idea to action, we are providing you 15 MySQL Interview Questions. Mysql Interview Questions 1. How would you check if MySql service is running or not? Answer : Issue the command “service...

Install Apache 2.2.15, MySQL 5.5.34 & PHP 5.5.4 on RHEL/CentOS 6.4/5.9 & Fedora 19-12

Install Apache 2.2.15, MySQL 5.5.34 & PHP 5.5.4 on RHEL/CentOS 6.4/5.9 & Fedora 19-12
This howto guide explains you’ll how to install Apache Server with latest MySQL 5.5.32 and PHP 5.5.0 versions with php required following modules on RHEL 6.4/6.3/6.2/6.1/6.0/5.9/5.8/5.6, CentOS 6.4/6.3/6.2/6.1/6.0/5.9/5.8/5.6 and Fedora 12,13,14,15,16,17,18,19 systems using Remi repository via Yum tool. LAMP Setup in Linux What is Apache? Apache is an open source freely available HTTP web server that runs on most UNIX-based operating systems...
Filed in: Apache, MySQL, PHP

MySQL Basic Database Administration Commands – Part I

MySQL Basic Database Administration Commands – Part I
Database is a structured set of data stored electronically. The concept of database was known to our ancestors even when there were no computers, however creating and maintaining such database was very tedious job. In a manual database say of 100 pages, if you have to search for all the employees whose salary were less than 10k, just think how much difficult it would have been, then. In today’s world you just can’t escape Database. Right...
Filed in: MySQL

phpMyBackupPro – A Web Based MySQL Backup Tool for Linux

phpMyBackupPro – A Web Based MySQL Backup Tool for Linux
phpMyBackupPro is an open source very easy to use web based MySQL backup application, written in PHP language released under the GNU GPL. It allows you to create schedule backups, restore and manage them, download, email, or upload backups to any FTP server and lot more. It also takes File directories backup and upload them on a FTP Server. It supports three compression levels of backups (No compression, zip or gzip compression). It also supports...
Filed in: MySQL
This work is licensed under a (cc) BY-NC | TecMint uses cookies. By using our services, you comply to use of our cookies. More info: Privacy Policy.
© 2012-2014 All Rights Reserved.