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 <mdyk...@gmail.com> 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 <adarsh.sha...@orkash.com>
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/mysql?unsub=mdyk...@gmail.com



--
 - michael dykman
 - mdyk...@gmail.com

 May the Source be with you.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com





Reply via email to