MySQL databases not usable after upgrading

Problems with the Linux version of XAMPP, questions, comments, and anything related.

MySQL databases not usable after upgrading

Postby jackeapen » 18. September 2017 06:51

Hi,

I have been using XAMPP on linux 64-bit. Recently I upgraded to XAMPP 5.6.31. But after upgrading my databases are not usable (earlier it was MySQL. Now MariaDB). In phpmyadmin the table are showing as "in use". while accessing tables via command line, error is shown as "ERROR 1932 (42S02): Table 'sunit_kbase.wp_posts' doesn't exist in engine".

I had the backup for a few databases, and could restore them from backup. for one particular database, I don't have a backup. MySQL data folder has the files for tables- .frm and .ibd

Is there any way I can restore my data using these files? mysqldump is also showing error
jackeapen
 
Posts: 7
Joined: 07. June 2007 05:05

Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 6 guests