Page 1 of 1

Joomla 3.8.12 Migration from PostgreSQL 9.5 Database to MySQL 5.7

Posted: Tue Sep 11, 2018 12:19 pm
by humorlos
Hello,

currently I am trying to migrate an Joomla installation currently based on a postgresql database to a mysql database. The datatables and content of the database i managed to transfer, and I can login to the backend.

But in the backend all admin menus and buttons are missing. Therefore I thought, I manually trigger a database fix in the maintenance tools, which now states, that the database is in a correct state and everything should be fine.

In addition I have to say, that there are now error messages or warnings displayed.

I already tried to find, if something similar already happened in the past, and all i could find where some troubles around 3.7.0 and the fix with the menu entries. But that is all fine in the database, and rerunning the corresponding sql script results in no lines modified.

Comparing with a working site, all blocks in the navigation, containing the menus are empty or simple not generated by the engine.

Has anyone some good suggestions what could help?

Re: Joomla 3.8.12 Migration from PostgreSQL 9.5 Database to MySQL 5.7

Posted: Tue Sep 11, 2018 12:51 pm
by Webdongle

Re: Joomla 3.8.12 Migration from PostgreSQL 9.5 Database to MySQL 5.7

Posted: Tue Sep 11, 2018 1:04 pm
by humorlos
Do you want to say: "Use Akeeba and everything is fine" or do I miss something. As stated above, I would like to understand, what is causing the issue in this special case of migrating from one database system to another.

Re: Joomla 3.8.12 Migration from PostgreSQL 9.5 Database to MySQL 5.7

Posted: Tue Sep 11, 2018 1:33 pm
by Webdongle
The installer that is in the backup.jpa file will tell you if there are problems and will prevent human error. Also use Wamp as localhost and you will avoid a lot of problems. That's my advice ... you can act on it or second guess it. I don't have the time to condense the reasons into a short post.

Re: Joomla 3.8.12 Migration from PostgreSQL 9.5 Database to MySQL 5.7

Posted: Tue Sep 11, 2018 2:29 pm
by humorlos
Unfortunatly your posts are no real help. I think, you misunderstood the question. Akeeba is nice for backing up an installation and restoring it on the same technology, but here the task is, that the original one is stored in an postgresql database and it shall be transfared into a MySQL Database.

As Akeeba States in the documentation:
That is to say that you cannot restore a site which was using MySQL on Microsoft SQL Server or PostgreSQL or vice versa;
https://www.akeebabackup.com/documentat ... n-database

And yes, I managed to transfer the database itself from Postgresql to MySQL and as I stated, the joomla Database Check is running fine. But simply, in the result, there are no buttons, no admin menus and on user site there are also no modules or menus.

Re: Joomla 3.8.12 Migration from PostgreSQL 9.5 Database to MySQL 5.7

Posted: Tue Sep 11, 2018 3:02 pm
by Webdongle
If it is stored in a database then what is stopping you connecting files to that database and using Akeeba?

If you just copied the postgresql database to a mysql database
Make sure the files version match the database version.
And that there were no 3rd party security extensions that prevent the menu from showing

Also try /administrator/index.php?option=com_joomlaupdate
Check for updates then download the update file and use the Upload&Update tab ?

/administrator/index.php?option=com_users&view=levels
Make sure Super Users is selected in the 'Special' level

Re: Joomla 3.8.12 Migration from PostgreSQL 9.5 Database to MySQL 5.7

Posted: Tue Sep 11, 2018 3:46 pm
by humorlos
I can use Akeeba, but Akeeba only lets you restore a PostgreSQL into a PostgreSQL DB and a MySQL in a MySQL, but not accross.

But I finally found the cause - in regard to the different default values for empty timestamps (1970-01-01 00:00:00 vs 0000-00-00 00:00:00) all modules where thought as "expired". Changing these values back to the corresponding database default values solved the problem.

Re: Joomla 3.8.12 Migration from PostgreSQL 9.5 Database to MySQL 5.7

Posted: Tue Sep 11, 2018 5:55 pm
by Per Yngve Berg
I have had the same issues importing to a Mysql 5.7 database with zero timestamp values.

Re: Joomla 3.8.12 Migration from PostgreSQL 9.5 Database to MySQL 5.7

Posted: Sun Feb 10, 2019 12:58 pm
by twister65
Have you tried MySQL Workbench to migrate your database ?
https://dev.mysql.com/downloads/workbench/
with online documentation :
https://dev.mysql.com/doc/workbench/en/ ... resql.html

Re: Joomla 3.8.12 Migration from PostgreSQL 9.5 Database to MySQL 5.7

Posted: Mon Feb 11, 2019 9:45 am
by humorlos
Hello,

yes I have tried the MySQL Workbench but it was a complete desaster, resulting in many errors in the GUI an so on.

I ended up in migrating it with https://dbeaver.io/ Community Edition and it worked good.