code_lotus

....

BACKUP TABLE tbl_name [, tbl_name] ... TO '/path/to/backup/directory'

....

thanx a lot i'll try it

Are you using MS SQL, MySQL, PostgreSQL, Oracle, Access, or something else?For MS SQL:http://msdn.microsoft.com/library/default....migwiz_0z50.aspFor MySQL (ver 5.0):http://dev.mysql.com/doc/refman/5.0/en/backup.html...

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)

Are you using MS SQL, MySQL, PostgreSQL, Oracle, Access, or something else?

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 ?