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

[Caiterz]

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]

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]

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!!!