If you are a web developer building PHP/MySQL powered sites, the ultimate scenario is to test your applications before uploading them to the main web hosting server. A lot of developers set up test accounts on live web servers, however this means you always need to be connected to the web to test them. But there is another way using one of two ingenious applications that make setting up your own Apache/MySQL/PHP an absolute breeze.

Sometimes a MySQL database is simply too large to backup on a web based interface. In the event of this occurring, it is fairly easy to backup a database via SSH; all it takes is one command. This tutorial will show you how.

This video will show you how to search databases in phpmyadmin.

This video will show you how to rename tables in phpmyadmin.

This video will show you how to run SQL queries in phpmyadmin.

This video will show you how to modify fields in tables in phpmyadmin.

This video will show you how to insert fields into tables in phpmyadmin.

This video will show you how to import databases and tables in phpmyadmin.

This video will show you how to become familiar with databases and phpmyadmin.

This video will show you how to expore databases and tables in phpmyadmin.

This video will show you how to delete a table in phpmyadmin.

This video will show you how to delete fields from a table in phpmyadmin.

This video will show you how to create a table in a database in phpmyadmin.

This video will show you how to copy a database table in phpmyadmin.

One question that comes up regularly is "How can I move my existing Joomla site to your servers?". This can be achieved relatively simply in 3 steps.
1. Upload your existing Joomla site files to your hosting account.
2. Export (or dump) your existing MySQL database, then create a new database and import the data.
3. Change your Joomla configuration settings.

This tutorial will focus on the process of exporting/importing the MySQL data.

PHP (PHP:Hypertext Preprocessor) was designed to create dynamic web pages, PHP's principal focus is server-side scripting. While running the PHP parser with a web server and web browser, the PHP model can be compared to other server-side scripting languages such as Microsoft's ASP.NET system, Sun Microsystems' JavaServer Pages, mod_perl and the Ruby on Rails framework, as they all provide dynamic content to the client from a web server.

If you've recently installed phpNuke with Fantistico (it's at the bottom of your Control Panel - if you haven't seen it - go look), you may have noticed that the phpBB version is about 5 releases out of date.
The most recent version of phpBB is 2.0.21, but the version within the phpNuke 7.8 Release is 2.0.15. However, before you run out and download the standalone updates/patches for phpBB, please keep reading.

The following scripts are banned due to these scripts causing harm to other sites on the same server.

- AlienForm (all versions)
- Greymatter (all versions)
- phpdig spider(all versions)
- Open Webmail
- Ikonboard (all versions)
- IRC Egg Drops & IRC related programs.(chat software)
- lstmrge.cgi
- Proxy Servers & Scripts (EX: nph-proxy)
- Shell, SSH, Telnet Scripts and Shell, SSH, Telnet Alternatives
- The Anonymizer
- UltimateBBS (all versions)
- Any script that uses & processes a massive number of flatfiles or large flatfile databases.

The official PHP site is http://www.php.net and the online documentation is found at http://www.php.net/manual

If you would rather follow a tutorial, then check out http://www.devshed.com (this covers PHP and others) or http://www.phpbuilder.com or just do a search on google for PHP Tutorials.

Especially look into how PHP integrates with MySQL so you can program database powered websites. If you are the type of person who likes to dive in the deepend, try downloading some basic scripts from http://www.hotscripts.com and/or http://php.resourceindex.com and start ripping apart the code to see what's being done.