BAROTTA Posted November 14, 2022 Posted November 14, 2022 Table already exists error duplicate error Please help me fix
Jim M Posted November 14, 2022 Posted November 14, 2022 You would want to dump the database before restoring. Please contact your hosting provider for assistance.
Randy Calvert Posted November 14, 2022 Posted November 14, 2022 You can't import data into something that exists. Everything in the database that is already there needs to be deleted first. SeNioR- 1
BAROTTA Posted November 15, 2022 Author Posted November 15, 2022 Can someone tell steps for dumping database please?
Gary Posted November 15, 2022 Posted November 15, 2022 12 hours ago, Jim M said: You would want to dump the database before restoring. Please contact your hosting provider for assistance. Hi @BAROTTA, 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.
Richard Arch Posted November 15, 2022 Posted November 15, 2022 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. 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. Gary 1
Recommended Posts