Archive for the 'MySQL' Category

Install Webserver with apt-get

apt-get commands
My source.list for “/etc/apt/source.list”

Update Apt Database

Upgrades Installed Packages

Install Package

Remove Package

Check if there are no broken dependencies

1. Installing Apache Webserver

To test this create a textfile

Put this code in it:

Open your browser and go to: http://ip.address/test.php or http://domain/test.php. Now you should get a generated webpage with all the information about apache/php settings.

2. Enable GD Library with PHP

3. Installing MySQL Database Server

4. Change root password on mysql

5. PhpMyAdmin Installation

The phpmyadmin configuration file is located at: /etc/phpmyadmin folder.
To setup under apache all you need to do is include the following line in /etc/apache2/apache2.conf

Point your browser to: http://domain/phpmyadmin

This is a shortcut of the detailed described installation in:

No Comments »

admin on January 20th 2009 in Linux, MySQL, PHP

Mysql Date Format

SELECT DATE_FORMAT(now(), ‘%d-%m-%y %H:%i:%s’);

No Comments »

admin on August 29th 2008 in IT, MySQL

Backup and Restore MySQL Complete

I had to backup and restore a MySQL database on a debian linux machine to another server at work. First I tried to do it trough phpmyadmin which is not very efficient when it comes to big db. So I decided to do it through the MySQL command prompt.

Backup all dbs command into a dump file
mysqldump -u root -p –all-databases > xxxxxxx.sql

Restore all dbs command from a dump file
mysql –f -u root -p < xxxxxxx.sql

Of course you need to replace x with the filename you would like to use.

As always… it worked for me but there is no warranty. You need to decide yourself if you want to use it!

No Comments »

admin on May 4th 2008 in MySQL

Check out new movies online website. Download and buy movies now.