How to migrate drupal database from xampp 1.7.3 to1.8.3?

Problems with the Mac OS X version of XAMPP, questions, comments, and anything related.

How to migrate drupal database from xampp 1.7.3 to1.8.3?

Postby roumbaba » 12. February 2014 02:06

Hello,

I have a working 1.7.3 XAMPP configuration on my os X 1.9.1. In that configuration I have a working drupal site installed in XAMPP/htdocs/mySite. My drupal database for that site lives in XAMPP/xampfiles/var/mysql/myDrupalDatabase. I would like to upgrade to Xampp 1.8.3 what is the proper way to move my site over to the new xampp 1.8.3?

I have tried to simply copy myDrupalDatabase to the new XAMPP/xampfiles/var with no luck. I have also started the new install process while leaving the old XAMPP (1.7.3) folder in place. Both approaches result in an error like this:

PDOException: SQLSTATE[HY000] [1045] Access denied for user 'old173user'@'localhost' (using password: YES) in lock_may_be_available() (line 167 of /Applications/XAMPP/xamppfiles/htdocs/mySite/includes/lock.inc).


Basically it seems like the new Xampp uses a newly created msSql database and does not use the drupal one even though it is copied into the var directory.

Any hint on how to properly migrate my drupal install would be appreciated.
roumbaba
 
Posts: 1
Joined: 12. February 2014 01:51
Operating System: os x 1.9.1

Re: How to migrate drupal database from xampp 1.7.3 to1.8.3?

Postby Altrea » 12. February 2014 06:15

Hi roumbaba,

Moving a Joomla installation from one XAMPP to another is done the same way as from one server to another.
We cannot ptovide any support for third party scripts like Joomla, but this Joomla page will show your the recommend way => http://docs.joomla.org/Copying_a_Joomla_website

I hope you are sure your Joomla installation will work with the new components, especially PHP 5.5

best wishes,
Altrea
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8293
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: How to migrate drupal database from xampp 1.7.3 to1.8.3?

Postby Nobbie » 12. February 2014 11:56

roumbaba wrote:Basically it seems like the new Xampp uses a newly created msSql database and does not use the drupal one even though it is copied into the var directory.


I think that this is due to the fact that Xampp 1.7.3 comes with a MySQL Release that uses "MyISAM" as Engine, whereas the new releases of MySQL use "InnoDB". The tables and databases using "MyISAM" can easily be seen on the harddisk, as there are folders and files in the data folder of MySQL with the names of the databases and tables. Instead the databases and tables of "InnoDB" cannot be seen easily, because they are embedded in the one single large file "ibdata1".

There two kinds of solution:

a) either change the type of the existing drupal tables from "MyISAM" to "InnoDB". This can be done with as "ALTER TABLE "tablename" ENGINE='InnoDB'", subsequently with ALL Drupal tables (might be a nasty task, or write a PHP script whicht runs through a database and ALTER all tables via a loop). You have to do this in the old Xampp environment und then import the ibdata1 file.

or

b) change the default-engine in MySQL from InnoDB to MyISAM (as it has been formerly) in the new Xampp environment. In order to achieve that, you should enter this directive in the [mysqld] Section of you my.ini (or my.cnf) Configuration file:

Code: Select all
default-storage-engine = MyISAM


Also uncomment the "#skip-innodb" (remove the #) in the configuration. Reboot/restart Xampp (or at least MySQL) and try to find out, if the copied drupal tables are found (use PhpMyAdmin for administration).

If you cannot succeed, you have to go the "long way" as mentioned in the Drupal documentation about changing from one server to another.
Nobbie
 
Posts: 8770
Joined: 09. March 2008 13:04


Return to XAMPP for Mac OS X

Who is online

Users browsing this forum: No registered users and 5 guests