I managed to import a backup website into flywheel by dragging the ZIP file onto the app.
The website works fine.
I did this with another website that I have backed up and when I open the view the site I get the following error message:
wp-config.php file has an empty database table prefix, which is not supported.
Do you think this can be fixed somehow or I have to rebuild the site from scratch?
That happens because somehow the variable “$table_prefix” in your
wp-config.php file seems to be empty , which should be a fairly simple thing to solve, don’t worry… Inside your site folder’s root you will find your “wp-config.php” file. Below there is an image that shows where this variable is located inside the file:
To know what to fill there, you have to open your database.
The prefix, is the part of the table’s name that normally comes before the underline (an underline is often used to separate the table’s name from the prefix), in the example below, the prefix is “wp_”.
So when filling the value, be sure to include the underline in it.
For the example above the correct value is:
$table_prefix = 'wp_';
So fill your file with the prefix you see on the database and you should be good to go!
See if that solves your problem!
If you need any further help just say it and I’ll be notified
Unfortunately my database seems to be completely missing.
When I open the site in the Adminer there are no tables
I also tried to search for the database sql file, but its also gone
There is no sql folder in the app folder
I don’t understand why the sql file is missing because last time I opened up this site with to work on it with
the previous version of local, it was working
I am having this exact same problem.
We are taking over development of an existing Flywheel site but cannot edit it locally.
I am using the version 2.4.2 of Local on windows 10 and if I try to import a backup or I try and pull a flywheel site into local for editing, I end up with this error and the database is not there when I use Adminer to look at sql.
I have uninstalled and re-installed local but this still is happening every time!
Any response would be greatly appreciated.
Regarding your problem, Flywheel specific problems run out of my knowledge, but if the site works fine live, in production, it should work on Local. Something wrong might be happening when pulling the database from Flywheel to Local.
You could try to make a different backup/migration to Local, using All-in-One WP Migration (https://br.wordpress.org/plugins/all-in-one-wp-migration/) or Duplicator (https://wordpress.org/plugins/duplicator/)
That way you won’t use Local’s import feature, and rather use Wordpress import through one of those plugins.