XF 1.2 An unexpected database error occurred. Please try again later.

[Slind]

Hey,

I moved my Forum from a webspace to a vserver. Database and database accs are the same. Other CMSs working fine.

What could be the issue ?

An unexpected database error occurred. Please try again later.

 

[Paul B]

View the page source to see if there is additional information.
This is usually due to incorrect database details in config.php.

 

[Slind]

same database and acc as contao and contao is working
why is there a .xf ?

An unexpected database error occurred. Please try again later.
<!-- Mysqli prepare error: Table '46361m36800_10.xf_option' doesn't exist -->

$config['db']['dbname'] = '46361m36800_10';

 

[Jeremy]

xf_ is the standard prefix to all XenForo tables.

 

[Paul B]

At least one of the tables is missing, possibly more.
Confirm in phpMyAdmin that the DB is viable.

 

[Slind]

phpmyadmin isnt workign anymore (forbidden), it worked yesterday, fuu.
any idea ?

 

[Slind]

i cant solve it, any idea what could be wrong with apache?

 

[Paul B]

Contact your host or server admin.

 

[Jeremy]

You may want to reach out to your host to help you with some of these server issues that are cropping up, they are the ones who would be able to help you the easiest.

 

[Slind]

Its a vserver...

permissions/users/groups are allright. apache setup is left.

 

[Jeremy]

Virtual server or not, unless you have the physical server in your house, you have a host that should be able to help.

 

[Slind]

i dont think, they will help or look into it.

 

[Jeremy]

Who do you host with? Is it shared, VPS, or dedicated? Managed or Unmanaged?

 

[Slind]

got apache working again

you are right there are a lot of tables missing.

How do i fix this, if I export them with default settings as bzip it only includes 136 of over 250 tables.

 

[Paul B]

Use SSH to dump the DB:

mysqldump -ucta -p --single-transaction --skip-lock-tables db_name > /path/to/backup/db_name_$(date +%d.%m.%y).sql

Then .zip it:

tar -czf db_name_$(date +%d.%m.%y).tar.gz /path/to/backup/db_name_$(date +%d.%m.%y).sql

Then copy it to the new server, unzip it and import it.

 

[Slind]

no shh on the webserver

 

[Jeremy]

How did you originally transfer the database? You'll have to redo the transfer.

 

[Slind]

i used phpmyadmin on the webserver to export it and imported it via phpmyadmin on the vserver

 

[Jeremy]

You'll have to redo the import via PhpMyAdmin again.

 

[borbole]

i used phpmyadmin on the webserver to export it and imported it via phpmyadmin on the vserver

How big is your db? Most server have a file size limit for phpmyadmins on their server so the backup/restore process can get corrupted.

Try another tool like mysqldumper for example. It handles both operations very nicely (backup&restore). The same goes for large files as well.