Automatic ColdFusion MySQL database backup

[5474N]

Hey all,

I want to backup my database (MySQL) with a coldfusion script that will run automatically as a scheduled task.
I haven't been able to find the MySQL command or query that dumps a whole database.
any help is praised.
Thanks.

 

[Bammy217]

Hiya,

in your mysql folder you can look in the bin directory for the dump executable e.g.: C:\MySql\bin\mysqldump.exe

the actual command would be:

mysqldump.exe -u [username] -p[password] DatabaseName

hope this helps

We never fail, we just find that the path to succes is never quite what we thought...

 

[5474N]

Thanks for the help Bammy217.

I am using phpMyAdmin that is attached to a MySQL database.
I looked and there wasn't any \bin\ folder... and
I didn't see the .exe file anywhere.

When I need a mysql database installed i just copy the
phpMyAdmin folder onto the server, change the .ini file
to point to my IP .. and my database is setup.

Is there a MySQL query that I can run, and then
save(INSERT) to a seprate database as a textarea?

Another suggestion ?

Thanks very much .

 

[Bammy217]

5474N,

just have a search on your windows folders, sorry I'm a linux user myself so I can run it from anywhere but if you search for MySqlDump.* in the root folder of your MySql instalation it will come up.

cheers.
B.

We never fail, we just find that the path to succes is never quite what we thought...