MYSQL Server + Apache Server + PHP
 

Hi,

Recently I have a project and that's migrating Mysql database, apache server + php script from Windows XP to Linux.

I'm new in database administration.... please help

1) Is there any GUI based Mysql administration can be install and use for administrations?

2) How to link Apache Server to Mysql Database & PHP scripts for web based database system.

Seeking for help in extra questions.... please advice on this matter.

You could use phpMyAdmin for the GUI for MySQL

Hi Buck,

I heard about phpmyadmin, is it link with PHP ?? And how about configurations for Apache?

How about migrating from Windows based to Linux based?

Is there any hard work to be done?

Please advice

If you're migrating all of the above just from one platform to another, there shouldn't be too much of an issue. I often do my development at work on an XP box in MySQL/Apache/PHP then migrate all to either a hosted site or a linux box.

Do read the manuals on setting up the permissions and owners/groups. Once done, you should be all set.

For PHP, I don't administer anything. I've changed the .confi file once....i think.

For mySQL you could - as mentioned earlier - use MySQLAdmin - a very good and common PHP-based administration utility. I use this often to back up many of my sites.

At home, I use MySQL's GUI admin tool - http://dev.mysql.com/downloads/administrator/1.0.html - very nice and fast under my KDE system.

For apache....well....

...learn to love the conf files.

:rolleyes:

Ok guys... Thanks for everything..... please post more advices as I

would be very grateful for everyone's teachings....

I am also currently transitioning my site from Wndows to Linux, but Im doing the 'Command Line' way

Hi Buck,

Would you be kind to show me the way of doing in Comand Line?

Once Ive done it successfully I'll post exactly what I did