search

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

Hex-Blob Error #135

Open marcostalder85 opened 2 years ago

marcostalder85 commented 2 years ago

I've found out, when you use some transaction plugins who stores the whole transactions as a blob, and you want to import this SQL-file, you will get an error.

So the workaround is, that we have to clean the INSERTs of this table and export it separately etc...

Maybe there is a good way to add --hex-blob or turn blob into a good importable option.

kevinwhoffman commented 2 years ago

Hey @marcostalder85, could you let us know which transaction plugin you are using and provide us with steps to recreate the error so we can look into this further?

marcostalder85 commented 2 years ago

Hey @kevinwhoffman . We used the most used plugin for DataTrans I could send you the zip file directly or an sql dump without wp-migrate-db.