Saturday, March 8, 2014

phpmyadmin - Database imported successfully but tables are not visible

phpmyadmin not showing tables

List the views in the database using following query
SHOW FULL TABLES IN database_name WHERE TABLE_TYPE LIKE 'VIEW';
Just edit the database_name in above query, it will list all the views of database.
Remove all the views.

Now the tables will be visible.

ubuntu/debian - Temporary failure resolving ‘sites in sources.list’

ubuntu/debian - Temporary failure resolving ‘sites in sources.list’

If you are trying to download packages using terminal and you are facing this error, check these things first.

If you are using proxy, proxy address should be defined in these files.
1) check /etc/apt/apt.conf file for proxy
2) check /etc/environment file for proxy


If you are not using proxy, make sure proxy settings should be removed from above files.

If above files are according to requirement and you are still facing this problem, try this solution.

Open file /etc/resolv.conf, add following line in the file and save it.
nameserver 8.8.8.8

8.8.8.8 is google's public DNS address.


Now restart networking and try to install packages again.

Centos - 14: PYCURL ERROR 6 - "Couldn't resolve host 'mirrorlist.centos.org'"

Centos - 14: PYCURL ERROR 6 - "Couldn't resolve host 'mirrorlist.centos.org'"

If you are trying to download packages using terminal and you are facing this error, try this solution.

Open file /etc/resolv.conf, add following line in the file and save it.
nameserver 8.8.8.8

8.8.8.8 is google's public DNS address.


Now restart networking and try to install packages again.