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 mysqld
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 wrote:
> The mysql command line has the -o option to only execute queries for
> the default database. This can be
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
Johan De Meersman wrote:
- Original Message -
From: "Suresh Kuna"
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 o
- Original Message -
> From: "Suresh Kuna"
>
> 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 databases :-)
To answer t
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 wrote:
> I take a complete backup through mysqldump command.
> It includes MyISAM & Innodb tables both.
>
> But now i am thinking to take backup
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...
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 wrote:
> What tables types are you using? If MyISAM, this can be done easily.
> If InnoDB it will depend on your settings (file-per-
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 wrote:
> Dear all,
>
> I read all the different ways to backp and restore data in mysql.
> Say, i perf
