Archive for the ‘Mysql’ Category

You could call checkmate of the forgetful, i mean not remember your blog administrator password. This happens  when creating new blog, or after a long time of inactivity. Before performing this procedure, which is irreversible, we recommend you use the special page designed by the creators of WordPress (just add the URL of your domain the following syntax /wp-login.php? [...]

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 [...]