Please post the exact error messages you are getting, as well as the path for the URL you trying to access.
You may not have database access granted to the user, or it may be as simple as the table prefix is wrong in your wp-config.php file for your site.
Thread Starter
owennd
(@owennd)
So this is exactly what i done.
1. Backed up XAMPP and renamed as XAMPP_old
2. Uninistall and reinstalled XAMPP.
3. Copied over htdocs and database files from XAMPP_old for existing websites
4. Ran XAMPP > seems to be working fine
5. Go to URL localhost\site (then prompts be to re-download WordPress but it shouldnt)
6. Checked database files in MySQL but get error #1932 saying files are missing
7. Checked the WP-Config.php files, appears to have the correct table prefix
8. If I reinstall WordPress then it comes up with a huge page of error messages relating to the databases.
I feel a bit stuck as I can’t access my WordPress website.
You mentioned database access granted to the user, is this via MySQL cpanel? If so I did also grant all access to all users.
My other way around could be to manually upload the WP-content files from the htdocs via FTP, but not sure how i’ll get the databases online?
Thanks for your help on this issue.
> 6. Checked database files in MySQL but get error #1932 saying files are missing
Please post exact error messages.
> You mentioned database access granted to the user
Yes, it should look like this :
View post on imgur.com
Are you sure you can load php pages through xampp?
Thread Starter
owennd
(@owennd)
Exact error message: #1932 – table ‘ ‘ doesn’t existing in engine.
If i export this database and then open the .sql file, i get this error for every table:
https://imgur.com/5Z4nF8j
I can load the php through xampp yes.
This is interesting bc it’s blank :
Exact error message: #1932 – table ‘ ‘
Forget about xampp if you think its running properly.
Focus on WordPress – I would re-install the WordPress core, and then I would run a repair on my tables :
https://www.hostgator.com/help/article/how-to-install-wordpress-manually
https://dev.mysql.com/doc/refman/5.7/en/rebuilding-tables.html
But realistically, it should take you 5 minutes to just start over.
Download fresh wordpress,
Dump it in your htdocs folder in xampp,
Extract it, rename the folder to test2
Hit localhost/test2 in your browser and reinstall.
If your database tables were created with the MyISAM storage engine, then it should be easy to recover the database as long as its tables aren’t corrupted/crashed beyond repair.
However, the tables were likely created with the InnoDB storage engine, which is the default storage engine in MySQL 5.6 or newer.
If the MySQL service was still running in Xampp when you made your file backup, then your database tables are probably lost if they were InnoDB. If the innodb_file_per_table setting was zero or OFF, then the tables are definitely lost and there is no hope of recovery.
There are ways to recover InnoDB tables in the former situation, but that is well beyond the purpose of this site. I suggest looking at dba.stackexchange.com, serverfault.com, or superuser.com.
