Is there a plugin to restore my .sql file using frontend?

  • shaansh

    (@shaansh)


    10 years ago

    Hello,

    I am working for a client who needs me to restore her old database backup. Usually I do this using phpMyAdmin but for some reason I cannot authenticate to her phpMyAdmin (host is hostmetrics.net and the cPanel works fine but I cannot access the phpMyAdmin).

    Anyway, I have the .sql file and was wondering if there’s a way to restore this using front end.

    Thank you

Viewing 1 replies (of 1 total)
  • Moderator bcworkz

    (@bcworkz)

    The .sql file should mainly be a series of queries of which you can run $wpdb->query() using each single query in turn. I don’t know if there’s a plugin available, available plugins is not part of my knowledge base.

    It shouldn’t be too bad a project to come up with code that could parse through a .sql file to extract individual query strings and run them with $wpdb->query(). Since you just need to get this one job done, you don’t need much of an user interface, which is where a lot of coding effort often goes. The actual mechanics seem straight forward enough.

Viewing 1 replies (of 1 total)
  • The topic ‘Is there a plugin to restore my .sql file using frontend?’ is closed to new replies.