Database import with missing tables, any suggestions?

[serazoo]

Hello all
Thank you in advance!

I've read many posts on this subject here and the web, I really can't seem to find an answer.. I'm turning to the cpanel forum family and maybe someone has found the culprit of my problem.

I'm left on my own, my web provider has no problem on his end exporting-importing using the same method and the same database I'm trying to export-import.

The DB is 5mb, and really does not take time to export-import so it's not a timeout problem... when I export-import, Joomla says there are missing tables.. I'm stuck and I don't want to rely on my host provider each time I want export-import.

I've also tried, unchecked "Allow the interruption of an import in case the script detects it is close to the PHP timeout limit. (This might be a good way to import large files, however it can break transactions.)" .. still the same problem

Any idea what could be the problem on my side? I've been doing this for 15 years and this is the first time with this dilemma...

Thanks

 

[cPanelLauren]

Hi @serazoo

What's the exact process you're using to import/export and where are you moving from/to?

 

[serazoo]

Thanks for a response
I have my own VPS with Funio hosting, I'm moving the database from one site to an another within my VPS
Attached are the steps I'm taking with images.

My host provider asked the same and he also does not understand why it is not working when I export-import.. but on his end no problem at all. I thought maybe a browser problem but the same is with Firefox and Chrome...

Thx

 

[cPanelLauren]

And when you import the tables is it the same tables missing each time or is it different?

 

[serazoo]

I've exported-imported about 20 times these past 2 weeks.. until now it seems to be the same table.. I've attached a screenshot.... I can't find any hint on the web
I'm making sure to "check-all" when exporting... how can a table be missing... very very odd

 

[cPanelLauren]

Hi @serazoo

I agree and with no error messages it is pretty odd. Can you provider indicate if they see anything in the following locations when you do the export:

/var/lib/mysql/hostname.err
/var/log/messages
/usr/local/cpanel/logs/error_log

 

[serazoo]

.. I have finally found a workaround for my problem, my missing table "wf_profiles" which Joomla constantly reminds me when I'm in the administration area that it doesn't exist ... the table is part of the component "JCE" a wysiwyg editor.. the solution was to re-insall the component and the problem goes away...

But I wish I knew why I'm not able to export-import 100%... without having errors and to reinstall stuff

cPanelLauren sorry for sounding like a newbie, I have searched and I can't find logs in suggested locations... files directory in root
and my cpanel version says v78.0.41...

Thx again

 

[cPanelLauren]

If you don't have root access to the server, your provider may need to check these for you. I'm glad to hear you found the issue though.