Lost my tables!

  • Resolved sooren

    (@sooren)


    7 years, 11 months ago

    Hello Tobias,

    I have a serious problem, please help me 🙁

    I’ve moved my website to a new hosting service provider yesterday. Everything seems fine except all of my created Tables are gone! Please guide me how can I find them in the previous host’s data or in my backup files and then copy them to the new host or any other solution to fix this issue. I’m very anxious and nervous now.

    Thank you in advance.

    Best,
    Ali

Viewing 11 replies - 1 through 11 (of 11 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    7 years, 11 months ago

    Hi,

    thanks for your post, and sorry for the trouble.

    How exactly did you move to the new host?
    Do you still have access to the old site?

    Regards,
    Tobias

    Thread Starter sooren

    (@sooren)

    7 years, 11 months ago

    The new Host support center did it for me, They backup the whole site from previous host and then restored it to the new one and then created and moved all databases also in new place.

    I have access to the previous host and and website files there but I can’t lunch the website from there. (just access to the files which still are there)

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    7 years, 11 months ago

    Hi,

    the files won’t help, we need access to the database, e.g. with a tool like “phpMyAdmin”.
    TablePress stores the tables in the wp_posts database table, as entries with tablepress_table in the post_type field.
    In addition, it needs two entries from the wp_options database table, tablepress_options and tablepress_tables.

    If you still had access to the old site, you could export the tables there, on the “Export” screen of TablePress.

    Regards,
    Tobias

    Thread Starter sooren

    (@sooren)

    7 years, 11 months ago

    I can try to use PhpMyAdmin tool for this matter.

    But still there is a question for me, They have moved all things to the new host so why should it happens? any idea?

    • This reply was modified 7 years, 11 months ago by sooren.
    Plugin Author Tobias Bäthge

    (@tobiasbg)

    7 years, 11 months ago

    Hi,

    well, apparently they did not move all the things, or they broke/corrupted something.
    Do you have phpMyAdmin access to the old or the new site, or both?

    I recommend to look for what I described above and compare it.

    Regards,
    Tobias

    Thread Starter sooren

    (@sooren)

    7 years, 11 months ago

    I have access to the phpMyAdmin in the new host but in the previous host it asks for username and password which I don’t have and I need to send them a ticket and ask for sending me.

    If I restore the whole main database of the website by myself, can it be helpful??? (I have several backup which I can restore the latest one)

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    7 years, 11 months ago

    Hi,

    ah, bummer.

    Yes, restoring the site yourself should also be worth a try.
    I recommend creating another backup of the current state of the new site’s database though, using phpMyAdmin.
    Then, re-import your own database backup.

    Regards,
    Tobias

    Thread Starter sooren

    (@sooren)

    7 years, 11 months ago

    Thank you so much dear Tobias for your help. well I will take my chance then and try to follow your instructions step by step. I will let you know if I could solve the problem.

    As always, you’re the best.

    Yours sincerely,
    Ali

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    7 years, 11 months ago

    Hi Ali,

    great! Sounds good!

    Regards,
    Tobias

    Thread Starter sooren

    (@sooren)

    7 years, 11 months ago

    Dear Tobias,

    I fixed the problem by importing the website’s main database from previous host again and now my tables are back 🙂

    Thank you again for your time and the great support of yours. wish you all the best.

    Ali

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    7 years, 11 months ago

    Hi,

    no problem, you are very welcome! 🙂 Good to hear that this helped!

    Best wishes,
    Tobias

    P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘Lost my tables!’ is closed to new replies.