Page 1 of 1

backup database

Posted: Fri Oct 04, 2002 4:36 am
by desmondlk
i had used the following command to backup MySQL database.

the database name is Test.

>mysqldump --opt Test > DB.sql
is works. But how can i backup the database in my desire location.

i had try the following command but csn't get through.

>mysqldump --opt Test > C:\Documents and Settings\User\My Documents\DB.sql

please help...

Posted: Fri Oct 04, 2002 5:52 am
by volka
that's probably because of the blanks in your path
Try it in double-quotes
mysqldump --opt Test > "C:\Documents and Settings\User\My Documents\DB.sql"

Posted: Sun Oct 06, 2002 9:19 pm
by desmondlk
thank volka.

What PHP function that require in order to backup MySQL database by using the above command?

Posted: Mon Oct 07, 2002 1:40 am
by Takuma
No but if you want to do it using PHP that'll be quite complicated...

Posted: Wed Oct 09, 2002 9:20 pm
by desmondlk
So, got any suggestion that is used to backup database? thank in advance...

Posted: Wed Oct 09, 2002 9:42 pm
by volka