Since this has changed to MySQL, I cannot seem to figure out how to successfully run a backup. Can someone please give me a little direction on this. For starters I know nothing about MySQL, so that is a hurdle I need to get over. I would be interested how difficult a restore is also. Thank much guys, I appreciate it.
Announcement
Collapse
Welcome to ShoreTelForums.com
Welcome to ShoreTelForums.com!
This site was created as a place to share stories, tips, and troubleshooting help with ShoreTel/Mitel systems. ShoreTel/Mitel is obviously the MOST exciting VoiP platform on the market right now, and we realized there was no centralized place to discuss this platform, but now there is. Please feel free to join and share your experiences.
Please Note: This site IS NOT owned, funded, or managed by ShoreTel/Mitel, Inc. although you may find ShoreTel/Mitel employees sharing there experiences and expertise. If you would like more information on ShoreTel/Mitel systems, contact BTX at [email protected]
As always please support the advertisers that help support our site.
Thank You,
BTX
This site was created as a place to share stories, tips, and troubleshooting help with ShoreTel/Mitel systems. ShoreTel/Mitel is obviously the MOST exciting VoiP platform on the market right now, and we realized there was no centralized place to discuss this platform, but now there is. Please feel free to join and share your experiences.
Please Note: This site IS NOT owned, funded, or managed by ShoreTel/Mitel, Inc. although you may find ShoreTel/Mitel employees sharing there experiences and expertise. If you would like more information on ShoreTel/Mitel systems, contact BTX at [email protected]
As always please support the advertisers that help support our site.
Thank You,
BTX
See more
See less
X
-
Shoretel Main Database Backup and Restore Procedures
Run from: Program Files\Shoreline Communications\ShoreWare Server\MySQL\MySQL Server 5.0\bin
Backup:
mysqldump --add-drop-table --routines --user=#### --password=#### --database Shoreware > C:\shoreware_Bkup_7-7-2008.sql
Restore:
mysql --user=#### --password=#### Shoreware < C:\shoreware_Bkup_adam.sql
Please look up username and password in documentation.
-
-
Originally posted by cburgy View PostShoretel Main Database Backup and Restore Procedures
Run from: Program Files\Shoreline Communications\ShoreWare Server\MySQL\MySQL Server 5.0\bin
Backup:
mysqldump --add-drop-table --routines --user=#### --password=#### --database Shoreware > C:\shoreware_Bkup_7-7-2008.sql
Restore:
mysql --user=#### --password=#### Shoreware < C:\shoreware_Bkup_adam.sql
Please look up username and password in documentation.
You can do it the easy way. Download MySQL Administrator tools for back up and restore. There is even a scheduler builtin!!!
Username st_cdrreport
Password passwordcdrreport
Brad
Comment
-
-
Originally posted by cburgy View PostShoretel Main Database Backup and Restore Procedures
Run from: Program Files\Shoreline Communications\ShoreWare Server\MySQL\MySQL Server 5.0\bin
Backup:
mysqldump --add-drop-table --routines --user=#### --password=#### --database Shoreware > C:\shoreware_Bkup_7-7-2008.sql
Restore:
mysql --user=#### --password=#### Shoreware < C:\shoreware_Bkup_adam.sql
Please look up username and password in documentation.
Also note, in that folder the scripts are there for you to look at and modify. MySql website also has a Free Administration GUI, that is very slick and will be far better then a command line cli
MySQL :: MySQL GUI Tools Downloads
This is the MySQL GUI Tools Bundle for 5.0. It includes the following products.
* MySQL Administrator 1.2 Generally Available (GA)
* MySQL Query Browser 1.2 Generally Available (GA)
* MySQL Migration Toolkit 1.1 Generally Available (GA)
Comment
-
-
Originally posted by huffditty View PostThank you so much guys, now I just need to figure this out and mull through it slowly so I learn it well. That is a real help, thanks again!!!
Comment
-
Comment