Re: backup a database

2005-05-10 Thread Philippe Poelvoorde
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 whe

Re: backup a database

2005-05-10 Thread gerald_clark
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

Re: backup a database

2005-05-10 Thread David Logan
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

backup a database

2005-05-10 Thread Rafael Diaz Valdes
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 appea

Re: Backup a database

2001-05-14 Thread José León Serna
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 deve

Re: Backup a database

2001-05-14 Thread Colin Faber
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 p

Backup a database

2001-05-14 Thread José León Serna
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