Hi guys,
Is it safe to perform a backup of a database by copying its mysql
files if the database is:
1) MyISAM and the database is not being used (mysql server turned off)?
2) InnoDB and and the database is not being used?
3) MyISAM and the database is being used?
4) InnoDB and and the
Onderwerp: backup questions
Hi guys,
Is it safe to perform a backup of a database by copying its mysql
files if the database is:
1) MyISAM and the database is not being used (mysql server turned off)?
2) InnoDB and and the database is not being used?
3) MyISAM and the database
end).
I'm not sure about option 2, but I think it should work.
Best regards,
Michael
-Oorspronkelijk bericht-
Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Alex K
Verzonden: maandag 28 januari 2008 14:34
Aan: MySQL General List
Onderwerp: backup questions
Hi guys
Its the same program, just Improved :-)
People hate things they do not understand.
You're probably right, and if I had memorized all the commands to be able to
edit text, and had gotten used to it, I may like it. I've just gotten used
to free-format editing w/o having to enter any commands
I'm trying to determine the best way to back up my MySQL databases in such a
way that they can be easily restored, flexible, and complete. I've
experimented with physically copying the files (with disastrous results).
MySQLDump seems to be the way to go, but I've got two problems with that
Jesse wrote:
my editor forces a hard line break at column position 16384, which, of course, corrupts
the restore. I don't know if there are other text editors that will not do this,
Funny, i've never seen one that does? What system/editor are you using?
or even better, if there is a way
On 7/3/06, Jesse [EMAIL PROTECTED] wrote:
I'm trying to determine the best way to back up my MySQL databases in such a
way that they can be easily restored, flexible, and complete. I've
experimented with physically copying the files (with disastrous results).
MySQLDump seems to be the way to
Funny, i've never seen one that does? What system/editor are you using?
Multi-Edit version 8.0i. This is an older version of the editor. Maybe a
newer one wouldn't, but for the most part, it does a very good job for me.
try to use the --max_allowed_packet= option - afaik mysqldump will
Jesse wrote:
Funny, i've never seen one that does? What system/editor are you using?
Multi-Edit version 8.0i. This is an older version of the editor. Maybe
a newer one wouldn't, but for the most part, it does a very good job for
me.
Ok never heard of multiedit... if your system is
--routines, -R
and
--triggers
Thanks, these did the trick, and it's put my procedures and triggers into
the back up file. However, it has commented them out so that they will not
be created if I do a restore to a new database. Not sure why...
Change Editor ;-)
I personally use VIM and
2) sometimes, I like to copy just a single table or so out of the backup
file, and restore just that.
You might want to try out MySQL Administrator which can often be used to
restore backups from mysqldump. It can _selectively_ restore tables from a
backup file.
On 7/3/06, Jesse [EMAIL PROTECTED] wrote:
--routines, -R
and
--triggers
Thanks, these did the trick, and it's put my procedures and triggers into
the back up file. However, it has commented them out so that they will not
be created if I do a restore to a new database. Not sure why...
There's GVIM for Windows, its the same program of Linux, I use it when
there's no way but using Windows. Get it at www.vim.org ! Its a blast
having the same (powerful, easy, fast and reliable) tool in windows
and linux. But you'll find it kinda hard to learn at first, because of
the command mode.
Message -
From: Brad Jahnke [EMAIL PROTECTED]
To: Jesse [EMAIL PROTECTED]; MySQL List mysql@lists.mysql.com
Sent: Monday, July 03, 2006 11:06 AM
Subject: Re: Backup questions
2) sometimes, I like to copy just a single table or so out of the backup
file, and restore just that.
You might
On 7/3/06, Jesse [EMAIL PROTECTED] wrote:
There's GVIM for Windows, its the same program of Linux, I use it when
there's no way but using Windows. Get it at www.vim.org ! Its a blast
having the same (powerful, easy, fast and reliable) tool in windows
and linux. But you'll find it kinda hard
Subject: Re: Backup questions
There's GVIM for Windows, its the same program of Linux, I use it when
there's no way but using Windows. Get it at www.vim.org ! Its a blast
having the same (powerful, easy, fast and reliable) tool in windows
and linux. But you'll find it kinda hard to learn
David,
- Original Message -
From: David Griffiths [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Friday, May 14, 2004 8:05 PM
Subject: Re: InnodB Hot Backup Questions
Sorry - haven't had a chance to respond till now.
So restore == apply-log, but one works on any
Sorry - haven't had a chance to respond till now.
So restore == apply-log, but one works on any computer, and the
other
only works on the computer that it's node locked to.
--apply-log works also in any computer regardless of the hostname or the
license expiration date.
I'm running
David,
- Original Message -
From: David Griffiths [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, May 13, 2004 7:50 AM
Subject: InnodB Hot Backup Questions
I'm hoping someone on the list has some experience with the tool
(specifically, restoring a backup
I'm hoping someone on the list has some experience with the tool
(specifically, restoring a backup), as I'm stumped.
First, --apply-log seems to only work on the host that ibbackup is
lode-locked to. This doesn't make sense. Running the tool dumpes out some
text, and part of that text is,
Can anyone help me with some questions about backup scripts?
I've written a bash script to take database-level backups of each of the
databases in our copy ofMySQL. We are running MySQL 4.0.15 on Linux
Mandrake 9.1 and using a mix of MyISAM and InnoDB databases. This is my script,
with the
21 matches
Mail list logo