Moving Joomla3 database from CentOS 6.10 to Ubuntu 18.04 Topic is solved

Need help installing Joomla! 3.x? For all Joomla! 3.x installation issues please use this forum.

Moderators: General Support Moderators, 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.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10
Post Reply
User avatar
adrian_vg
Joomla! Intern
Joomla! Intern
Posts: 52
Joined: Wed Apr 23, 2014 3:06 pm
Location: Sweden

Moving Joomla3 database from CentOS 6.10 to Ubuntu 18.04

Post by adrian_vg » Wed Apr 08, 2020 6:50 pm

Hello all!

I'm in the process of moving my current Joomla3 install on an aging CentOS 6.10 with 5.5.67-MariaDB to Ubuntu 18.04 with 5.7.29-mysql.
Main reason for doing this is that Ubuntu supports and has proven mechanisms in place for major version upgrades without having to reinstall the whole OS - something CentOS still kinda' seems to disapprove of.

I'm gettting to the point of having suspicions that restoring the 5.5-database dump from CentOS 6 to the newer 5.7-database on Ubuntu 18.04 is giving me problems.

What I've tried so far is just import the dump from CentOS to Ubuntu and then installing Joomla with the database already in place.
While this worked for a while and I was happy as a clam, I took a weeklong break from this. When I got back all I get from the Ubuntu-Joomla is an "Error". At this point I just gave up and reinstalled the test-vm from scratch, but now want to do the database-restore somewhat more controlled.

My test-migrations haven't so far obviously been stellar, so I'm wondering if there are any gotchas' I should be aware of, while continuing to research on how to proceed with this migration?

I'm grateful for any tips, tricks and hints.
Thanks in advance!
--
//AvG

User avatar
ltheme
Joomla! Guru
Joomla! Guru
Posts: 612
Joined: Wed Dec 04, 2013 2:43 pm
Location: US
Contact:

Re: Moving Joomla3 database from CentOS 6.10 to Ubuntu 18.04

Post by ltheme » Thu Apr 09, 2020 2:40 am

Hi,
You should take a look at https://downloads.joomla.org/technical-requirements
And for backup/restore task, I recommend you with Akeeba tool, not manually https://extensions.joomla.org/extension/akeeba-backup/
Steve (Mr.) - fan of Joomla! CMS.
https://ltheme.com/joomla-templates/ <= Free Joomla! 3.x templates.
https://ltheme.com/free-one-page-joomla-templates/ <= Free Onepage Joomla! templates
^Compatible with Joomla! 3.x and Joomla! 4

User avatar
adrian_vg
Joomla! Intern
Joomla! Intern
Posts: 52
Joined: Wed Apr 23, 2014 3:06 pm
Location: Sweden

Re: Moving Joomla3 database from CentOS 6.10 to Ubuntu 18.04

Post by adrian_vg » Thu Apr 09, 2020 11:20 am

ltheme wrote:
Thu Apr 09, 2020 2:40 am
Hi,
You should take a look at https://downloads.joomla.org/technical-requirements
No problems there, from what I can see.
ltheme wrote:
Thu Apr 09, 2020 2:40 am
And for backup/restore task, I recommend you with Akeeba tool, not manually https://extensions.joomla.org/extension/akeeba-backup/
I've seen recommendation for this 3rd party tool before.

Are you saying a manual dump/restore of the database and zipping up the Joomla files and folders and moving them to the new server isn't going to work?
--
//AvG

User avatar
ltheme
Joomla! Guru
Joomla! Guru
Posts: 612
Joined: Wed Dec 04, 2013 2:43 pm
Location: US
Contact:

Re: Moving Joomla3 database from CentOS 6.10 to Ubuntu 18.04

Post by ltheme » Thu Apr 09, 2020 2:07 pm

adrian_vg wrote:
Thu Apr 09, 2020 11:20 am
ltheme wrote:
Thu Apr 09, 2020 2:40 am
Hi,
You should take a look at https://downloads.joomla.org/technical-requirements
No problems there, from what I can see.
ltheme wrote:
Thu Apr 09, 2020 2:40 am
And for backup/restore task, I recommend you with Akeeba tool, not manually https://extensions.joomla.org/extension/akeeba-backup/
I've seen recommendation for this 3rd party tool before.

Are you saying a manual dump/restore of the database and zipping up the Joomla files and folders and moving them to the new server isn't going to work?
Manual task also work, but make sure that you follow:
1/ Zip all source code
2/ Export database
3/ Upload source code to your new hosting and unzip it.
4/ Create create database and import your dataabase
5/ Open file 'configurtion.php' and replace with required info from new hosting info.
In case you have error, so just check PHP/MySQL version, and also with config of 'configuration.php' file.
Steve (Mr.) - fan of Joomla! CMS.
https://ltheme.com/joomla-templates/ <= Free Joomla! 3.x templates.
https://ltheme.com/free-one-page-joomla-templates/ <= Free Onepage Joomla! templates
^Compatible with Joomla! 3.x and Joomla! 4

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

