Community Forums
Connect with us on LinkedIn
+ Reply to Thread
Results 1 to 11 of 11
  1. #1
    Member
    Join Date
    May 2004
    Posts
    26

    Default database has proplem after restore

    hi everyone



    i used this /scripts/pkgacct ACCOUNTNAME& in ssh to backup all my accounts and moved them to backup hdd and then reload OS, after reloaded OS, i moved them back to /home and used Cpanel restore them. The proplem is my vbb forums does not work and other site using database don't work neither. The rest of html site are ok.


    here is the message:

    Code:
    There seems to have been a slight problem with the database.
    
    Please try again by pressing the refresh button in your browser.
    
    An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.
    
    We apologise for any inconvenience.


    Thanks for reading

  2. #2
    aby
    aby is offline
    Member aby's Avatar
    Join Date
    May 2005
    Location
    India
    Posts
    638

    Default

    Hello,

    please double check all the sites that connect to the database is having the issue. Also try to connect to the database from the shell and verify whether it is working for you. Sometimes there can be issue with the php connecting to the database. It can help if you can recomplie apache with the php and you might also try changing the php version to one higher. i can't say that this is exactly the issue with out actually looking at it. But these are all worth a try.
    Aby

    MSN "abyvarghese007"
    Yahoo " abyattaikkulathu"

    http://slashome.com

  3. #3
    Member
    Join Date
    Oct 2004
    Location
    Chicago, IL
    Posts
    15

    Default

    I am having this problem too with ALL account transfers. This is a SERIOUS problem. The accounts restore fine but the databases do not.

  4. #4
    Member
    Join Date
    Oct 2004
    Location
    Chicago, IL
    Posts
    15

    Default

    in cpanel's mysql section, it doesn't show the database listed, even though whm says that it transfers in the account transfer page. this is happening with ALL accounts i transfer through whms account transfer tool.

  5. #5
    Member
    Join Date
    Aug 2004
    Posts
    77

    Default

    honestly. I'd suggest to submit a support ticket and then let us know what ya found out.

    I plan to migrate to a new server soon so it'd be usefull information.

  6. #6
    Member
    Join Date
    Oct 2004
    Location
    Chicago, IL
    Posts
    15

    Default

    i tried downgrading whm back to the stable version on both servers. it still didn't fix the problem. i'm getting worried now.

  7. #7
    Member
    Join Date
    Oct 2004
    Location
    Chicago, IL
    Posts
    15

    Default

    i'm getting very frustrated.
    cpanel doesn't have any direct support options?
    Last edited by white sox; 07-27-2005 at 09:11 PM.

  8. #8
    Moderator cPanel Partner NOC Badge dgbaker's Avatar
    Join Date
    Sep 2002
    Location
    Toronto, Ontario Canada
    Posts
    2,773

    Default

    A ticket is a good idea if stuck. One thing to check is that everything in /var/lib/mysql is owned by mysq:mysql and if not already done, restart mysql
    Regards,
    David
    Forum Moderator

  9. #9
    Member
    Join Date
    Oct 2004
    Location
    Chicago, IL
    Posts
    15

    Default

    upgrade to the newest edge version before doing the backup or restore. it fixes the problem.

  10. #10
    Member
    Join Date
    May 2004
    Posts
    26

    Default

    Quote Originally Posted by white sox
    upgrade to the newest edge version before doing the backup or restore. it fixes the problem.

    to update to newest edge version , use this command : scripts/upcp --force , am i right ?

  11. #11
    Secret Agent
    Guest

    Default

    I'm facing this problem also, Spent hours restoring accounts

    Any safer, faster way to resolve this?

Similar Threads & Tags
Similar threads

  1. [ask]how to restore PostgreSQL database
    By gamgam in forum Data Protection
    Replies: 1
    Last Post: 06-01-2008, 02:43 AM
  2. Database restore not working
    By dare2audition in forum Database Discussions
    Replies: 0
    Last Post: 02-18-2008, 08:32 AM
  3. sceduled database restore?
    By m.bergmannn in forum cPanel and WHM Discussions
    Replies: 1
    Last Post: 06-22-2006, 06:05 PM
  4. Restore mysql database only?
    By lexmark in forum cPanel and WHM Discussions
    Replies: 3
    Last Post: 01-10-2005, 09:54 AM
  5. Database restore problems!
    By Stevie in forum cPanel and WHM Discussions
    Replies: 2
    Last Post: 01-06-2004, 04:05 AM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube