Archive for the ‘Mysql’ Category

14 Feb, 2010

MySQL backup from command line

Posted by: admin In: Linux| Mysql

It may be useful to make a backup of a specific database through the command line. Surely it is easier to use tools like phpMyAdmin, but in case of emergency or because you prefer use the shell, this info is certainly useful. The executable that performs the operation is “mysqldump” which is usually installed with [...]

04 Jan, 2009

MySQL sample connection

Posted by: admin In: Mysql| howto| php

Pre-requisites:
Database host or IP
Database name
Username and password access of db.
First we need to declare some critical data like username and password, so i strongly recommended to store this value into a different file where php will ask tables and data, this for security reason.
In the php convension, usually we make a file called config.inc.php, because [...]