title: Backup multiple Databases[MySQL] at 1 time?
body: <p>Hi I have multiple databases need to back up daily. Currently, I am using cronjob to set a batch file to back it up. Here are my situation, I have about 10 databases need to backup, 3 of them are growing pretty fast, let me show you the current DB size:</p>
  
  <ul>
  <li>DB1 = 35 mb</li>
  <li>DB2 = 10 mb</li>
  <li>DB3 = 9  mb</li>
  <li>the rest: DBx = 5 mb</li>
  </ul>
  
  <p>My batch file code is:</p>
  
  <pre><code>mysqldump -u root -pxxxx DB1 &gt; d:/backup/DB1_datetime.sql
  mysqldump -u root -pxxxx DB2 &gt; d:/backup/DB2_datetime.sql
  ... and so for the rest
  </code></pre>
  
  <p>I have run this for 2 days, seems quite okay to me. But I wonder, if it will effect my website performance when executing the batch file. </p>
  
  <p>If this method is not good, how do you backup multiple databases while its on live and the size keep increasing daily?</p>