In most common cases:

mysql -h localhost -u [user] -p [database_name] < [name_of_dump.sql]


In many other sources, it’s mentioned that you need to put the password without a space attached to the -p parameter. No need to do that – you will be prompted for password after you hit Enter.

And, yet, if you type your password attached to the -p parameter, the command will be saved in your history. And potentially, if someone gets that, you are in trouble.

If your mysql user doesn’t have password, omit the -p parameter.

mysql -h localhost -u [user] [database_name] < [name_of_dump.sql]


Problem: Cannot remember Joomla administrator (or any other user) password.

It’s impossible to retrieve Joomla administrator / user password, because, for security measures, it is stored in MD5-encoded string. That’s why you can only reset it. To do so, you need to have access to the database.

Solution: Read more →

When we create a content item (it can be an Article, Custom Module, Description, etc.) in standard installation of Joomla 1.5.x, we face a problem of linking text or image to an Article which has been created before. When we click «Insert / edit link» button, there is a «Link URL» field, we need to fill in. But we don’t know the URL of the article, which was created before.

How to solve this problem? →

Joomla 1.5′s standard editor, which is called TinyMCE, by default supports only few features. The toolbar of the editor looks like this:

Joomla TinyMCE standard editor toolbar

The toolbar is quite poor. There is no way, for example, to insert and edit tables, set element attributes, setting colors to the text, background, and many others. However, there is a possibility to have many more useful buttons on the toolbar in standard installation of Joomla.

How to extend the toolbar of TinyMCE? →