This is a list of handy MySQL commands that I use time and time again. At the bottom are statements, clauses, and functions you can use in MySQL. Below that are PHP and Perl API functions you can use to interface with MySQL. To use those you will need to build PHP with MySQL functionality. To use MySQL with Perl you will need to use the Perl modules DBI and DBD::mysql.
Read the rest of this entry
List of Basic MySQL Commands
Author: adminJan 15
How to retrieve data from mysql using bash script
Author: adminJan 22
Besides from using perl scripts, phpmyadmin and customized php pages, here is a quick way to fetch data from mysql database using shell script.
Just make sure you are currently running mysql from your box with existing database and table inside.
Read the rest of this entry
How to change the mysql port
Author: adminJan 15
To change the port, select the “my.cnf file.
Change it to whatever you like and remove the # from the front. Then restart the engine and you should be set for that.
Open /etc/my.cnf file:
# vi /etc/my.cnf
Set new port 5123:
port=5123
Here is is my sample /etc/my.cnf file:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
port=5123
old_passwords=1
bind = 203.171.31.11
Backup Databases in MySQL
Author: adminJan 4
How about backing up all the databases in the server? That’s an easy one, just use the –all-databases parameter to backup all the databases in the server in one step.
mysqldump –all-databases> alldatabases.sql
How to Backing up only the Database Structure in MySQL
You can backup only the database structure by telling mysqldump not to back up the data. You can do this by using the –no-data parameter when you call mysqldump.
mysqldump –no-data –databases Customers Orders Comments > structurebackup.sql
ODBC support on a cPanel server
Author: adminDec 25
How to compile unix odbc on a cPanel server? On a cPanel server, the /scripts/easyapache script almost provides all the modules that are required to host the websites but the modules such as odbc has to be installed manually. You first have to install the devel packages for unixodbc, then add a line in rawopts file and rebuild Apache+PHP. That is it.
Read the rest of this entry