Joomla 3.8.12 Migration from PostgreSQL 9.5 Database to MySQL 5.7 Topic is solved

Need help upgrading your Joomla! website or converting to Joomla! 3.x?

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Post Reply
humorlos
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Tue Mar 21, 2006 9:48 am

Joomla 3.8.12 Migration from PostgreSQL 9.5 Database to MySQL 5.7

Post by humorlos » Tue Sep 11, 2018 12:19 pm

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?

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 36746
Joined: Sat Apr 05, 2008 9:58 pm

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

Post by Webdongle » Tue Sep 11, 2018 12:51 pm

http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"The definition of insanity is doing the same thing over and over again, but expecting different results": Albert Einstein
Member of the CMS Release Team

humorlos
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Tue Mar 21, 2006 9:48 am

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

Post by humorlos » Tue Sep 11, 2018 1:04 pm

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.

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 36746
Joined: Sat Apr 05, 2008 9:58 pm

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

Post by Webdongle » Tue Sep 11, 2018 1:33 pm

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.
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"The definition of insanity is doing the same thing over and over again, but expecting different results": Albert Einstein
Member of the CMS Release Team

humorlos
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Tue Mar 21, 2006 9:48 am

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

Post by humorlos » Tue Sep 11, 2018 2:29 pm

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.

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 36746
Joined: Sat Apr 05, 2008 9:58 pm

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

Post by Webdongle » Tue Sep 11, 2018 3:02 pm

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
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"The definition of insanity is doing the same thing over and over again, but expecting different results": Albert Einstein
Member of the CMS Release Team

humorlos
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Tue Mar 21, 2006 9:48 am

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

Post by humorlos » Tue Sep 11, 2018 3:46 pm

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.

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 25467
Joined: Mon Oct 27, 2008 9:27 pm
Location: Akershus, Norway

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

Post by Per Yngve Berg » Tue Sep 11, 2018 5:55 pm

I have had the same issues importing to a Mysql 5.7 database with zero timestamp values.

twister65
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Sun Feb 10, 2019 12:26 pm

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

Post by twister65 » Sun Feb 10, 2019 12:58 pm

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

humorlos
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Tue Mar 21, 2006 9:48 am

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

Post by humorlos » Mon Feb 11, 2019 9:45 am

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.


Post Reply

Return to “Migrating and Upgrading to Joomla! 3.x”