David Yin's Blog

Currently Viewing Posts Tagged restore

Backup server on Ubuntu

May 20, 2008
0 Comments

I have a Home Server at home.
It should have following functions:

  • Printer server;
  • Fire sharing server;
  • AMP server, including Apache, MySQL, PHP for testing purpose;
  • P2P client to download something for fun with web interface;
  • Backup server, to backup the files on the desktops in home lan.

P2P software, I use aMule.
Backup, I want to use Restore, but failed. They don’t have the release for Ubuntu 8.04. Someone said it is good on 7.10.
A lot of request for the 8.04 version posted on its forum. I have to wait for the new one.
The way to install Restore is here:
http://distro.ruffdogs.com/restore/

Database on Dreamhost

April 11, 2008
0 Comments

This blog has some error last week. Some pages were not build correctly.
I diagnosed it and found the template was broken. A bunch of codes were missing.
I want to find the backup of MySQL database.
Go to Dreamhost Web Panel > Goodies > Manage MySQL
Next to the database name, there are four links. One of them is Restore DB.
dh_mysql

Click Restore DB, and go the following page.
dh_restore_db

Continue reading “Database on Dreamhost”

MySQL Backup and Recovery Methodologies

February 17, 2008
0 Comments

MySQL is very popular. Many open source or free software use MySQL as their main database engine.
To make our data safe, please remember to backup your data regularly.
There are two methodologies you can use to back up MySQL databases without spending money.
The first is to create a series of SQL statements that rebuild one or more databases. This is usually accomplished via the mysqldump script.
The second is to copy the database files themselves if you can ensure they’re not being changed during the backup. This is currently possible only for MyI*SAM archive tables using the mysqlhotcopy script.
Let’s go into the details of how to back up MySQL database.
Backing up MyISAM tables
The folloing command creates a SQL dump of all MySQL databases in a given instance, locks all tables as necessary, flushes the logs, and writes the name of the current binary log to the output. The second command couses MySQL to switch binary logfiles so that you can back up the logfiles that was used during the backup.

Continue reading “MySQL Backup and Recovery Methodologies”

  • Archives