SEO

#1 (**permalink**) 02-27-2008, 09:18 PM

I have NetBackup 5.1 MP4 running on Solaris 8 and Linux agent running 2.4
kernel. I don't use any optional database module for NetBackup.

I backup netbackup directories and tried to restore them. Unfortunately I
didn't go through well. Some of files couldn't be restore with error.

When I made a backup I didn't dump the database using mysqldump. The
database size is about 700GB and read-only purpose.

But, my guess is I got this error because I didn't stop the database when I
made a backup. My guess can be wrong. Please fix it if I am wrong.

How do I backup MySQL database using NetBackup without DB module ?

Any comments will help me.

Thanks,
YS

#2 (**permalink**) 02-27-2008, 09:19 PM

DD wrote:
> I have NetBackup 5.1 MP4 running on Solaris 8 and Linux agent running 2.4
> kernel. I don't use any optional database module for NetBackup.
>
> I backup netbackup directories and tried to restore them. Unfortunately I
> didn't go through well. Some of files couldn't be restore with error.
>
> When I made a backup I didn't dump the database using mysqldump. The
> database size is about 700GB and read-only purpose.
>
> But, my guess is I got this error because I didn't stop the database when I
> made a backup. My guess can be wrong. Please fix it if I am wrong.
>
> How do I backup MySQL database using NetBackup without DB module ?
>
> Any comments will help me.
>
> Thanks,
> YS
>
>

IF you want to restore the database to the exact same level of MySQL,
you can stop MySQL then back it up, although it's not officially
supported by the MySQL developers. But you can't back it up reliably
while MySQL is running this way.

Of course, mysqldump is always the better way. It is safe and supported.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Backup MySQL DB using NetBackup