HI
I want a function or a script that it makes back up from my data base daily

I have tried some scripts but they weren't work .

how can I do so ?

thanks

if you have linux, You can use this with ftpput.

Create a file called backup in /usr/local/scripts/

Insert this:

#!/bin/bash
cd /usr/local/scripts
echo "Dumping DB"
mysqldump -u root -h localhost -pPASSWORD DATABASENAME > MYdb.sql
echo "Dumped"
echo "Putting .sql to IP OF REMOTE FTP HOST"
ncftpput -V -u FTPuname -p FTPpass IPofFtpHOST /directory/on/your/host /usr/local/scripts/MYdb.sql
echo "Done"
echo "Deleting temp .sql"
rm -f /usr/local/scripts/MYdb.sql
echo "Deleted"


Or just to dump a mysql DB use:

mysqldump -u root -h localhost -pPASSWORD DATABASENAME > MYdb.sql

and backup MYdb.sql

Originally Posted by lynxus

if you have linux, You can use this with ftpput.

Create a file called backup in /usr/local/scripts/

Insert this:

#!/bin/bash
cd /usr/local/scripts
echo "Dumping DB"
mysqldump -u root -h localhost -pPASSWORD DATABASENAME > MYdb.sql
echo "Dumped"
echo "Putting .sql to IP OF REMOTE FTP HOST"
ncftpput -V -u FTPuname -p FTPpass IPofFtpHOST /directory/on/your/host /usr/local/scripts/MYdb.sql
echo "Done"
echo "Deleting temp .sql"
rm -f /usr/local/scripts/MYdb.sql
echo "Deleted"


Or just to dump a mysql DB use:

mysqldump -u root -h localhost -pPASSWORD DATABASENAME > MYdb.sql

and backup MYdb.sql

thanks for your help but I want to upload a file like backup.php to my root and run it every week
how can i do that ?

thanks

it might just be better to install phpmyadmin and do a dump once a week then.

Set up a cron job to run the file once a week, you need access to the web server though. If not some hosts will add them at request, or provide another method for you to set them up.

Try using an automatic backup script like this one
http://bash.cyberciti.biz/backup/bac...base-server-2/

then run it using cronjob in daily basis or whatever.