Problem restoring database error code 1146

  • Resolved jpatricio

    (@jpatricio)


    7 years, 10 months ago

    Hi there,

    I am recently trying to restore a back-up I made with BackWPup, following the instructions which are on the website of the plug-in. However, I am having issues when importing the previous database to the new one, as it doesn’t finish the process. I have tried both with myphpadmin and with Admirer. These are the outcomes I get ib both ways:

    Error
consulta SQL:

/*!40000 ALTER TABLE <code>wp_cntctfrm_field</code> ENABLE KEYS */
MySQL ha dicho: Documentación

#1146 - Tabla 'name-of-the-database.wp_cntctfrm_field' no existe

    It seems there is a problem with one of the tables but I do not know how to solve it. I have tried to delete and create both the database and the whole WordPress site with identical results.

    I woud kindly appreciate if someone can helping regarding this issue. Should you need anyfurther information, do not hesitate to contact me.

    Best regards and thank youn in advanced,

    JP.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support happyAnt

    (@duongcuong96)

    7 years, 10 months ago

    @jpatricio
    Did you create a full database backup? because I can see that MySQL report that table ‘name-of-the-database.wp_cntctfrm_field’ didn’t not exits?

    Thread Starter jpatricio

    (@jpatricio)

    7 years, 10 months ago

    Helleo @duongcuong96,

    Thank you for you response. Yes, I did a full database Backup with the program. In addition, and also download again the database and I continue getting the same error.

    By the way, it would be: name-of-the-target-database.wp_cntctfrm_field

    With name-of-the-target-database I mean that that would be the database I am trying import to, which has a different name of the original database. Has this anything to do with the problem? Should the database both from the backup and the target datagase have the same name?

    Best regards and thank you again in advance,

    JP.

    Plugin Support happyAnt

    (@duongcuong96)

    7 years, 10 months ago

    @jpatricio
    No, the database name both don’t need to be the same.
    Could you contact your hoster and ask them about this?
    If you try to restore the database on your local environment ( xampp, wampp ), is it work normally?
    Also, In some case, the MySQL Server got a problem and need to restart can work correctly, you can contact your hoster and ask them for a help

    Plugin Support happyAnt

    (@duongcuong96)

    7 years, 10 months ago

    @jpatricio
    since we haven’t heard back from you, I’m going to mark it as resolved.
    If you’re still having problems, feel free to let us know ;),

    Btw, If you find BackWPUp is useful for you, we would really appreciate if you leave a positive review and rating.
    This would encourage us to develop new free features and provide free support 😀
    https://wordpress.org/support/plugin/backwpup/reviews/

    Thread Starter jpatricio

    (@jpatricio)

    7 years, 10 months ago

    Hello again,

    Thank you for your follow up. Sadly, I tried contacting my host and they told me everything was ok. So, unfortunately, I wan unable tonrestore the back up made with BackWPup.

    As this was a migrating proccess for one host to another, and thanksfully not a restoring proccess due to a data loss, I could use another migration plugin which worked perfectly when restoring the database.

    Best regards,

    JP.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Problem restoring database error code 1146’ is closed to new replies.