Regarding database backup

Hi,

I was trying to take the backup of the databse existing in mysql using java. I am using mysql 4.0. I found a tool mysqldump available in mysql but the problem with that will be, the output which is nothing sql statements to create the database, tables as well to insert the data into those tables.

The listing of these statement is based on the alphabetical ordering of the tables but not on the primary and foreign key constraints.

I don't have any stored procedures also as this version of mysql doesn't support them.

[550 byte] By [vgkandura] at [2007-10-3 4:31:00]