--------------------------------------------------------------------------------
EXPORTING / IMPORTING DATABASES
--------------------------------------------------------------------------------

EXPORT DATABASE (make sure you are in the folder you want to create the database file in)
mysqldump --add-drop-table -u database-username -p database > domain_zwire.sql

IMPORT DATABASE (make sure you are in the folder you want to import the database file in)
mysql -u database-username -D database -p < database.sql

--------------------------------------------------------------------------------
COMPRESSING / DECOMPRESSING FILES
--------------------------------------------------------------------------------

COMPRESS FOLDER AND FILES:
tar czvf folder.tar.gz folder

DECOMPRESS FOLDER AND FILES:
tar -zxvf folder.tar.gz

--------------------------------------------------------------------------------
SECURING FOLDERS/FILE PERMISSIONS TO BE WRITTEN BY SERVER. MUST BE LOGGED IN AS ROOT.
--------------------------------------------------------------------------------

TYPO3 SPECIFIC

chgrp -R nobody /home/domain/public_html/typo3conf
chmod -R g+w,o-rwx /home/domain/public_html/typo3conf

chgrp -R nobody /home/domain/public_html/uploads
chmod -R g+w,o-rwx /home/domain/public_html/uploads

chgrp -R nobody /home/domain/public_html/fileadmin
chmod -R g+w,o-rwx /home/domain/public_html/fileadmin

chgrp -R nobody /home/domain/public_html/typo3temp
chmod -R g+w,o-rwx /home/domain/public_html/typo3temp


FOR DEVELOPMENT / SUBDIRECTORY

chgrp -R nobody /home/domain/public_html/dev1
chmod -R g+w,o-rwx /home/domain/public_html/dev1

--------------------------------------------------------------------------------
SHELL COMMAND ROUTINES FOR INSTALLING/TRANSFERRING TYPO3 BETWEEN domainS/SERVERS
--------------------------------------------------------------------------------

COPYING OVER FULL LIVE SITE TO DEVELOPMENT DIRECTORY
cp -p /home/domain/public_html/*.* /home/domain/public_html/dev1
cp -pr /home/domain/public_html/fileadmin /home/domain/public_html/dev1
cp -pr /home/domain/public_html/misc /home/domain/public_html/dev1
cp -pr /home/domain/public_html/t3lib /home/domain/public_html/dev1
cp -pr /home/domain/public_html/typo3 /home/domain/public_html/dev1
cp -pr /home/domain/public_html/typo3conf /home/domain/public_html/dev1
cp -pr /home/domain/public_html/typo3temp /home/domain/public_html/dev1
cp -pr /home/domain/public_html/uploads /home/domain/public_html/dev1

MOVING LIVE SITE TO SUB DIRECTORY BE REPLACED BY DEVELOPMENT SITE
mv /home/domain/public_html/*.* /home/domain/public_html/dev
mv /home/domain/public_html/fileadmin /home/domain/public_html/dev
mv /home/domain/public_html/misc /home/domain/public_html/dev
mv /home/domain/public_html/t3lib /home/domain/public_html/dev
mv /home/domain/public_html/typo3 /home/domain/public_html/dev
mv /home/domain/public_html/typo3conf /home/domain/public_html/dev
mv /home/domain/public_html/typo3temp /home/domain/public_html/dev
mv /home/domain/public_html/uploads /home/domain/public_html/dev

COPYING DEVELOPMENT SITE TO LIVE
cp -p /home/domain/public_html/dev1/*.* /home/domain/public_html/
cp -pr /home/domain/public_html/dev1/fileadmin /home/domain/public_html/
cp -pr /home/domain/public_html/dev1/misc /home/domain/public_html/
cp -pr /home/domain/public_html/dev1/t3lib /home/domain/public_html/
cp -pr /home/domain/public_html/dev1/typo3 /home/domain/public_html/
cp -pr /home/domain/public_html/dev1/typo3conf /home/domain/public_html/
cp -pr /home/domain/public_html/dev1/typo3temp /home/domain/public_html/
cp -pr /home/domain/public_html/dev1/uploads /home/domain/public_html/