Both MYISAM & Innodb Engines are used.
Thanks
Nilnandan Joshi wrote:
Can you tell us which storage engine you are using?
On Tue, Jun 7, 2011 at 11:30 AM, Adarsh Sharma
<adarsh.sha...@orkash.com <mailto:adarsh.sha...@orkash.com>> wrote:
Dear all,
Is it possible to take backups of a table or complete database
without stopping the application that continuously inserts and
select data from the tables.
For taking complete backup of a database I follow the below steps :-
1. First stop the application that insert & modifies tables.
2. Mysqldump command to backup the tables.
3. After complete backup , start the application.
I know Mysql-Replication helps a lot to solve this issue but I
have not any extra server to configure it.
So , Can I solve this issue without Replication so that I don't
need to stop my application & I must have consistent backups too.
Please note that size of databases may be more than 100GB
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=nilnan...@gmail.com
