Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Create a Batch file WinXP

Posted on 2009-02-20
6
Medium Priority
?
179 Views
Last Modified: 2012-05-06
Hi Experts,

I would like to know if it is possible to create a script to go into MySQL, load up all the databases and then back them up individually rather than having one big file with all of the in one file.

Any help regarding this will be appreciated.

E.g.
DB1
DB2
etc..... all backed up individually.

Regards,

introlux
0
Comment
Question by:introlux
5 Comments
 
LVL 27

Expert Comment

by:Lukasz Chmielewski
ID: 23692009
how is the backup process done ? just copying ?
0
 
LVL 16

Expert Comment

by:speshalyst
ID: 23692026
0
 
LVL 16

Accepted Solution

by:
speshalyst earned 672 total points
ID: 23692035
0
 
LVL 16

Assisted Solution

by:t0t0
t0t0 earned 672 total points
ID: 23704136
Yes it is but first you must say what program you are using to backup your database files?
0
 
LVL 4

Assisted Solution

by:dkaisla
dkaisla earned 672 total points
ID: 23709279
if you're using mysqldump, use the --databases option for every database you have
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
The title says it all. Writing any type of PHP Application or API code that provides high throughput, while under a heavy load, seems to be an arcane art form (Black Magic). This article aims to provide some general guidelines for producing this typ…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question