8 {{ upvoteCount | shortNum }}
8 {{ upvoteCount | shortNum }}

MySQL and CPanel Question

by yohoho
7 replies
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
#cpanel #mysql #question
  • Profile picture of the author Stuart Macfarlane
    Originally Posted by yohoho View Post

    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
    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
    {{ DiscussionBoard.errors[6047711].message }}
    • Profile picture of the author yohoho
      Originally Posted by Stuart Macfarlane View Post

      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
      Thanks for the help offer Stuart, I left you a request and message in Skype when you get a chance.

      Thanks
      Johnnie
      {{ DiscussionBoard.errors[6048911].message }}
      • Profile picture of the author Stuart Macfarlane
        Originally Posted by yohoho View Post

        Thanks for the help offer Stuart, I left you a request and message in Skype when you get a chance.

        Thanks
        Johnnie
        Hi Johnnie,

        I've added you and left you a message, I just switched over to Skype on my laptop (same account) and cannot see you in my list of contacts!

        Please PM me your Skype ID if you cannot see me online...

        I'll be around for the next 2-3hours.

        Kind Regards,
        Stuart Macfarlane
        {{ DiscussionBoard.errors[6049736].message }}
        • Profile picture of the author yohoho
          Originally Posted by Stuart Macfarlane View Post

          Hi Johnnie,
          I've added you and left you a message, I just switched over to Skype on my laptop (same account) and cannot see you in my list of contacts!
          Please PM me your Skype ID if you cannot see me online...
          I'll be around for the next 2-3hours.
          Kind Regards,
          Stuart Macfarlane
          Once again I have to thank you for your help Stuart. Glad to say it was a successful mission, and data recovery side mission.

          Best to you.
          Johnnie
          {{ DiscussionBoard.errors[6054043].message }}
          • Profile picture of the author Kingfish85
            Originally Posted by yohoho View Post

            Once again I have to thank you for your help Stuart. Glad to say it was a successful mission, and data recovery side mission.

            Best to you.
            Johnnie
            It's good to see that you got this issue worked out. It's also good to see that Stuart helped you out!
            Signature

            |~| VeeroTech Hosting - sales @ veerotech.net
            |~| High Performance CloudLinux & LiteSpeed Powered Web Hosting
            |~| cPanel & WHM - Softaculous - Website Builder - R1Soft - SpamExperts
            |~| Visit us @veerotech Facebook - Twitter - LinkedIn

            {{ DiscussionBoard.errors[6054063].message }}
          • Profile picture of the author Stuart Macfarlane
            Originally Posted by yohoho View Post

            Once again I have to thank you for your help Stuart. Glad to say it was a successful mission, and data recovery side mission.

            Best to you.
            Johnnie
            It was a pleasure helping you Johnnie. Good luck with your future endevours.
            {{ DiscussionBoard.errors[6054236].message }}
  • Profile picture of the author topnichewebsites
    Glad everything is working okay for you now. Thumbs up to Stuart
    Signature
    http://pixelcovers.com/ <- eBook add eCovers

    https://www.unicommercesolutions.com <- WordPress Websites and Maintenance
    {{ DiscussionBoard.errors[6054239].message }}

Trending Topics