ervan:~# tail -f /var/log/blog

Requirement
* MySQL

Command Usage

Backup (export)

mysqldump -u username -p databasename > filename.sql

Restore (import)

mysqldump -u username -p databasename < filename.sql

Linux Implement
Make sure you're root for unlimited access .

How to Backup

root:~# locate mysqldump | grep bin
/usr/local/mysql/bin/mysqldump
root:~# cd /usr/local/mysql/bin/
root:/usr/local/mysql/bin# ./mysqldump -u root -p mydatabase > mydatabase.sql
Enter Password:
root:/usr/local/mysql/bin#

How to Restore

root:~# locate mysqldump | grep bin
/usr/local/mysql/bin/mysqldump
root:~# cd /usr/local/mysql/bin/
root:/usr/local/mysql/bin# ./mysqldump -u root -p mydatabase < mydatabase.sql
Enter Password:
root:/usr/local/mysql/bin#

Windows Implement
Make sure you're administrator for unlimited access and then find mysqldump.exe on MySQL folder.
After that open a command prompt.
(In this case,the mysql folder is on D:\Mysql)

How to Backup

C:\Documents and Settings>D:
D:\>
D:\>cd "Mysql"
D:\Mysql>mysqldump.exe -u root -p mydatabase > mydatabase.sql

How to Restore

C:\Documents and Settings>D:
D:\>
D:\>cd "Mysql"
D:\Mysql>mysqldump.exe -u root -p mydatabase < mydatabase.sql