WARNING: This e-mail has been altered by MIMEDefang. Following this paragraph are indications of the actual changes made. For more information about your site's MIMEDefang policy, contact OZO MIMEDefang Administrator <[email protected]>. For more information about MIMEDefang, see:
http://www.roaringpenguin.com/mimedefang/enduser.php3
An attachment named 'backup-mydb.sh'
was converted to 'defang-1.binary'.
If you do not EXPECT a binary file from a KNOWN person there is
a 99% chance that this file may contain a VIRUS. You should also
be aware that many viruses hide using a FAKE SENDER mail address
in order to make you open the file
If you decide to open this file, we strongly recommend to have
an updated anti-virus program running. You can rename the file
to its original name by a right-click on the attachment and then
Save As: 'backup-mydb.sh'
Hello all, I have an application that updates the data tables heavily. I worked out these and may be someone need it too. Put backup-mydb.sh in /usr/local/bin Edit and run the backup-mydb.sh script (set ROOTPW, ...etc) Create mount point for new datadir: Edit /etc/fstab , add lines: # for mysql: tmpfs /var/mysqldata tmpfs defaults,size=16M 0 2 run: mount /var/mysqldata df -h You see this line in the output: tmpfs 16M 1.2M 15M 8% /var/mysqldata shutdown mysql, run: invoke-rc.d mysql stop Edit /etc/mysql/my.cnf, set datadir = /var/mysqldata replace /etc/init.d/mysql with the attached modified version. (the modified one is based on 5.0.51a-24+lenny2) start mysql, run invoke-rc.d mysql start The script will automatically restore all data files to /var/mysqldata You can also run backup-mydb.sh by cron periodically. Next time when you normally shutdown the system, the data files is auto backed up. When the system restart, the data files is auto restored. Your comments are welcome. - Michael
mysql
Description: Binary data
defang-1.binary
Description: defang-1.binary
_______________________________________________ Voyage-linux mailing list [email protected] http://list.voyage.hk/mailman/listinfo/voyage-linux
