If you have accidentally locked your Joomla administrator due to the strict security feature implemented through Admin Tools component, then here is the solution to fix the issue. Cause of issue could be : you forgot the ‘Administrator secret URL parameter’. you made several unsuccessful login attempts. The error message that appears on screen would […]
Posts in the Mysql category:
How to disable Joomla Plugin or Extension in PhpMyAdmin
Did you install any plugin recently that is causing trouble? Is your site admin panel not accessible at all? Did you break your site after the enabling a certain plugin? Don’t panic, you can disable or deactivate the plugin of Joomla from PhpMyAdmin database. Since you are unable to access the back-end, you will now […]
Irfan Moosani Joomla and WordPress custom and maintenance work
Joomla Expert with Knowledge of LOVE FACTORY , Community Builder, RSForms WordPress Expert with Knowledge of WooCommerce PHP, MYSQL, C, C++ trainer
How to restore compressed mysql backup file
To restore compressed backup files you can do the following: gunzip < [backupfile.sql.gz] | mysql -u [uname] -p[pass] [dbname] If you need to restore a database that already exists, you’ll need to use mysqlimport command. The syntax for mysqlimport is as follows: mysqlimport -u [uname] -p[pass] [dbname] [backupfile.sql]
Mysql backup using phpmyadmin
To tack the mysql database backup you can login to phpmyadmin and follow the following steps 1. Select Export from the menu 2. Select the Zipped format for downloading in compressed form 3. Press “GO”
Mysql database migration using shell command
I had a problem migrating the large mysql databases from one server to another. When ever i tried to do that using some utility I got “Out of Memory” error. After a bit of research work, I realized that big databases can be migrated using shell command easily Below you can find instructions to move […]