Automated BACKUP

[bob120579]

What needs to be done to create an automated backup in MySQL Administrator? It prompts me and tells me that a file is needed with the password stored.

 

[bob120579]

Anyone have any ideas?????

 

[audiopro]

I have not used MYSQL admin for backup purposes but prefer to incorporate a backup routine within the controlling script, which creates a text file from the contents of each table. This can then be saved to a backup directory or emailed/FTP'd to a local server.

Keith

 

[Kozusnik]

What is the OS? I currently have Linux shell script which runs mysqlhotcopy on an hourly basis to atarball in an archive folder. There's also mysqldump which dumps the tables into sql text files.

I'm not familiar with Mysql Administrator.

Mark

 

[towerbase]

bob120579,

I tried using MySQL Administrator to perform automatic backups for the first time yesterday. It seemed to have worked okay (although I haven't tried restoring from the generated SQL file).

MySQL Administrator asked for the password for my computer (which I need to enter each time I start Windows).

I'm using Windows XP Professional and MySQL Administrator v1.1.7

What exactly is the problem?

Andrew
Hampshire, UK

 

[bob120579]

Towerbase,

The problem is when I try to set up the Automatic backup and schedule it, it says that I need to set up my password in some type of file. But it will let me due a manual backup from there. Ideally, I would like to automate it and schedule it on there, so I do not have to run it manually every night. I am running Windows XP.

 

[towerbase]

What version of MySQL Administrator are you running?

Are you running XP Pro or XP Home?

What is the actual message that is asking for your password to be set in the file?

Andrew
Hampshire, UK