MySQL and CPanel Question

by 7 replies
8
I am having a problem with my hosting. I will skip all of the crap that has happened the last week or so and get right to the main problem right now. I have lost one of my MySQL databases for one of my WordPress sites. I have a full backup of the Cpanel from earlier this week. Is there anyway I can restore this database from the full CPanel backup that I have on my hard drive. Even restoring the full Cpanel would be OK, but I think that is not possible from what I read.

If I look inside the full CPanel backup I see the files "arimmark_wp436.create" and "arimmark_wp436.sql" in the folder, "mysql" .

Then, how can I make sure that database is associated with the proper WordPress site.

My Host was doing some repairs on my account last week and they somehow got the wrong database attached to the one of my websites. This database held all of the data for a different website. I never noticed the mixup until after I had uninstalled one of my sites using Softaculous. Afterwards I noticed the other site that I really need was not working and giving me an error, "Error establishing a database connection" I looked in PHPMyAdmin and the database was gone. With it several hundred articles and comments and the setup for the website....

Thanks
Johnnie
#programming #cpanel #mysql #question
  • Hi Johnnie,

    Hit me up on Skype buddy and we can sort this out, You can simple re-create the database in cPanel and then using PHPMyAdmin upload the .sql file which will re-create all the missing datas.

    Skype: stuart.macfarlane1985

    Kind Regards,
    Stuart Macfarlane
    • [1] reply
    • Thanks for the help offer Stuart, I left you a request and message in Skype when you get a chance.

      Thanks
      Johnnie
      • [1] reply
  • Glad everything is working okay for you now. Thumbs up to Stuart
    • [ 1 ] Thanks
Join the discussion

Next Topics on Trending Feed

  • 8

    MySQL and CPanel Question

    I am having a problem with my hosting. I will skip all of the crap that has happened the last week or so and get right to the main problem right now. I have lost one of my MySQL databases for one of my WordPress sites. I have a full backup of the Cpanel from earlier this week. Is there anyway I can restore this database from the full CPanel backup that I have on my hard drive. Even restoring the full Cpanel would be OK, but I think that is not possible from what I read. If I look inside the full CPanel backup I see the files "arimmark_wp436.create" and "arimmark_wp436.sql" in the folder, "mysql" .