Unix Technical Forum

backup and restore of a dbase

This is a discussion on backup and restore of a dbase within the MySQL forums, part of the Database Server Software category; --> Hi, I would need of an utility for an automatic and scheduled backup of the remote dbase. Do you ...


Go Back   Unix Technical Forum > Database Server Software > MySQL

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-28-2008, 11:22 AM
Jim
 
Posts: n/a
Default backup and restore of a dbase

Hi,
I would need of an utility for an automatic and scheduled backup of the
remote dbase. Do you have some tip?

I have also a little problem with the remote dbase, accidentally I have
deleted the content of an 'id'line from a table with all the other
values associated.

I have the backup copy but only of the local dbase(local.sql). Is it
possible to copy the single line from the local dbase to the remote one?
Which query I have to write to extract and copy a single id line from a
local table to the remote one?

Excuse for my little english.

Regards and thanks.

Jim
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-28-2008, 11:22 AM
J.O. Aho
 
Posts: n/a
Default Re: backup and restore of a dbase

Jim wrote:
> Hi,
> I would need of an utility for an automatic and scheduled backup of the
> remote dbase. Do you have some tip?


should work fine with mysqldump used in small script for the cron.


> I have the backup copy but only of the local dbase(local.sql). Is it
> possible to copy the single line from the local dbase to the remote one?
> Which query I have to write to extract and copy a single id line from a
> local table to the remote one?


If you know the line, then no problems at all.


--

//Aho
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 10:42 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com