PHP Versions

[frosty]

I have recently built a new webserver on Ubuntu 10.10.

I was on PHP version 2.11.1 and now on 3.3.7. I understand that there is no way to import a database from 2.11.1 to 3.3.7 is that correct? If that is the case does anyone have any ideas or is it a rebuild of my Joomla & Moodle from scratch?

[powdarrmonkey]

I was on PHP version 2.11.1 and now on 3.3.7.

I doubt that very much; PHP major version 2 has not been in production in years now. You mean 5.3.3-1ubuntu9.1.

I understand that there is no way to import a database from 2.11.1 to 3.3.7 is that correct? If that is the case does anyone have any ideas or is it a rebuild of my Joomla & Moodle from scratch?

You should probably ask on Moodle.org: Forums

[frosty]

I doubt that very much; PHP major version 2 has not been in production in years now.[/url]

2006 I believe? - Yes I am still using it...

No I mean Ubuntu 10.10

[powdarrmonkey]

2006 I believe? - Yes I am still using it...

No I mean Ubuntu 10.10

Ubuntu 10.10 ships PHP version 5.3.3-1ubuntu9, and if you have updated recently you've got 5.3.3-1ubuntu9.1. End of.

[frosty]

Right so anyway back to the original query...is anyone able to help?

[ZeroHour]

Right so anyway back to the original query...is anyone able to help?

Firstly moodle/joomla requires php 4+ I believe (check by making a something.php file with <? phpinfo(); ?> in it to see the details)
If its using a mysql database its easy to move the db. Just use a program such as heidisql to connect to the servers database and export to an sql file. On your new server connect and run the sql file you just made against it and it should create the databases (check the relevant boxes when exporting)
Next you have to manually create the user accounts on your new server and setup permissions to allow the account to access the db. Move the php files and see if it works (update connection server name if its not localhost in the moodle/joomla config file)

thats a rough outline for you.

[frosty]

Sorry I am on 5.3.3-1ubuntu9.1 as I was so eliquently put in my place. In error I posted my phpmyadmin version - so sorry.

I have tried exporting in phpmyadmin to a .sql file and reimporting in my 5.3.3-1 and get this error:

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '&lt;!DOCTYPE html PUBLIC &quot;-//W3C//DTD XHTML 1.0 Transitional//EN&quot;
&quot;http://www.w' at line 1

[powdarrmonkey]

Sorry I am on 5.3.3-1ubuntu9.1 as I was so eliquently put in my place. In error I posted my phpmyadmin version - so sorry.

Right, now I understand. This isn't at all related to Joomla, Moodle or PHP then.

I have tried exporting in phpmyadmin to a .sql file and reimporting in my 5.3.3-1 and get this error:

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '&lt;!DOCTYPE html PUBLIC &quot;-//W3C//DTD XHTML 1.0 Transitional//EN&quot;
&quot;http://www.w' at line 1

The file you've exported isn't a SQL file. That snippet is the top of a web page, so something has gone badly wrong in your export.

[Cools]

YouTube - PHPMyAdmin & MySQL & PHP introduction 06