mySQL backup with SQLyog
2 Message(s) by 2 Author(s) originally posted in mysql database
| From: Jason Maur |
Date: Friday, May 18, 2007
|
Hey all,
This is my first post to a
newsgroup so forgive
me if it's in the wrong place...
I have setup a local
backup server for my company's
website, and can
sync the two DB's no problem (the local
and the "interweb" one) with SQLyog. But I'm not sure
if the following is possible and (if so) how to do it:
I sync the local DB with the live DB every morning at
5:00 a.m. Let's say the live site then goes
down at
4:00 p.m., so there have been a lot of changes made to the DB
since the last backup. Now, while the live DB is down,
I want to give employees access to the backup DB on the
LAN.
So here's the predicament: how (if possible) can I
guarantee that the changes made to the live DB (from 5am
to 4pm) and the changes made to the backup DB will be
consistent? That is, once the live DB recovers,
I want to be able to take the local DB updates and apply
them to the live DB without
losing the updates made on the
live DB since the last backup.
Okay, sorry about the short novel, thanks,
Jason Maur
| From: lark |
Date: Monday, May 21, 2007
|
wrote in message:
Hey all,
This is my first post to a newsgroup so forgive
me if it's in the wrong place...
I have setup a local backup server for my company's
website, and can sync the two DB's no problem (the local
and the "interweb" one) with SQLyog. But I'm not sure
if the following is possible and (if so) how to do it:
I sync the local DB with the live DB every morning at
5:00 a.m. Let's say the live site then goes down at
4:00 p.m., so there have been a lot of changes made to the DB
since the last backup. Now, while the live DB is down,
I want to give employees access to the backup DB on the
LAN.
So here's the predicament: how (if possible) can I
guarantee that the changes made to the live DB (from 5am
to 4pm) and the changes made to the backup DB will be
consistent? That is, once the live DB recovers,
I want to be able to take the local DB updates and apply
them to the live DB without losing the updates made on the
live DB since the last backup.
Okay, sorry about the short novel, thanks,
Jason Maur
this is a perfect scenario for a
replication process. in your case,
you'd set up one of your servers (let's say interweb) as the
master
replicator and the other one as the slave. every change on master will
be replicated to the slave. the
binary logs have to be turned on for
this to work. what happens next is that the master goes down (for
whatever reason), and the slave takes over. it becomes the master by
default. all changes obviously will go to this server. once the
real
master is back online, the two servers through a couple of processes
catch up with each other. the result is that you always have two servers
that are mirrors of each other.
--
lark -- hamzee@xxxxxxxxxxx
To
reply to me directly,
delete "despam".
Next Message: Select/Count not showing me my records...permissions?
Blogs related to mySQL backup with SQLyog
SQLyog Enterprise 5.22
Manage your
MySQL database from anywhere in the world. Apart from theregular administrative features like
backup and restore, and objectmanagement, this program supports database.
ServiceDesk Plus :: RE: Features? Help?
I believe there is, but I don't know if this is the right way or not, so proceed at your own risk, and make sure to take a
backup of your database before editing it in any way. Use a
MySQL database editor utility like
SQLYog to open the
...
SQLyog - Export Table as SQL Statements
CTRL+ALT+E will take your current table and turn it into a nice .sql file to load onto another system or just have around as a
backup. Technorati Tags: daily-shortcut, productivity, accesskeys,
mysql,
sqlyog.
PHP Essentials, what you cant live without.
The changes are that you probably work with
MySQL. Install MySQLyog. This little program saves you a lot of time when dealing with
MYSQL databases. It allows you to perform any
mysql function from a nice GUI.
...
Webyog SQLyog ver. 5.26 Enterprise Edition
Webyog
SQLyog 5 with HTTP/ HTTPS/ SSH Tunneling is a easy to use, compact and very fast graphical tool to manage your
MySQL database anywhere in the world.
SQLyog was developed keep in mind the necessities of all who use
MySQL as their
...
Questions and Answers During the First Session
MySQL administrator is one way,
MySQL Enterprise customers have access to
MySQL Monitoring and Advisory Service tool. phpMyAdmin is popular in Linux / PHP environemnts.
SQLYog is also common. Quest has Toad for
MySQL which is also
...