wp_ tables gone after restoration of backup

  • Hello,

    I took a backup of my site using cpanel as i was moving hosts. When i went to transfer everything over all the tables are there accept the wp_ ones like wp_options. Is there a way I can save the rest of my db and its data but add the wp_ tables back? I have already tried deleting all the tables and reuploading via phpmyadmin but that didn’t work. I have since lost access to the original host so all i have is the full backup of all the files (or i guess all the files accept the wordpress ones).

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

  • It seems that your database backup uses different prefix than default installation of WordPress. Can you check the database using some tool (I assume phpmyadmin if you are using cpanel) and see what prefix tables are using?

    The prefix for the tables can be found in the wp-config.php file. You can find this via FTP and can also edit it there. If you need help connecting via FTP, please contact your hoster’s support team.

    • This reply was modified 6 days, 2 hours ago by threadi.

    @loganddiamond

    edit: yes, the better and safer way should be reading the settings from the old wp-config file preserved in backup, as @threadi suggested.

    • This reply was modified 6 days, 2 hours ago by rjekic.
Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.