The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

PHPMYADMIN restored .sql doesn't show up in MYSQL Database

Discussion in 'Database Discussions' started by Caiterz, Mar 20, 2013.

  1. Caiterz

    Caiterz Registered

    Joined:
    Mar 20, 2013
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    Alright, so i backedup my ELGG Community via PHPMYADMIN -> Export

    then i went to my new host and went into PHPMYADMIN -> Import..

    and everything seemed fine....

    However....

    It doesn't show up in MYSQL.. So i cant add the user to that database...

    and Im a HUGE noob at this but here's the error im having..

    I get...

    [20-Mar-2013 04:03:28 America/New_York] Exception #1363766608: exception 'DatabaseException' with message 'Elgg couldn't select the database 'tricky01_elgg197', please check that the database is created and you have access to it.' in /home/tricky01/public_html/elgg/engine/lib/database.php:113
    Stack trace:
    #0 /home/tricky01/public_html/elgg/engine/lib/database.php(148): establish_db_link('readwrite')
    #1 /home/tricky01/public_html/elgg/engine/lib/elgglib.php(2144): setup_db_connections()
    #2 [internal function]: _elgg_engine_boot('boot', 'system', NULL)
    #3 /home/tricky01/public_html/elgg/engine/lib/elgglib.php(775): call_user_func_array('_elgg_engine_bo...', Array)
    #4 /home/tricky01/public_html/elgg/engine/start.php(99): elgg_trigger_event('boot', 'system')
    #5 /home/tricky01/public_html/elgg/index.php(12): require_once('/home/tricky01/...')
    #6 {main}


    and i THINK that it may be because that user doesn't have access to the database because it refuses to show up in MYSQL :O

    andd... if i try to CREATE it in MYSQL, it says "Already exists" even though i cant see it

    http://ft.trillian.im/b5fbe83b5f6825ccfc7c8392dccb383714df92ec/6ffRVgJcCdQoTHAY1EjEtJFnH6TQu.jpg

    http://ft.trillian.im/b5fbe83b5f6825ccfc7c8392dccb383714df92ec/6ffRNJEGzavGK30eCPLCroKVGoumD.jpg



    Any instructions can you write them step by step for a noob? Cuz that's what i am. ;-;

    Thanks <3
     
  2. Jeff Shotnik

    Jeff Shotnik Well-Known Member

    Joined:
    Oct 10, 2012
    Messages:
    61
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Denver, Colorado, United States
    cPanel Access Level:
    DataCenter Provider
    If you have root access, cd into /var/lib/mysql and make sure the database files have the same owner/group as other databases (should be mysql:mysql). If owner/group incorrect fix them with chown. If the owner/group are correct, trying using the database via mysql cli - run the following:

    # mysql
    > select tricky01_elgg197;
    > show tables;

    Any errors or different results?
     
  3. arunsv84

    arunsv84 Well-Known Member

    Joined:
    Oct 20, 2008
    Messages:
    373
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    127.0.0.1
    cPanel Access Level:
    Root Administrator
    You just need to contact your hosting provider and provide the database details including database name, user and password. They need to grant privileges to the database user to the database.

    Cheers!!!
     
Loading...

Share This Page