Thanks Wilfried, However this needs to be set down in a simpler step by step manner with more explanation by someone who understsnds all this to make it into a standard document. This is a VERY important part of the documentation.
The script should be made into a file. This must include the cron job. The permissions and ownership must be stated. Where do we put this script/file? How do we set the place to which the dump is saved - HDD on same computer, CDROM, HDD on another computer on the network etc. Restore sith a simple script? The use of the porgram SPLIT is also useful to save the dump file into more than one CD - if bigger than 700MB! We could zip this file after dumping it to make it even smaller. Let us make this into a newbi doc, so people who know little about these can also follow the step by step instructions and do this successfully? Nandalal --- Wilfried Goedert <[EMAIL PROTECTED]> wrote: > > EL> Please try it with a GIG data and inform us. We > will highly appreciate it. > > I just have done it, to bring transfer to another > server. Same > function you are able to do at the web9 via confixx. > > Realy try to do it with all databases at the old > account :-) you have > some time to do and need to split very often. > > Thats a work for the sysadmins and mostly they do it > not via > phpmyadmin. Its much faster to do it with a script > as root. This is > different how you do the administration and > individual. > > Better to explain the other way: > > to bring a dump back that is bigger than 1MB :-) > > MySQL Dump > > Login as root > > cd /etc > > vi my.cnf > > search > set-variable = max_allowed_packet=1M > > change > set-variable = max_allowed_packet=12M > > now 12 M is the max Dump size. > > > ##################### > > To repair daily the MySQL, optimize, and do a > backup: > > make to folders > /var/backup and /var/backup/logs > > if you like to use other folders you have to change > the script. > > password change with mysql-root password > > the script change at /usr/local/bin/mysqlbackup > chmod 700 (otherwise > it needs 20 mins and hackers have access :-) > > now the script: > > #!/bin/sh > > date=`date -I` > > mysqlcheck --all-databases --auto-repair --extended > --optimize -uroot -ppasswort > >/var/backup/logs/mysqlcheck-$date.log > mysqldump --all-databases -uroot -ppasswort --opt | > bzip2 -c > /var/backup/databasebackup-$date.sql.bz2 > > rm /var/backup/databasebackup-current.sql.bz2 > rm /var/backup/logs/mysqlcheck-current.log > > ln -s /var/backup/databasebackup-$date.sql.bz2 > /var/backup/databasebackup-current.sql.bz2 > ln -s /var/backup/logs/mysqlcheck-$date.log > /var/backup/logs/mysqlcheck-current.log > > than the cron job every night at 3 o'clock > > 0 3 * * * /usr/local/bin/mysqlbackup > > /var/backup per ftp or www (.htaccess?) give access > you should know > what you do because the passwords com in plain text > so better is to > use ssh > > at home or at another server use a cronjob that pics > up at daily base > atabasebackup-current.sql.bz2 > > a good idea to use a atomic clock at the systems, > what i miss at the > other care2x servers. > > you can see in /var/backup/logs the logs of > mysqlcheck > > ready no more work for you at all the time :-) have > a nice sleep <g> > > backups you bring back if you need with > > bzcat databasebackup-current.sql.bz2 | mysql -uroot > -ppasswort > > Mit freundlichen Gr�ssen > Wilfried Goedert > mailto:[EMAIL PROTECTED] > > > > ------------------------------------------------------- > This SF.Net email is sponsored by Sleepycat Software > Learn developer strategies Cisco, Motorola, Ericsson > & Lucent use to > deliver higher performing products faster, at low > TCO. > http://www.sleepycat.com/telcomwpreg.php?From=osdnemail3 > _______________________________________________ > Care2002-developers mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/care2002-developers __________________________________ Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo.com/careermakeover ------------------------------------------------------- This SF.Net email is sponsored by Sleepycat Software Learn developer strategies Cisco, Motorola, Ericsson & Lucent use to deliver higher performing products faster, at low TCO. http://www.sleepycat.com/telcomwpreg.php?From=osdnemail3 _______________________________________________ Care2002-developers mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/care2002-developers
