Backup DB in MySQL

yaronr · #1 (**permalink**) 07-03-07, 16:05

I can only create "sql" files. while the file i need is "zip" or "dump".
Is there any way doing that???

ceinma · #2 (**permalink**) 07-04-07, 08:00

??????????????????????????

what exactly you want???
unload all data from a table???

yaronr · #3 (**permalink**) 07-04-07, 10:40

I need to create dump file that backups all my database,
and I need that the created file won't be sql file or csv file, but zip file.

aschk · #4 (**permalink**) 07-04-07, 12:09

Dump into a SQL file, then zip it....
(mysql doesn't offer native zipping/compression of output files).

More to the point why do you need a "zip" file?

abhijeetclarion · #5 (**permalink**) 07-10-07, 05:23

As aschk said, mysql doesnt have any native zipping provision, one way to do it is to run a shell file periodically which should take the back up and zip it immediately

yaronr · #6 (**permalink**) 07-15-07, 16:20

I will use this advices. thanks.

Internet Services

Web Development

Digital Marketing

Consumer Tech