Backup
Mysql DB Backup and Restore How to
by admin on May.31, 2010, under Backup, RHEL5, Ubuntu, Ubuntu 9.10, ubuntu 10.04, ubuntu 7.10, ubuntu 8.04, ubuntu 8.10, ubuntu 9.04
Database Backup
Eg:
Let’s assume that:
Username: ubuntu
Password: jaunty
Database Name: ubuntulinux
This will backup the database to a file called ubuntulinux.sql
Database Backup From the phpMyAdmin
1. Login to phpMyAdmin
2. Click on your database name
3. Click on the tab labeled EXPORT
4. Select all tables you want to backup (usually all)
5. Default settings usually work, just make sure SQL is checked
6. Check the SAVE FILE AS box
7. Hit GO
Restore Database From the Command Prompt
#mysql – u user_name -p your_password database_name < file_name.sql
Or using our previous example
If your database already exists and you are just restoring it, try this line instead:
#mysqlimport -u user_name -p your_password database_name file_name.sql
Or using our example again:
#mysqlimport -u ubuntu -p jaunty ubuntulinux ubuntuBackup.sql
Restore Database From the phpMyAdmin
- Login to phpMyAdmin
- Click on the tab labeled SQL
- Unclick the ’show query here again’ box
- Choose your backup file
- Hit GO
Thunderbird mail and profile backup on Ubuntu
by admin on May.28, 2010, under Backup, RHEL5, Ubuntu, Ubuntu 9.10, ubuntu 10.04
|
Thunderbird allows you to customize your email to suit your specific needs.
In Linux Mozilla thunderbird stores your email and profile setting in a special directory called ~/.thunderbird i.e. /home/you/.thunderbird/ or ~/.thunderbird directory. All you have to do is backup this directory. |
Backup Thunderbird mail and profilebackup thunderbird mail and profile to a /backup directory
#sudo mkdir /backup
#
tar zcvf /backup/email-ubuntu-181aug2009.tar.gz /home/ubuntu/.thunderbird/Restore Thunderbird mail and profileMake sure Thunderbird is not running. Simply copy backup files from USB pen or CD to your /home/you/.mozilla-thunderbird/ directory:
Or just copy all files from USB pen/CD to ~/.thunderbird/ directory. |