[triplebig]

is there anyway to do automatic backup of all my database in windows xp ?

as example at 5pm backup all the database to my specified folder or to other computer (in network)

right now i do it manually through phpmyadmin...mysql dump

[triplebig]

i have figured it out myself...using a batch file + task scheduler

PHP Code:

@echo off

echo Creating Backup...

for /f "tokens=1" %%i in ('date /t') do set DATE_DOW=%%i



for /f "tokens=2" %%i in ('date /t') do set DATE_DAY=%%i

for /f %%i in ('echo %date_day:/=-%') do set DATE_DAY=%%i

for /f %%i in ('time /t') do set DATE_TIME=%%i

for /f %%i in ('echo %date_time::=-%') do set DATE_TIME=%%i



c:\xampp\mysql\bin\mysqldump -u root  --result-file="c:\%DATE_DAY%_%DATE_TIME%_nameofdatabase.sql" nameofdatabase

echo Finished! 

now I'm still trying to backup to other computer

[triplebig]

i posted the code above last year and i want to use this backup method in my new project


...and i just notice the \ is gone in the code..let me try the quote button

@echo off
echo Creating Backup...
for /f "tokens=1" %%i in ('date /t') do set DATE_DOW=%%i

for /f "tokens=2" %%i in ('date /t') do set DATE_DAY=%%i
for /f %%i in ('echo %date_day:/=-%') do set DATE_DAY=%%i
for /f %%i in ('time /t') do set DATE_TIME=%%i
for /f %%i in ('echo %date_time::=-%') do set DATE_TIME=%%i

c:\xampp\mysql\bin\mysqldump -u root --result-file="c:\%DATE_DAY%_%DATE_TIME%_nameofdatabase.sql " nameofdatabase
echo Finished!