Problem with mysql it show 0B please help

Status
Not open for further replies.

xuancong6000

Verified User
Joined
Oct 12, 2012
Messages
79
In my VPS one user have mysql show 0B I had tried delete that user and restore old backup but it's still again
Please help me how can I fix it
 

nobaloney

NoBaloney Internet Svcs - In Memoriam †
Joined
Jun 16, 2003
Messages
26,119
Location
California
Have you tried optimizing or repairing the database?

Have you checked file ownership comparing this user to others?

Do the databases work?

Jeff
 

xuancong6000

Verified User
Joined
Oct 12, 2012
Messages
79
Have you tried optimizing or repairing the database?

Have you checked file ownership comparing this user to others?

Do the databases work?

Jeff
I' had used Admin Backup/Transfer for restoring after that it's show 0B all site is working ok but when I check on /var/lib/mysql/xen_data... don't have any database on that location
can you tell me how can i check file ownership?
 

nobaloney

NoBaloney Internet Svcs - In Memoriam †
Joined
Jun 16, 2003
Messages
26,119
Location
California
Where is the database located?

Where are the databases that do work?

What makes you think that you should be checking for /var/lib/mysql/xen_data? There's no database by that name in your attached image.

Jeff
 

xuancong6000

Verified User
Joined
Oct 12, 2012
Messages
79
Where is the database located?

Where are the databases that do work?

What makes you think that you should be checking for /var/lib/mysql/xen_data? There's no database by that name in your attached image.

Jeff
/var/lib/mysql/xen_data... mean
/var/lib/mysql/xen_album
/var/lib/mysql/xen_datnghean
/var/lib/mysql/xen_osama
/var/lib/mysql/xen_phapluat
I config my website using:
xen_album
xen_datnghean
xen_osama
xen_phapluat
and it working but I can't find any file on that location /var/lib/mysql/
 

SeLLeRoNe

Super Moderator
Joined
Oct 9, 2004
Messages
6,788
Location
A Coruña, Spain
You mean that does folders doesnt exist?
Does the /var/lib/mysql folder exist? Is it empty?
What OS are you using? Are you sure the path of /var/lib/mysql is the right one for your OS?

Are you able to see DB's in phpMyAdmin? Have you tryed repair them?

Regards
 

xuancong6000

Verified User
Joined
Oct 12, 2012
Messages
79
You mean that does folders doesnt exist?
Does the /var/lib/mysql folder exist? Is it empty?
What OS are you using? Are you sure the path of /var/lib/mysql is the right one for your OS?

Are you able to see DB's in phpMyAdmin? Have you tryed repair them?

Regards
I'm using centos 6 64bit i'm sure that right path of mysql database because I can see all data on that /var/lib/mysql/* I try to login into phpmyadmin by use that include data:
xen_album
xen_datnghean
xen_osama
xen_phapluat
but all is empty:(
 

SeLLeRoNe

Super Moderator
Joined
Oct 9, 2004
Messages
6,788
Location
A Coruña, Spain
You may try to repair tables and db's: witht his:

/usr/bin/mysqlcheck --defaults-extra-file=/usr/local/directadmin/conf/my.cnf --auto-repair --analyze --all-databases


Regards
 

zEitEr

Super Moderator
Joined
Apr 11, 2005
Messages
13,818
Location
GMT +7.00
Hello,

I guess, that since backup/restore were performed no need to check tables. I guess someone should login into the server and check it and fix it.
So please feel free to contact those of us here who you trust most for a quote to fix your issue.
 

SeLLeRoNe

Super Moderator
Joined
Oct 9, 2004
Messages
6,788
Location
A Coruña, Spain
But he sayd he used to restore a backup, not placing a backup.. so my guess is that if he try to make a backup it fail on those DB's... am i wrong?

Regards
 
Status
Not open for further replies.
Top