Re: backup a database
Rafael Diaz Valdes wrote: Hi, I 'm using mysqldump to backup my database, I wrote in my backup.sh the following string: $MYSQL/bin/mysqldump --opt databasename -user=root --password=rootpassword > backup/mysql/databasename.sql I include backup.sh in my cron weekly (/etc/cron.weekly) but when it is executed appear databasename.sql empty, else if I run backup.sh in a shell konsole it is executed ok, do you know why can not execute the string in the cron ?? maybe make backup/mysql/databasename.sql an absolute path, to avoid wrong permission or writing the file in a non-existing folder (due to a wrong working directory, try "echo $PWD" in your backup.sh). I had the same pb when we setup our daily backup. my mysql version is : 4.0.17 regards rafael -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: backup a database
Rafael Diaz Valdes wrote: Hi, I 'm using mysqldump to backup my database, I wrote in my backup.sh the following string: $MYSQL/bin/mysqldump --opt databasename -user=root --password=rootpassword > backup/mysql/databasename.sql I include backup.sh in my cron weekly (/etc/cron.weekly) but when it is executed appear databasename.sql empty, else if I run backup.sh in a shell konsole it is executed ok, do you know why can not execute the string in the cron ?? my mysql version is : 4.0.17 regards rafae Do you have $MYSQL set? This really isn't a mysql question. It is a matter of elementary troubleshooting. Add to your script: echo "$MYSQL/bin/mysqldump" > /tmp/junk and see what you have. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: backup a database
Rafael Diaz Valdes wrote: Hi, I 'm using mysqldump to backup my database, I wrote in my backup.sh the following string: $MYSQL/bin/mysqldump --opt databasename -user=root --password=rootpassword > backup/mysql/databasename.sql I include backup.sh in my cron weekly (/etc/cron.weekly) but when it is executed appear databasename.sql empty, else if I run backup.sh in a shell konsole it is executed ok, do you know why can not execute the string in the cron ?? my mysql version is : 4.0.17 regards rafael Hi Rafael, Check the value of the variable $MYSQL. It is probably not being set by cron and should be set in your shell script. Cron starts with only a couple of variables set and you have to start everything else. Are you getting any output from the cron daemon? It should be in the logs somewhere or else emailed to root. Regards -- David Logan South Australia when in trouble, or in doubt run in circles, scream and shout -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
backup a database
Hi, I 'm using mysqldump to backup my database, I wrote in my backup.sh the following string: $MYSQL/bin/mysqldump --opt databasename -user=root --password=rootpassword > backup/mysql/databasename.sql I include backup.sh in my cron weekly (/etc/cron.weekly) but when it is executed appear databasename.sql empty, else if I run backup.sh in a shell konsole it is executed ok, do you know why can not execute the string in the cron ?? my mysql version is : 4.0.17 regards rafael
Re: Backup a database
Hello: I have already searched on the archives, but any of the solutions are valid for me because I only have remote access to a windows server to get the data+structure, and to the new server I only have mySQLAdmin access to the database. Best Regards Visual PHP Studio, RAD development with PHP http://www.visualphpstudio.f2s.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Backup a database
See the mailing list archives at lists.mysql.com There are quite a few discussions about this. José León Serna wrote: > > Hello: > This is my first message to this list, I want to know how to make a > backup of a database that has memo fields, those memo fields are html > articles (it's a php-nuke web), I use mySQLFront, to extract the .sql with > structure+data, and then I uses mySQLAdmin to create the new database+data > on another server, but I get an error about the INSERT sql's containing memo > fields. Any suggestion? > > Best Regards > > Visual PHP Studio, RAD development with PHP > http://www.visualphpstudio.f2s.com > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Backup a database
Hello: This is my first message to this list, I want to know how to make a backup of a database that has memo fields, those memo fields are html articles (it's a php-nuke web), I use mySQLFront, to extract the .sql with structure+data, and then I uses mySQLAdmin to create the new database+data on another server, but I get an error about the INSERT sql's containing memo fields. Any suggestion? Best Regards Visual PHP Studio, RAD development with PHP http://www.visualphpstudio.f2s.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php