472,128 Members | 1,633 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,128 software developers and data experts.

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
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.
Dec 22 '06 #1
2 3455
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

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
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.