Archive for the ‘Server Admin’ Category

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. all the command to do this

Tags: database, filesort, import huge tables, keycache, mysql, repair table

Read on >>

2 responses >>

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

Read on >>

2 responses >>

Simple .htaccess tips and tricks

By broncha in Server Admin, Tutorials, Web, Web Space on April 16, 2010

In several web servers (most commonly Apache), .htaccess (hypertext access) is the default name of a directory-level configuration file that allows for decentralized management of web server configuration. The .htaccess file is placed inside the web tree, and is able to override a subset of the server’s global configuration; the extent of this subset is defined by the web server administrator.The original purpose of .htaccess was to allow per-directory access control , hence the name.

Tags: apache, htaccess, Server Admin, web hosting, www

Read on >>

no responses

Simple cPanel XML api call using Ruby

By broncha in articles, cPanel, ruby, Server Admin, Tutorials, Web on April 2, 2010

Ruby is a language of careful balance. Its creator, Yukihiro “matz” Matsumoto, blended parts of his favorite languages (Perl, Smalltalk, Eiffel, Ada, and Lisp) to form a new language that balanced functional programming with imperative programming.

Tags: automation, cPanel, curb, curl, gem, hosting, ruby, xml-api