- Original Message -
From: Suresh Kuna sureshkumar...@gmail.com
Try to take a tab separated dump, so you can restore what ever you
want in terms of tables or databases.
Uhh. I'm a bit fuzzy today, but I really don't see how a tab-separated dump
will help split off tables or
Johan De Meersman wrote:
- Original Message -
From: Suresh Kuna sureshkumar...@gmail.com
Try to take a tab separated dump, so you can restore what ever you
want in terms of tables or databases.
Uhh. I'm a bit fuzzy today, but I really don't see how a tab-separated dump
will
The mysql command line has the -o option to only execute queries for
the default database. This can be used to restore one database from a
dump file that contains many. For specific tables you can setup a
restore user that only has permissions on the tables you want to
restore then use the -f flag
might be my blog will help you :)
http://adminlinux.blogspot.com/2009/11/extract-single-dbtable-from-dump-file.html
have a good time..
On Thu, May 19, 2011 at 7:42 AM, Eric Bergen eric.ber...@gmail.com wrote:
The mysql command line has the -o option to only execute queries for
the default
2011/05/19 12:43 +0200, Johan De Meersman
Uhh. I'm a bit fuzzy today, but I really don't see how a tab-separated dump
will help split off tables or databases :-)
To answer the original question, though; the technically accurate answer is
yes, you can. It's made easy because mysqldump
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
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
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
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...
Try to take a tab separated dump, so you can restore what ever you want in
terms of tables or databases.
On Thu, May 19, 2011 at 9:53 AM, Adarsh Sharma adarsh.sha...@orkash.comwrote:
I take a complete backup through mysqldump command.
It includes MyISAM Innodb tables both.
But now i am
10 matches
Mail list logo