Had an interesting problem.

One of my hosted sites lost the mysql database for Joomla, not sure, but it would appear that a sysadmin some how deleted the mysql database, but we did not know this until the user went to their website and found it gone.

Database Error: Unable to connect to the database:Could not connect to MySQL

I take two backups from my cPanel, one via cPanel, and one via my owb backup system.

Therefore I had a copy of the database sitting on my remote backup server.

1. Copied back the remote backup.
2. Put the Joomla, mysql database back in to /var/lib/mysql
3. Set all chmod and chown to correct settings
4. Website still gone
5. In mysql there is no user or db records for this site/database
6. Used this script to create the needed users for this database.
7. Replace the'something' with what it should be, every site will be different.

USE mysql;
REPLACE INTO user (host, user, password)
 VALUES (
 'localhost',
 'something_jo151',
-- IMPORTANT: Change this password.
 PASSWORD('somethingelse')
);

REPLACE INTO db (host, db, user, select_priv, insert_priv, update_priv, delete_priv, 
create_priv, drop_priv, references_priv, index_priv, alter_priv, create_tmp_table_priv, 
lock_tables_priv, create_view_priv, show_view_priv, create_routine_priv, alter_routine_priv, execute_priv)
 VALUES (
 'localhost',
 'something\_jo151',
 'something_jo151',
 'Y', 'Y', 'Y', 'Y',
 'Y', 'Y', 'Y', 'Y',
 'Y', 'Y', 'Y', 'Y',
 'Y', 'Y', 'Y', 'Y'
);

FLUSH PRIVILEGES

My customers site was back.

The main tool I used for pod-casting is 1Pixelout Audio Player

You can find it here and download for a small donation, $3.00. Well worth it!

If you have a site with us we may have already installed it.

• Once installed this extension needed to be activated,
• under the menu item Extensions >> Plugin Manager >> Click to enable Content - 1Pixelout Audio Player

I generally create a folder in my Joomla Website called MP3 and use Firefox and FireFTP to upload my MP3 podcasts.

Download Firefox from HERE

Download FireFTP from HERE

Setup FireFTP to login to your website:

1. The Account Name can be anything you like
2. The Host must be the FQDN for your site i.e. www.mysite.co.nz
3. Login is as I have provided to your previously
4. Password is as I have provided to your previously
5. Click on OK

Now connect.

You will get a listing of your web account. You are interested in the directory called public_html.

Go into this directory and make a new directory called mp3

• Once inside public_html right click anywhere in side the right hand panel.
• Click on the Menu item "Create Directory"
• Name this mp3
• Save
• Go inside this Directory
• In the left hand panel navigate to where your mps files are
• Select the files you want to upload
• Click the green right point button to upload

Once you have uploaded the pod-casts we need to create or edit an article that holds the pod-casts.

Examples of use:
Start with the first example and once you have that working try something more interesting.