I take a complete backup through mysqldump command.
It includes MyISAM & Innodb tables both.
But now i am thinking to take backup in compressed format.
Thanks
Suresh Kuna wrote:
It really depends on What kind of backup you performed a month ago rather
than the type of tables at the moment...
On Thu, May 19, 2011 at 6:50 AM, Michael Dykman <[email protected]> wrote:
What tables types are you using? If MyISAM, this can be done easily.
If InnoDB it will depend on your settings (file-per-table)
- michael dykman
On Tue, May 17, 2011 at 7:11 AM, Adarsh Sharma <[email protected]>
wrote:
Dear all,
I read all the different ways to backp and restore data in mysql.
Say, i perform a complete backup of all databases 1 month ago
Now, is it possible to restore only a single database from a complete
backup
file of 250 GB that contains backup of more than 50 databases.
Or if we want to restore only selected tables in a database.
How to do this ?
Is it possible or not.
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
--
- michael dykman
- [email protected]
May the Source be with you.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[email protected]
