Jump to content

After restoration of database via phpmyadmin

Recommended Posts

12 hours ago, Jim M said:

You would want to dump the database before restoring. Please contact your hosting provider for assistance.


You would have to get in touch with your hosting provider as my colleague has advised. There are also ample resources online to assist you with this if you know your way around your server. Unfortunately, anything server-side on self-hosting plans are not within our scope for support.

Link to comment
Share on other sites

9 hours ago, BAROTTA said:

Can someone tell steps for dumping database please?

We don't have enough info so I've made a lot of assumptions here.

It seems your back does not contain any DROP statements which would be fine if you were to restore to a new database but it seems in this case you wanted to overwrite the existing tables/data.  You could drop all the tables in this database and use your backup OR create a new database and use your backup to create the tables and add the data.

At a guess, it sounds like you did a custom backup using phpMyAdmin without the Add DROP option checked.

Could contain: Page, Text

Could contain: Page, Text, File


As Gary hinted, an online search will find lots of suggestions and help.  PhpMyAdmin is very powerful, it takes the complexity out of working with databases but we need to learn how to use it as we do on how to drive a car.

I suggest stay away from your live database, for now, and that you create a new database to play with.  Check out the Operations tab and the "Copy Database to" option.  Make sure you are viewing the database you want to copy, then enter what you want to call it and press the Go button.

Could contain: Page, Text, White Board


Link to comment
Share on other sites

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...