i need help with my database.
i always backup my database everyday..
but whenever i am doing this and when
the backup is ongoing, all the system
which connects to this database server always
encounters hanging.
now, i have no choice to stop backuping the database
so that the users will not have downtime in their
part.
any solutions??
all of my tables are in MyISAM and i make sure that
the data are not that much.
my database is MySQL.
tnx in advance..
You need to plan your backup activity. It must be scheduled in the time when none of the DB processes are running mostly in early hours of weekends.
You need to plan your backup activity. It must be scheduled in the time when none of the DB processes are running mostly in early hours of weekends.
the clients of my database are running 24hours, 7 days a week..:(
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.