Can't create a migration

deliciousbrains / wp-migrate-db

WordPress plugin that exports your database, does a find and replace on URLs and file paths, then allows you to save it to your computer.

https://wordpress.org/plugins/wp-migrate-db/

341 stars 515 forks source link

Can't create a migration #101

Closed linkys closed 2 years ago

linkys commented 5 years ago

I created a new migration. After I tried to create another one, but got next error:

[Table '_mig_wpmdb_alter_statements' already exists] CREATE TABLE _mig_wpmdb_alter_statements ( query LONGTEXT NOT NULL )

{"migration_state_id":"5cfe583705fef"}

I suppose the plugin doesn't check if table is exists. What do you think?

dahousecat commented 4 years ago

I just tried to drop table table manually and got the error DROP command denied.

So I suspect that neither you are I have drop permission granted to the mysql user that our wordpress sites are using. Adding this permission should fix the problem.

kevinwhoffman commented 2 years ago

Hi there, I'm just following up on old issues. If this is still a problem with the latest version of WP Migrate DB 2.2.1, then please reopen and we can take another look.