Re: backup solution.

2007-05-15 Thread Alex Arul Lurthu
On 5/15/07, Ananda Kumar <[EMAIL PROTECTED]> wrote: Hi Alex, Thanks for the info, For the second question, do you mean i should restore the entire backup or just that one file from my backup. All the files should be from the same backup. AFAIK, MySQL doesnt have an option to recover only one d

Re: backup solution.

2007-05-15 Thread Ananda Kumar
Hi Alex, Thanks for the info, For the second question, do you mean i should restore the entire backup or just that one file from my backup. regards anandkl On 5/15/07, Alex Arul Lurthu <[EMAIL PROTECTED]> wrote: On 5/15/07, Ananda Kumar <[EMAIL PROTECTED]> wrote: > > Hi All, > I have take a

Re: backup solution.

2007-05-15 Thread Alex Arul Lurthu
On 5/15/07, Ananda Kumar <[EMAIL PROTECTED]> wrote: Hi All, I have take a mysqldump of my entire database, is it possible to restore just one table from this mysqldump. Yes thats possible. cat | grep "tablename u want to restore" > mysql -u user -ppassword should do it. Also, i have take

Re: backup solution.

2007-05-15 Thread Ananda Kumar
Hi All, The table is close to 5 GB in size. regards anandkl On 5/15/07, Olaf Stein <[EMAIL PROTECTED]> wrote: I am not sure if you can restore just one table from a dump with the mysql client, you could however just copy the table entries out of you dump into a new file and restore that On

Re: backup solution.

2007-05-15 Thread Olaf Stein
I am not sure if you can restore just one table from a dump with the mysql client, you could however just copy the table entries out of you dump into a new file and restore that On 5/15/07 12:28 AM, "Ananda Kumar" <[EMAIL PROTECTED]> wrote: > Hi All, > I have take a mysqldump of my entire databa