469,651 Members | 1,647 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,651 developers. It's quick & easy.

how to take all database backup .i need single query

hai all,

i have 10 database in one server. i need to take a backup daily

iam using
this type of query
ex:
mysqldump -a -u root -p dbname > dbname.sql(for each db)

but i need

single backup query for all databse (10 db)

and also restore all db in single query

thanks in advance.
barrathi
Dec 22 '06 #1
2 3335
ronverdonk
4,258 Expert 4TB
Why don't you look then in the MySQL standard documentation? You could have looked that up yourself! There it is all explained: use the --all-databases, -A option of the mysqldump command.
And if you don't want to backup all databases, you can specify them using mysqldump [options] --databases db_name1 [db_name2 db_name3...]

See http://dev.mysql.com/doc/refman/4.1/en/mysqldump.html

Ronald :cool:
Dec 22 '06 #2
Hi barrathi,
After seeing your question I think that you are very good in taking back up.
can you please help me in taking backup of my table from any GUI after table is filled with 10000 records.
i.e as the record count reached to 10000 ...then automatically backup should be taken of that particular rtable

regards,
Sandhya
Nov 29 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Jon Jacobs | last post: by
3 posts views Thread by Tommy.Vincent | last post: by
1 post views Thread by Little PussyCat | last post: by
18 posts views Thread by Wim | last post: by
4 posts views Thread by raidvvan | last post: by
1 post views Thread by kitemad69 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.