Backup MYSQL Database

Anon

Hi Guys,

Please can you tell me how to make regular backups of my mysql database?

I do not have access to the area where the database back up files are created and therefore cannot ftp them to a safe area.

any suggestions

Justin

Anon

You can script the database unsing your own PHP file or phpMyAdmin. You can even call this url by a script running on your own pc using a scheduler (eg at, arcana, ...) or you can ask your sysadmin at your provider to run a script, which copies the database in your own ftp directory.

Anon

I was hoping to run the following query,

SELECT * from tablename INTO OUTFILE 'filename'

the problem is I can't put the path into the filename,

/backup/tablename.txt doesnt work.

If it did then I could specify to create the file into my FTP area.

Cheers

Justin

Anon

You can put a path in the "into outfile" statment, but the path you enter must be writable by the user that runs PHP/MySQL.