mysqldump?

Problems with the Windows version of XAMPP, questions, comments, and anything related.

mysqldump?

Postby gsyntaxerr » 09. June 2004 01:40

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
"The imaginary friends I had as a kid dropped me because their friends thought I didn't exist."
gsyntaxerr
 
Posts: 12
Joined: 23. April 2004 21:57
Location: a mile high, denver CO, usa

Postby micha78347 » 09. June 2004 04:10

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
micha78347
 
Posts: 57
Joined: 07. June 2004 20:56

mysql dump

Postby gsyntaxerr » 09. June 2004 15:35

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
"The imaginary friends I had as a kid dropped me because their friends thought I didn't exist."
gsyntaxerr
 
Posts: 12
Joined: 23. April 2004 21:57
Location: a mile high, denver CO, usa

Postby liqweed » 09. June 2004 16:39

how do you specify the DB name when dumping from a file to the DB?
liqweed
 
Posts: 10
Joined: 28. May 2004 09:44

mysqldump

Postby gsyntaxerr » 09. June 2004 19:58

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
"The imaginary friends I had as a kid dropped me because their friends thought I didn't exist."
gsyntaxerr
 
Posts: 12
Joined: 23. April 2004 21:57
Location: a mile high, denver CO, usa


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 57 guests