Ok, setting up Apache, PHP and MySQL is super easy. I used this tip from Ubuntu Forum.

I also want to import my site and database from Windows.

Install

  • Go to System > Administration > Synaptic Package Manager
  • Now go to Edit > Mark Packages by Task
  • Choose LAMP Server (Linux/Apache/MySQL/PHP server)

In my case, the Ultimate Edition already had this installed :-)

I just updated Apache, MySQL and PHP using System > Administration > Update Manager.

Now I’m going to install PHPMyAdmin (very useful):

  • Go to System > Administration > Synaptic Package Manager
  • Find by phpmyadmin
  • Install

Get database and site from Windows

Ultimate Edition already had this installed as well :-)

I marked it to update though.

Now I need to install my Apache/MySQL/PHP solution I had under Windows.

How difficult (easy) will it be?

  • Get from Windows the PHP folder mysite
  • Get from Windows the MySQL database folder mydatabase
  • In the Terminal (this will open the default Apache site location)
sudo nautilus /var/www
  • Now copy the mysite folder here
  • In the Terminal (this will open the default MySQL database location)
sudo nautilus /var/lib/mysql
  • Now copy the mydatabase folder here
  • In the Terminal (this will change your admin password)
sudo mysqladmin -u root password NEWPASSWORD

– NEWPASSWORD must be the same from your Windows config

  • In your favorite browser type http://localhost/mysite

Still, there’s a problem. The database is read-only. But is easy to fix:

  • Go to http://localhost/myphpadmin and login as root
  • Select your database in the left pane
  • Go to Export
  • Select the Add DROP TABLE / DROP VIEW option
  • Click the Go button
  • Copy the generated script (it includes the insert statements) to your favorite text editor
  • Add the following to the script, before the first drop table statement, replacing mydatabase with your database name and save the script
USE mydatabase;
  • Delete the mydatabase folder copied from Windows
sudo rm -R /var/lib/mysql/mydatabase/
  • In myphpadmin go to the home page (first icon in the left pane)
  • Create a New Database with the same name from the previous, mydatabase
  • In myphpadmin go to the Query Window (third icon in the left pane)
  • In the Query Window go to Import and browse to your script file
  • Click the Go button and that’s it, your database is ready to go

Post Update

After upgrading to Hardy Heron I had to reinstall the LAMP server. After the installation, when I accessed my index.php file, Firefox tried to download it.

I had to link the PHP module files to the mods-enabled Apache directory in order to get it going:

  • Link the PHP modules do the mods-enabled Apache directory
cd /etc/apache2/mods-enabled/
sudo ln -s ../mods-available/php5.load .
sudo ln -s ../mods-available/php5.conf .
  • Restart Apache
sudo /etc/init.d/apache2 restart
  • Clean browser cache (Ctrl+Shift+Del in Firefox)

And that was it.