Backing up MySQL database

[jmaynard]

I was wondering if a batch file can be created to backup the MySQL databases on the Shoretel server. In the past backing up the database directly shutsdown the MySQL service and then reports can not be run.

Syntax on Linux
mysqldump -u root -ppassword databasename > /share/dir/backups/MySql/database.sql

Is it the same in windows? What databases should be backed up on the server? What user other than root can be used if the syntax above can be used?

[voipdude]

Backing up is very similar and there is a sample batch file build into Shoretel 7+

Locate the following directory: C:\Program Files\Shoreline Communications\ShoreWare Server\MySQL\MySQL Server 5.0\Examples

Edit the dump1.bat file to backup to the appropriate directory.

You can schedule the batch file to run with the Microsoft Task Scheduler.

Hope this helps,

Brian
Carlsbad, CA

[voipdude]

I wanted to follow up with this post as I'm finding the built in batch file very limiting. Currently, we are using mySQLyog to schedule backups which is very convenient since it uses a GUI.

Anyone have a favorite script for backing up mySQL?

[gandalf]

There are two tools that should be come your new best friend. Get a copy of MySQLyog and/or phpmyadmin. One is free and the other cost about $99 but is worth every penny. Basically, using MySQLyog you can schedule and automate MySQL backups of the CDR and Configuration files, directly to Shoreware Data folder and then include that folder in your normal backup as if you wer on a pre-version 7 install.