PHP 5 and later can work with a MySQL database using: MySQLi extension (the “i” stands for improved) PDO (PHP Data Objects) Earlier versions of PHP used the MySQL extension. However, this extension was deprecated in 2012. Open a Connection to MySQL Example: <?php $servername = “localhost”; $username = “username”; $password = “password”; // … Read more
What is Indexing? A database index is a data structure that improves the speed of operations in a table. Indexes can be created using one or more columns, providing the basis for both rapid random lookups and efficient ordering of access to records. While creating index, it should be considered that what are the columns … Read more
Running and Shutting down MySQL Server: First check if your MySQL server is running or not. You can use the following command to check this: ps -ef | grep mysqld If your MySql is running, then you will see mysqld process listed out in your result. If server is not running, then you can start … Read more
Summary: in this tutorial, you will learn how to create views in MySQL by using the CREATE VIEW statement. Introduction to CREATE VIEW statement The syntax of creating a view in MySQL is as follows: 1234 5 CREATE[ALGORITHM = {MERGE | TEMPTABLE | UNDEFINED}]VIEW [database_name].[view_name]AS [SELECT statement] Algorithms The algorithm attribute allows you to control which mechanism is used when … Read more
To enable the query log, put this in /etc/my.cnf in the [mysqld] section log = /path/to/query.log #works for mysql < 5.1.29 Also, to enable it from MySQL console SET general_log = 1; Remember that this logfile can grow very big on a busy server. update: With mysql 5.1.29+ , the log option is deprecated. To specify the logfile use general_log_file=/path/to/query.log Also, ... Read more
phpMyAdmin is one of the most popular applications, free and open source tool written in PHP, Intended to handle the administration of MySQL with the use of a web browser. phpMyAdmin also supports a wide range of operations on MySQL, MariaDB and Drizzle. Frequently used operations (managing databases, tables, columns, relations, indexes, users, permissions, etc) can be … Read more
Of course, there are many aspects of MySQL replication, but my main focus will be the logistics – how replication events are written on the master, how they are transferred to the replication slave and then how they are applied there. Note that this is NOT a HOWTO setup replication, but rather a how stuff works type … Read more
What is mysqldump The mysqldump client is a utility that performs logical backups, producing a set of SQL statements that can be run to reproduce the original schema objects, table data, or both. It dumps one or more MySQL database for backup or transfer to another SQL server. The mysqldump command can also generate output in CSV, other delimited text, … Read more
it is quiet easy to reset mysql root password, here are the steps SSH as root to your machine Turn off the mysqld daemon if running RedHat/Fedora users can do so by executing: service mysqld stop Run safe_mysqld by executing: safe_mysqld –skip-grant-tables (this will run allow you to connect without a password) 4. … Read more
You just need to modify the query and login credential then run the below command of database server . mysql -e “select * FROM tabledata” -u satya -pPrakash databasename > /home/ob_cdr.txt However i have written a shell script to do this job. #!/bin/bash USER=”root” PASSWORD=”rootpassword” #OUTPUT=”/home/ftpbackup/” OUTPUT=”/root/” rm “$OUTPUTDIR/*txt” > /dev/null 2>&1 databases=`mysql –user=$USER –password=$PASSWORD … Read more