MySQL Dump/Restore

MySQL
Jul 192010

MySQL Dump/Restore

Dump ALL MySQL Databases
mysqldump –user=user_name –password=password -A > /PATH/TO/DUMPFILE.SQL

Dump Individual or Multiple MySQL Databases
mysqldump –user=user_name –password=password –databases DB_NAME1 DB_NAME2 DB_NAME3 > /PATH/TO/DUMPFILE.SQL

Dump only certain tables from a MySQL Database
mysqldump –user=user_name –password=password –databases DB_NAME –tables TABLE_NAME > /PATH/TO/DUMPFILE.SQL

To make dumps compatible with older versions add the following switch:
–compatible=mysqlXXX

Use the following to reload the contents of a database:

mysql –verbose –user=user_name –password=password DB_NAME < /PATH/TO/DUMPFILE.SQL

Add PHP to HTML files with .htacess

Linux, Mac
Jul 012010

For web servers using PHP as apache module:

AddType application/x-httpd-php .html .htm

For web servers running PHP as CGI:

AddHandler application/x-httpd-php .html .htm

In case you wish to do the ASP mimick:

For PHP as module:

AddType application/x-httpd-php .asp

OR

For PHP as CGI:

AddHandler application/x-httpd-php .asp

© 2012 James Border Suffusion theme by Sayontan Sinha