Tags: database, filesort, import huge tables, keycache, mysql, repair table
Things I learned while restoring multi-million rows table in mysql
By broncha in articles, Misc., Server Admin on September 2, 2011
Recently someone contacted me to restore a huge database to their new servers.The database dump file was about 5GB having around 13 millions records.Each row included a huge TEXT field. The new server was a dedicated server from Godaddy. The initial step was not so hard. It is a good practice to disable indexes while importing huge database and when all the rows are done inserting enable the indexes.
Transfer accounts between cPanel servers from shell
By broncha in articles, bash, cPanel, Server Admin, Tutorials on September 25, 2010
As a web host administrator I always have to move accounts between my cPanel servers. The WHM has got an interface to transfer accounts between servers but most of the time it does not work for me.I get network issues, sometimes timeout issues and many other errors. So heres a short roundup about “How to transfer accounts between cPanel servers”. I will be using the cPanel scripts which it uses for packaging and restoring accounts.
Tags: cPanel, cpanel scripts, hosting, Server Admin, web hosting
How to reset admin password of osCommerce
By broncha in articles, Tutorials, Web Space on July 9, 2010
osCommerce uses the mod_auth Apache module for authentication to the admin section.So in case you forget your password,There's no option to change you password from the frontend of the website.The password is stored in a file called .htpasswd which needs to be manually updated to reset the password.
Tags: apache, htaccess, htpasswd, osCommerce, reset admin password
