code_lotus

thanx a lot i'll try it

i have already visited the site that u gave me.i found this syntax shell> mysqldump --tab=/path/to/some/dir --opt db_namecan we use this syntax in MySql Query Browser? or we can use it only in command prompt?have u ever used 'backup' function from MySql Query Administrator ? do u have any sugestion so i can create a backup,the result of which is the same as the results of 'backup' function from MySql Query Administrator actually i'm developing an application for my final exam. in that application, i use java n mySql for the database.and then i want to create a button that if users click the button, it will automatically create a backup for my database.so that's why i need to know the sql syntax for backing up the database. :Dor do u have a better idea ? thanx for ur reply. i hope u understand my question (if u dont understand, plz let me know)

i'm using mySql.ok thanx bro.. i'll try it.

hi.. i'm newbie in sql..i wan't to create database backup (or maybe copy my database with a different name)can somebody help me ?