Support for mysql exports

[KKParticipant]

Hi David,

Do you have any plans to add support to mysql export files?

Thanks

[udadminKeymaster]

Hi Karim,

UpdraftPlus’s database exports are ordinary SQL files already.

David

[KKParticipant]

Hi David,

Thanks for your prompt reply.

If I have a .sql file which I have exported from phpmyadmin, could you please tell me how can I import it using updraft instead of going into the phpmyadmin and import from there?

Thanks

[udadminKeymaster]

Hi Karim,

You can rename it to match the filename pattern of an UpdraftPlus database file ending in -db ; and then gzip it, if it’s not already gzipped (use 7-zip if you’re on WIndows). Then you should be able to drag-drop it into UpdraftPlus’s restoration area.

Note that it’ll need to contain SQL that does not hard-code any references to databases. i.e. no statements like “USE my_database” or crazy stuff like “DROP ALL DATABASE”. UpdraftPlus will happily run all the SQL it finds there. So, if it’s got anything hard-coded or crazy, then it will do whatever it is told!

David

[Author]

Posts