There are many reasons you would want to restore a database from a backup file… But you should also test this on a test server just to make sure that your database backups are working correctly. Here’s the syntax:
mysql -h hostname -u username -pthepassword databasename < dumpfile.sql
Backing up your database is a very important system administration task, and should generally be run from a cron job at scheduled intervals. We will use the mysqldump utility included with mysql to dump the contents of the database to a text file that can be easily re-imported.
Solaris includes a command line utility to get basic current system configuration information and output it to the console.
prtconf
Setting the system date and time is fairly easy on solaris. Because you can easily set the time from the command line, you can set the time on a server remotely.
date mmddhhmmyy
Setting the default route on Solaris is easy. If you are trying to just set the route temporarily you can use the route command:
Solaris is usually used as a server operating system. Because of this, you want to make sure that you shut the system down as gracefully as possible to ensure there isn’t any data loss.
For every application that is installed on your server, you should make sure that you have the correct scripts in /etc/rc(x).d to gracefully shut down the service.
How to install SSH on Solaris 10 x86
UNIX / Linux - Solaris
利用mysqlcheck命令快速修復mysql資料庫
因為掉電或者其他原因導致資料庫損壞,我們可以使用mysql本身的mysqlcheck命令來快速修復所有的資料庫或者特定的資料庫;
Automatically Purge MySQL Master Log
My Friend Andre Hartawan is troubling due to his mysql server at work stop operating. After quick check he found that no more disk space available on the system. Further check on /var partition he found many replication log file on disk which no longer needed but have big size (100MB). He can easily purge the logs file but wanted the server due it chores automatically. So here it’s I share my script (autopurgebinlog.sh) to purge replication logbin automatically.
1. 先安裝 Server 2003 光碟內的 Support Tool
2. 在 2003 上面執行 dcdiag /a 檢查是否有任何錯誤警示?
