Sooner or later there is a need to move a site on CMS WordPress to a local server. The task is actually quite simple, but there are occasional errors. Today we’re going to talk about a database migration error:
SQL query:
Current Database: `database_name`
Table structure for table `wp_aiowps_events’
If you need help, you can email admin@workinnet.ru
The essence of the error
Let’s assume we have local hosting installed OpenServer. We have selected the right version of of php (I choose 7.2) and mysql (5.6). The database is uploaded correctly from the server, the weight is normal, in extreme case we edited the file php.ini and specified a different size.
It’s okay. Running phpmyadmin. Clicked import, started uploading, but immediately the following error pops up:
SQL query: -- Current Database: `database_name` --- Table structure for table `wp_aiowps_events` -DROP TABLE IF EXISTS `wp_aiowps_events` MySQL Response: #1046 - Database not selected
You let out a loud “WTF!” and start looking for the problem in the database itself or google it. OOPS! For some reason there is no information, and it is not clear what to do with the base.
Don’t worry, all is not lost ?
Decision
So, it’s really quite simple. Press в phpmyadmin “Create DB.” Creating DB with the same name as the imported base. Let’s pick her. After that, go to the import tab. Select the desired database, import it. Problem solved.
As you can see, it’s pretty simple. The name of the database can be copied from the file wp-config.php, which is located in the root folder of the site. Other than that, there should be no problems.
