Command line is everything... :)

Don't know about you. But for me linux command line is everything. Last a couple of weeks, i busy with server migration. Upgrading to new version of Ubuntu is not so hard to do. The tedious part is that to back up your data and put it up again. You'll be facing some of issues that your new server is restricted here and there. You'll be stuck at permissions and so on.

Getting the server up and running is just a simple thing to do. After done with some hardening, than you need to put your data back in to online. Most of the times i'll be using phpmyadmin to import my data back to the new server. I ran into problems....

Importing large amount of data failed due to constraints from your php.ini files. If you're not going to edit this file, you actually can do it by linux command line!!! :). SSH to your new server, upload that *.sql file[s] to your new server. Get to terminal as root and issue this command :-

# mysqldump -u username -p database_name > database_name.sql

enter the passwrd and you're done. :)