Apache Friends Support Forum

Where is mysqldump in xampp? How can i backup my DB in the xAMpp package. Also I would like to keep an update log.

Would appreciate your help.

thnx
g

from http://faq.kwm-web.info/index.php?sid=3 ... 49&lang=de

dump a DB to file:
mysqldump -u root --password=[rootpass] --opt --all-databases > backup.sql

dump from file to DB:
mysql -u root -h localhost --password=[rootpass] < backup.sql


i think the mysqldump.exe is missing in the xampp install,
get it from eg. http://mirrors.sunsite.dk/mysql/Downloa ... nstall.zip

hello thanks for the reply. the first link is in german i coudn't read it:( but i appreaciate the help but i get the gist of it.

thnx!
g

i have another question concerning apache:)~ !

g

how do you specify the DB name when dumping from a file to the DB?

I am able to create the backup.sql - thanks. i was just wondering where mysqldump.exe was in xampp (apparently it doesnt come loaded)

i was able to download and create the back.sql

thanks for the help.

I am trying to get the incremental backup working. I am adding something like.

log-update= /path/

SHould I add this to my.cnf or my.ini for the mysql config file.


thanks
G