Support

Site Restoration

#16770 Empty tables after restore

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 nicholas on Tuesday, 16 July 2013 10:17 CDT

user63889
Mandatory information about my setup:

Have I read the related troubleshooter articles above before posting (which pages?)? YES
Have I searched the tickets before posting? No
Have I read the documentation before posting (which pages?)? YES
Joomla! version: 2.5.11
PHP version: 5.4.4
MySQL version: (unknown)
Host: localhost by MAMP
Akeeba Backup version which took the backup: (unknown)
Kickstart version used to extract the backup: PRO 3-1

Description of my issue:

Hi, i make a backup of one of my clients to make changes locally in my office using MAMP
1) The backup was made successfully
2) The restore (Kickstart Pro) do not give me any error
3) The frontend look fine!

But....
4) Before login in the backend, appears a window that it say:
AUTHENTICATION REQUIRED
A username and password are being requested by http://localhost. The site says: "Restricted Area"
and ask me for a username and password, if entering any data now appears this message:

Authorization Required
This server could not verify that you are authorized to access the document requested. Either you supplied the wrong credentials (e.g., bad password), or your browser doesn't understand how to supply the credentials required.

If i try with any user or password this message appears:

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.

5) So i check my tables in phpMyAdmin and all the tables appears correctly but they are empty no data or information are inside (please look pictures)

Please i need your help ASAP

Thanks for your time and collaboration.

Greetings
Alejandro

nicholas
Akeeba Staff
Manager
Backend: Read this https://www.akeebabackup.com/documentation/troubleshooter/atadminpw.html

Tables: You say:
3) The frontend look fine!

and
5) So i check my tables in phpMyAdmin and all the tables appears correctly but they are empty no data or information are inside (please look pictures)


These are mutually exclusive. You either see your frontend without a problem or your tables are empty. If your tables are empty there is no data to generate your site's front-end. Moreover, the screenshot you provided shows you trying to edit a specific field of the table, not showing the contents of the table. I don't speak any Spanish at all, but my best guess is that "Estructura" means "Structure" and "Cambiar" means "Edit". I think problem #5 is simply a problem with you not understanding how to use phpMyAdmin. Try clicking the tab called "Examinar". I think it's what is called "Browse" in English and shows you the actual contents of the table...

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!

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!