Archive for the 'apache' Category

This is a list of the most common used mySQL Commands

General Commands

USE database_name

Change to this database. You need to change to some database when you first connect to MySQL.

SHOW DATABASES

Lists all MySQL databases on the system.

SHOW TABLES [FROM database_name]

Lists all tables from the current database or from the database given in the command.

DESCRIBE table_name

SHOW [...]


In some cases you need to make a custom script for uploading files or even update / synchronize two databases.  The php execution time has some restrictions, for security reasons. If a scripts takes more than apache server expects to take the whole procedure stops and your update script does not complete what its meant [...]