Backing up the InnoDB tables

Backing up the InnoDB tables

am 12.10.2010 18:45:19 von Tompkins Neil

--0016364d3195ca818704926e3390
Content-Type: text/plain; charset=ISO-8859-1

Hi

On a shared MySQL server with access just to my own database, what is the
recommend backup methods and strategies for the InnoDB tables ?

Cheers
Neil

--0016364d3195ca818704926e3390--

Fwd: Backing up the InnoDB tables

am 13.10.2010 14:07:01 von Tompkins Neil

--0016363b7996560ee404927e6e1e
Content-Type: text/plain; charset=ISO-8859-1

Would really appreciate some help or suggestions on this please, if anyone
can assist ?

Regards
Neil

---------- Forwarded message ----------
From: Tompkins Neil
Date: Tue, Oct 12, 2010 at 5:45 PM
Subject: Backing up the InnoDB tables
To: "[MySQL]"


Hi

On a shared MySQL server with access just to my own database, what is the
recommend backup methods and strategies for the InnoDB tables ?

Cheers
Neil

--0016363b7996560ee404927e6e1e--

Re: Backing up the InnoDB tables

am 13.10.2010 14:19:08 von sureshkumarilu

--00504502c8a4ad8e1d04927e99fe
Content-Type: text/plain; charset=ISO-8859-1

use xtra backup

On Wed, Oct 13, 2010 at 5:37 PM, Tompkins Neil > wrote:

> Would really appreciate some help or suggestions on this please, if anyone
> can assist ?
>
> Regards
> Neil
>
> ---------- Forwarded message ----------
> From: Tompkins Neil
> Date: Tue, Oct 12, 2010 at 5:45 PM
> Subject: Backing up the InnoDB tables
> To: "[MySQL]"
>
>
> Hi
>
> On a shared MySQL server with access just to my own database, what is the
> recommend backup methods and strategies for the InnoDB tables ?
>
> Cheers
> Neil
>



--
Thanks
Suresh Kuna
MySQL DBA

--00504502c8a4ad8e1d04927e99fe--

Re: Backing up the InnoDB tables

am 13.10.2010 14:21:32 von Tompkins Neil

--0016364eef3448627a04927ea2f1
Content-Type: text/plain; charset=ISO-8859-1

The problem is I don't have any command line access, just direct MySQL
access to the database tables.


On Wed, Oct 13, 2010 at 1:19 PM, Suresh Kuna wrote:

> use xtra backup
>
> On Wed, Oct 13, 2010 at 5:37 PM, Tompkins Neil <
> neil.tompkins@googlemail.com> wrote:
>
>> Would really appreciate some help or suggestions on this please, if anyone
>> can assist ?
>>
>> Regards
>> Neil
>>
>> ---------- Forwarded message ----------
>> From: Tompkins Neil
>> Date: Tue, Oct 12, 2010 at 5:45 PM
>> Subject: Backing up the InnoDB tables
>> To: "[MySQL]"
>>
>>
>> Hi
>>
>> On a shared MySQL server with access just to my own database, what is the
>> recommend backup methods and strategies for the InnoDB tables ?
>>
>> Cheers
>> Neil
>>
>
>
>
> --
> Thanks
> Suresh Kuna
> MySQL DBA
>

--0016364eef3448627a04927ea2f1--

Re: Backing up the InnoDB tables

am 13.10.2010 14:28:10 von a.smith

Quoting Tompkins Neil :

> The problem is I don't have any command line access, just direct MySQL
> access to the database tables.
>

I dont know xtra backup, but if thats not an option you can just use
mysqldump. This can be run from a remote server to your DB server,
just using MySQL network access to the DB(s)...




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Backing up the InnoDB tables

am 13.10.2010 14:55:46 von tomasz dereszynski

> The problem is I don't have any command line access, just direct MySQL
> access to the database tables.
>
>
whats wrong with mysqldump?





--
bEsT rEgArDs | "Confidence is what you have before you
tomasz dereszynski | understand the problem." -- Woody Allen
|
Spes confisa Deo | "In theory, theory and practice are much
numquam confusa recedit | the same. In practice they are very
| different." -- Albert Einstein



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org