Re: Moving Joomla3 database from CentOS 6.10 to Ubuntu 18.04

Post by Per Yngve Berg » Thu Apr 09, 2020 2:17 pm

Do you have a problem with zero dates?

https://dev.mysql.com/doc/refman/5.7/en/using-date.html

User avatar
adrian_vg
Joomla! Intern
Joomla! Intern
Posts: 52
Joined: Wed Apr 23, 2014 3:06 pm
Location: Sweden

Re: Moving Joomla3 database from CentOS 6.10 to Ubuntu 18.04

Post by adrian_vg » Thu Apr 09, 2020 3:07 pm

ltheme wrote:
Thu Apr 09, 2020 2:07 pm
adrian_vg wrote:
Thu Apr 09, 2020 11:20 am
ltheme wrote:
Thu Apr 09, 2020 2:40 am
Hi,
You should take a look at https://downloads.joomla.org/technical-requirements
No problems there, from what I can see.
ltheme wrote:
Thu Apr 09, 2020 2:40 am
And for backup/restore task, I recommend you with Akeeba tool, not manually https://extensions.joomla.org/extension/akeeba-backup/
I've seen recommendation for this 3rd party tool before.

Are you saying a manual dump/restore of the database and zipping up the Joomla files and folders and moving them to the new server isn't going to work?
Manual task also work, but make sure that you follow:
1/ Zip all source code
2/ Export database
3/ Upload source code to your new hosting and unzip it.
4/ Create create database and import your dataabase
5/ Open file 'configurtion.php' and replace with required info from new hosting info.
In case you have error, so just check PHP/MySQL version, and also with config of 'configuration.php' file.
Thanks for the clarification. I realize I followed the outlined steps, but didn't check the configuration.php. Maybe that was the problem.
--
//AvG

User avatar
adrian_vg
Joomla! Intern
Joomla! Intern
Posts: 52
Joined: Wed Apr 23, 2014 3:06 pm
Location: Sweden

Re: Moving Joomla3 database from CentOS 6.10 to Ubuntu 18.04

Post by adrian_vg » Thu Apr 09, 2020 3:08 pm

Per Yngve Berg wrote:
Thu Apr 09, 2020 2:17 pm
Do you have a problem with zero dates?

https://dev.mysql.com/doc/refman/5.7/en/using-date.html
I don't know. Would this give me a white blank page with just the text "Error"?
--
//AvG

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

Re: Moving Joomla3 database from CentOS 6.10 to Ubuntu 18.04

Post by Per Yngve Berg » Fri Apr 10, 2020 9:16 am

No, it will get the import process to halt. Your title says database, so I assumed that what you had problem with.

A blank page is a php error. Increase the Error Report Level to 'maximum' so you can see the errors.

What version of Joomla are you moving and what version of php is the server running?

Best to use the FPA to check the setup of the new server.

User avatar
adrian_vg
Joomla! Intern
Joomla! Intern
Posts: 52
Joined: Wed Apr 23, 2014 3:06 pm
Location: Sweden

Re: Moving Joomla3 database from CentOS 6.10 to Ubuntu 18.04

Post by adrian_vg » Sat Apr 11, 2020 8:41 am

Per Yngve Berg wrote:
Fri Apr 10, 2020 9:16 am
No, it will get the import process to halt. Your title says database, so I assumed that what you had problem with.

A blank page is a php error. Increase the Error Report Level to 'maximum' so you can see the errors.

What version of Joomla are you moving and what version of php is the server running?

Best to use the FPA to check the setup of the new server.
I assumed it was a database error as I've seen it before when I had a RAID-array mishap and a database-problem following that.

Good info about the php and error report level, thanks!

FPA is coming ASAP!
--
//AvG

User avatar
adrian_vg
Joomla! Intern
Joomla! Intern
Posts: 52
Joined: Wed Apr 23, 2014 3:06 pm
Location: Sweden

Re: Moving Joomla3 database from CentOS 6.10 to Ubuntu 18.04

Post by adrian_vg » Fri Nov 27, 2020 3:09 pm

I resorted to building a new virtual machine, and pasting the source code for each article from the old to the new server. There weren't that many articles anyway and took only a few hours.

Something must have been faulty in the original database. Over the years stuff may have been introduced inadvertently and effed up the dumps. In any case, the dumps were unusable.

The advantage with a new joomla-instance from scratch is that I can use the experiences I've gathered over the years and get it right this time from the start, skipping the experimental stage.

I've also documented the step on what's been done, so I can reproduce them.

All in all, all is up again and running well, except a less than handful messages on a few article pages from Disqus, that didn't like the move at all and now point everywhere but to the right article.
I'm guessing this will fix itself over time.

Thanks all for your hints!
--
//AvG


Post Reply

Return to “Installation Joomla! 3.x”