Support

Site Restoration

#20769 Restoring Database

Posted in ‘Site restoration’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

PHP version
n/a
CMS Type
Other
CMS Version
n/a
Backup Tool Version
n/a
Kickstart version
n/a

Latest post by on Thursday, 25 September 2014 17:20 CDT

Thursday, 21 August 2014 07:46 CDT

user85269
 Hi Guys,

I cannot get past the database restore stage when trying to restore a a website of mine. Here is an overview of whathas happened so far.

We had a website hosted with fasthosts built in php www.wireless-fitness.com
we then had a entirely new website bult using joomla which was hosted on a different server (I do not know who was hosting it)
I then backed up the site using akeeba and have attempted to restore the new site on the original server with fasthosts
The database will not restore.
This is the message I am getting: No database definitions were found or no database was selected.

Hope you can help. This is our business website and we are fast losing sales with it down so any help would be greatly appreciated.

Thanks.

Dom

Thursday, 21 August 2014 09:46 CDT

nicholas
Are both hosts using Microsoft SQL Server? I suspect that the old site was using MySQL. You cannot transfer a site using a MySQL database to a server using Microsoft SQL Server or vice versa. This is not a limitation of Akeeba Backup, it has to do with extensions support for database servers, the lack for 1:1 translation of database field types and the impossibility to convert data from one db server format to another without at least some degree of manual intervention. It's basically a lot like translation: if you let a computer do it the results are barely intelligible.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Thursday, 21 August 2014 15:16 CDT

user85269
Hi and thanks.

In retrospect, it seems that I am using MySQL and the previous site was also MySQL. So what would your next suggestion be?

Thanks.

Dom

Thursday, 21 August 2014 16:14 CDT

nicholas
First I want you to check something. Do that that after you've run Kickstart and you have launched ANGIE (i.e. your archive is extracted and you pressed the "Run the Installer" button). Take a look at the new site via FTP. Do you see the installation/sql/databases.ini file?

If the file is not there I will need to take a look at your backup log.

If the file is there please contact your host and ask them to help you. Their server's PHP session storage is not working properly.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Thursday, 21 August 2014 16:31 CDT

user85269
Hi Nicholas,

Forgive me, I am a novice and don't understand your instructions.Where would I find the option to run Kickstart?

Friday, 22 August 2014 00:46 CDT

nicholas
Please begin by watching the video tutorials at https://www.akeebabackup.com/videos/63-video-tutorials/1529-akeeba-backup-video-course-with-brian-teeman.html You MUST see tutorial 06 - Restoring a site on a new server. This is what you need to do.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Tuesday, 26 August 2014 08:27 CDT

user85269
Hi Nicholas,

I've done as suggested in the video tutorial and yes, the installation/sql/databases.ini file is present in the remote site.

Before I do contact my host to ask about the PHP session storage, can I mention a couple of things which may affect the way this works?

The database which exists on the new server is remaining from an old website which was previously hosted there. The website which I'm trying to move to this host is different to the old site. Will this make a difference when trying to load a new database onto an old database from a different website?

Also, the database user name which I'm using is an IP Address. Is that correct, or should it be something else? I see from the example it says that usually "localhost" is the correct one to use but this doesn't work when i try it.

Thoughts?

Thanks.

Tuesday, 26 August 2014 12:35 CDT

nicholas
Before I do contact my host to ask about the PHP session storage, can I mention a couple of things which may affect the way this works?


No, these are entirely irrelevant.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Thursday, 25 September 2014 17:20 CDT

System Task
system
This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.
Edited by on 2014-09-25 17:20 CDT

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!