Database tables missing
Posted by: Boldee (---.8-3.cable.virginm.net)
Date: January 25, 2018 11:19PM

First of all sorry if this has been asked before I did search but with no luck.

I had to reinstall wamp64 on to a new drive, I backed up my site and the database ready for the new install (Same wamp version as the site ran on originally), I reinstalled wamp on the new drive and tested that all services were running and they were, I then copied over my backed up site and database, all services still run fine.

My site is Joomla based, when trying access the site I am getting an error stating that the database session table is missing, on checking the database only some tables are being recognised, specifically tables starting with letters A through to F, all tables are present for the site in the data folder however.

This seems a little odd and I have never come across anything like this before, has anyone got an idea of what is going on here and how I can fix this?

Options: ReplyQuote
Re: Database tables missing
Posted by: Boldee (---.8-3.cable.virginm.net)
Date: January 25, 2018 11:53PM

Please disregard it was pilot error, I hadn't copied the iddata1 file over.

Options: ReplyQuote
Re: Database tables missing
Posted by: Otomatic (Moderator)
Date: January 26, 2018 09:10AM

Hi,

You were really very lucky that this way of transferring tables works without any problems.

The only reliable and durable way to transfer database is to export/import into SQL files.

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.3 32 bit - Apache 2.4.33 - PHP 7.2.6/7.1.18/7.0.30/5.6.36 - MySQL 5.7.22 - MariaDB 10.3.7
Wampserver 3.1.3 64 bit - Apache 2.4.33 - PHP 7.2.6/7.1.18/7.0.30/5.6.36 - MySQL 5.7.22 - MariaDB 10.3.7
PhPMyAdmin 4.8.0.1 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote


Sorry, only registered users may post in this forum.