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

Caiterz

Registered
Mar 20, 2013
1
0
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
 

Jeff Shotnik

Well-Known Member
Oct 10, 2012
61
0
6
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?
 

arunsv84

Well-Known Member
Oct 20, 2008
373
1
68
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!!!