have you tried mysqldump?
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Ilyas Keser [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 18, 2002 6:15 AM
To: [EMAIL PROTECTED]
Subject: backup
Hi list...
What is the best way to backup a Mysql
Also in may NT machine appear the same error. Which is the problem ?
- Original Message -
From: Ilyas Keser [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, July 18, 2002 1:58 PM
Subject: backup
Hi list...
What is the best way to backup a Mysql database? I read in the
Subject: Re: backup
Also in may NT machine appear the same error. Which is the problem ?
- Original Message -
From: Ilyas Keser [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, July 18, 2002 1:58 PM
Subject: backup
Hi list...
What is the best way to backup a Mysql database? I read
-
From: Massimo Petrini [mailto:[EMAIL PROTECTED]]
Sent: 18 July 2002 16:06
To: [EMAIL PROTECTED]; Ilyas Keser
Subject: Re: backup
Also in may NT machine appear the same error. Which is the problem ?
- Original Message -
From: Ilyas Keser [EMAIL PROTECTED]
To: [EMAIL PROTECTED
On Thu, 18 Jul 2002 16:05:34 +0200, Massimo Petrini wrote:
Also in may NT machine appear the same error. Which is the problem ?
DBI is a perl module for interfacing with databases
see
http://search.cpan.org/search?module=DBI
-z
sql mysql query
--
z, [EMAIL PROTECTED] on 07/18/2002
Pada Sun, 7 Jul 2002 17:53:08 +0500
Impex Holidays Maldives / Hasan [EMAIL PROTECTED] menulis :
Hi,
This may be out of topic,but still I'm working on a mysql back up file.
Does any one have a shell script to ftp a file to another location, so that I can
schedule to run this file with cron.
From: David McInnis [EMAIL PROTECTED]
Could you share your script for doing the date thing with the rest of
us? That sounds useful.
Isn't there a perl script around for backuping?
Something like:
mysqldump DB --add-drop-table --opt \
|gzip DBdump.`date +%Y-%m-%d`.gz
should even
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 3:07 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: backup databases
From: David McInnis [EMAIL PROTECTED]
Could you share your script for doing the date thing with the rest of
us? That sounds useful.
Isn't there a perl script
We use mysqldump.
It is fast and easy. restoration is not hard.
If you want more a more percise restoration option, look at using the
change-log. It wil allow you to revert back in time to a state of the DB.
-RG
On Tue, 2 Apr 2002, Kory Wheatley wrote:
Date: Tue, 02 Apr 2002 11:26:58 -0700
I regularly back up all my databases with mysqldump:
mysqldump -uUsername -pPassword --all-databases tmp.sql tar -cf
MySQL-Backup-DATE.tar.gz -z tmp.sql rm -f tmp.sql
I use a script (to determine DATE) in conjunction with cron to back all
databases up nightly, and I also have the script
Could you share your script for doing the date thing with the rest of
us? That sounds useful.
David McInnis
-Original Message-
From: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 10:40 AM
To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
Subject: RE: backup
From: David McInnis [EMAIL PROTECTED]
Could you share your script for doing the date thing with the rest of
us? That sounds useful.
From: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]]
mysqldump -uUsername -pPassword --all-databases tmp.sql tar -cf
MySQL-Backup-DATE.tar.gz -z tmp.sql
: RE: backup databases
I regularly back up all my databases with mysqldump:
mysqldump -uUsername -pPassword --all-databases tmp.sql tar -cf
MySQL-Backup-DATE.tar.gz -z tmp.sql rm -f tmp.sql
I use a script (to determine DATE) in conjunction with cron to back all
databases up nightly, and I also
We use mybackup.pl - a perl script found on sourceforge (well, not
anymore I just looked). It creates a compressed tarball of each
database, with a file for each table. The files can be used with the
mysql client without change to rebuild a table. It also can be setup to
rotate the backups
:53:27 -0800
From: David McInnis [EMAIL PROTECTED]
To: 'Jonathan Hilgeman' [EMAIL PROTECTED], [EMAIL PROTECTED],
[EMAIL PROTECTED]
Subject: RE: backup databases
Could you share your script for doing the date thing with the rest of
us? That sounds useful.
David McInnis
-Original
What would the script look like if I'm on Win2k ?
Mark
-Original Message-
From: Rodney Broom [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Tuesday, April 02, 2002 12:22 PM
Subject: Re: backup databases
From: David McInnis [EMAIL PROTECTED]
Could you share your
: Tuesday, April 02, 2002 12:22 PM
Subject: Re: backup databases
From: David McInnis [EMAIL PROTECTED]
Could you share your script for doing the date thing with the rest of
us? That sounds useful.
From: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]]
mysqldump -uUsername -pPassword --all
and get the name (and URL) to you.
-RG
Mark
-Original Message-
From: Rodney Broom [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Tuesday, April 02, 2002 12:22 PM
Subject: Re: backup databases
From: David McInnis [EMAIL PROTECTED]
Could you
Could I run something similar as a BAT file?
-Original Message-
From: Russell E Glaue [EMAIL PROTECTED]
To: Mark Stringham [EMAIL PROTECTED]
Cc: Rodney Broom [EMAIL PROTECTED]; [EMAIL PROTECTED]
[EMAIL PROTECTED]
Date: Tuesday, April 02, 2002 4:25 PM
Subject: Re: backup databases
PROTECTED]
Date: Tuesday, April 02, 2002 4:25 PM
Subject: Re: backup databases
On Tue, 2 Apr 2002, Mark Stringham wrote:
What would the script look like if I'm on Win2k ?
Good luck!!
But seriously; there is a $300 software package out there (can't remember
name) that will give your
similar as a BAT file?
-Original Message-
From: Russell E Glaue [EMAIL PROTECTED]
To: Mark Stringham [EMAIL PROTECTED]
Cc: Rodney Broom [EMAIL PROTECTED]; [EMAIL PROTECTED]
[EMAIL PROTECTED]
Date: Tuesday, April 02, 2002 4:25 PM
Subject: Re: backup databases
On Tue
What would the script look like if I'm on Win2k ?
Good luck!!
Don't listen to the naysayers
@echo off
set zdate=%date%
set zdate=%zdate: =%
set zdate=%zdate:/=-%
C:\mysql\bin\mysqldump -A E:\mysqlDataBackup\%zdate%.txt
save as a .bat and put it in the scheduler. Mine runs every hour.
We us a shell script that calls a cronjob (root) at 3am daily.
The line in the cronjob is:
+ACo- 3 +ACo- +ACo- +ACo- /usr/local/bin/dbbakup.sh username password
The shell script:
Richard --
You could do both, I would be a lot quicker to import data than restore
from tape. Say do an incremental dump back to your last level 0. Which
would be helpfull to developers as well as youself. You could also use
a seperate partition for the data directory and back that up.
The
Have you looked at mysqldump function?
-Original Message-
From: Alex Shi [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 20, 2001 1:36 PM
To: [EMAIL PROTECTED]
Subject: Backup and Restore
Hello,
I have a question regarding to table backup and restore. Suppose
we have a table of
At 2:53 PM -0800 11/26/01, Michael Collins wrote:
I get a permission error when trying to backup my database files
using the BACKUP TABLE function, here is an example use and its
result:
BACKUP TABLE ai2.topics TO /Users/mcollins/BACKUPS/BACKUP_1126_1407/ai2/;
There are two methods that I commonly use to move data from mySql into
Access.
The first is to use a myODBC connection and simply import the tables. Given
the size of your database (small that is) this would be quite quick assuming
that you are able to establish an ODBC connection to your
]
Sent: Saturday, September 22, 2001 6:45 PM
Subject: RE: Backup Data
There are two methods that I commonly use to move data from mySql into
Access.
The first is to use a myODBC connection and simply import the tables.
Given
the size of your database (small that is) this would be quite quick
PROTECTED]]
Sent: Saturday, September 22, 2001 1:49 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Backup Data
Thanks for your reply. What about replication ? I've looked at this, but
everyone says read the manual. I would like to hear from someone who has
had experience
Howdy,
I tend to do both a dump to disk and then stop the DB and do a tape backup.
I don't believe there is an Online backup capability as user transactions
would need to be stored and played back against the DB after the backup as
in most production ready DB's.
Sid Young
QML Pathology
mysqldump creates an 'SQL' script, which you 'run' to recreate the tables
and data within them.
Something like this should do the trick...
mysql -u root -p password NewDataBaseName file.mysql
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July
Because the --opt option builds an output script of SQL commands that can
be run to CREATE TABLES and INSERT data. You're on the right track, but
using mysqlimport only makes sense based on the options that were used
with mysqldump...
Based on what you've done, you can re-create the entire
Greetings,
If you have the hardware to spare, setup a replication server and run your
backups against that server. It's clean, you can shutdown your database
completely on the slave and perform backups however you want. I use it both
at home and at work and get wonderful results.
Dear Claudemir,
you can use
mysqldump --all-databases my_dump_file.sql
which will make restore possible on *any* operating system. It creates
quite a big file (because of all the create / insert statements) - which
might be slow to transfer to / from an internet machine. It's a bit
faster
: Stefan Hinz [mailto:[EMAIL PROTECTED]]
=Sent: maandag 30 juli 2001 20:51
=To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
=Subject: Re: Backup of all Databases
=
=
=Dear Claudemir,
=
=you can use
=
=mysqldump --all-databases my_dump_file.sql
=
=which will make restore possible on *any* operating system
i cannot start my mysqld server on my Unix OpenBSD 2.9 Server, because i
have a problem after i have restarted my server.
So how do i take backups without connecting to the mysqld server, i have
access to the files that is placed in /var/mysql
but i cannot you mysqldump because of the
the update log is.
Currently it's in d:\mysql\bin
Pete
Original Message
Subject: RE: backup/restore of mysql
Date: Tue, 10 Jul 2001 17:48:31 +0100
From: Simon Green [EMAIL PROTECTED]
To: 'Pete Kuczynski' [EMAIL PROTECTED]
Hi Pete
To emable loffing use the --log option eg --log-update
Greg Cope wrote:
Pete Kuczynski wrote:
Hi,
I've posted this question before, and some were kind enough to respond
with suggestions to my question [replication], but I'm looking for
something more difinitave.
Background: I'm running a production mysql database/php4/Apache on a NT4
You can use update/bin_update logs.
Run these logs from the time of the last backup and it should take you DB up
to date till the time in went down
Simon
PS update logs have all the SQL statements in them so it should be very
simple to recover!
-Original Message-
From: Pete
: Re: backup/restore of mysql
Hi,
do I need to generate these logs using the my.ini file on NT.
Pete
Simon Green wrote:
You can use update/bin_update logs.
Run these logs from the time of the last backup and it should take you DB
up
to date till the time in went down
Pete Kuczynski wrote:
Hi,
I've posted this question before, and some were kind enough to respond
with suggestions to my question [replication], but I'm looking for
something more difinitave.
Background: I'm running a production mysql database/php4/Apache on a NT4
IBM Netfinity server
Michael Collins wrote:
I could not get the backup to work using the mysql client program. The
table is a MyISAM type and I have a version (3.23.36) that should
support the BACKUP TABLE SQL command.
First I created a directory called dbbackup and then used the following:
mysql BACKUP
At 10:09 AM +0307 7/8/01, Tonu Samuel wrote:
Use the utility perror to get meaning of OS low level errors. This
is an Access denied and means that in some reason you are not
allowed to write into this / directory. I think, this is normal :)
I had checked the directory to make sure I had
At 10:09 AM +0307 7/8/01, Tonu Samuel wrote:
Use the utility perror to get meaning of OS low level errors.
I have taken a look at the perror utility for viewing the text for
MySQL error codes and decided I wanted to see all the MySQL error
messages so I created a simple PERL script:
On 08-Jul-01 Michael Collins wrote:
At 10:09 AM +0307 7/8/01, Tonu Samuel wrote:
Use the utility perror to get meaning of OS low level errors.
I have taken a look at the perror utility for viewing the text for
MySQL error codes and decided I wanted to see all the MySQL error
messages so
Pete:
I think I would go for replication
(http://www.mysql.com/doc/R/e/Replication_Implementation.html)
If replication isn't in the cards, then look at using CD-RW ... tape is too
slow.
Gerald Jensen
- Original Message -
From: Pete Kuczynski [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Hi!
At 05:44 PM 6/1/01 +0400, you wrote:
Hello mysql,
Today I played a little bit with two different ways of backup -
first one is to use BACKUP TABLE (which works for myisam only) and
the second one is SAVE DATA/LOAD DATA.
In both cases if I'm not mistaken the file is wrote by mysqld
Hello:
I have already searched on the archives, but any of the solutions are
valid for me because I only have remote access to a windows server to get
the data+structure, and to the new server I only have mySQLAdmin access to
the database.
Best Regards
Visual PHP Studio, RAD
Pete Harlan wrote:
Probably because you need to redirect your output into the file AFTER all
the options. Rewrite your command like this:
In which shell? In SunOS /bin/sh, or in bash, the shell strips out
the redirection, and the program sees what's left. It doesn't matter
where the
Hi,
the cammod looks wiered to me try something like
mysqldump --flush-logs --add-drop-table -u root -pmarkloky shuncheong
/backup/shuncheong.sql
lars
"Mark Lo (3)" wrote:
Hi,
I would like to know how to backup mysql using crontab or cron jog.
I have add a line in my crontab file :
Probably because you need to redirect your output into the file AFTER all
the options. Rewrite your command like this:
mysqldump --flush-logs --add-drop-table -u root -p markloky shuncheong
/backup/shuncheong.sql
See if that works. The way you had it written, you weren't passing the -u
and
"Mark Lo (3)" [EMAIL PROTECTED] wrote:
I would like to know how to backup mysql using crontab or cron jog.
I have add a line in my crontab file :
mysqldump --flush-logs --add-drop-table shuncheong
/backup/shuncheong.sql -u root -pmarkloky;
but I got nothing in shuncheong.sql file.
mysqldump --flush-logs -u root -pmarkloky --add-drop-table shuncheong
/backup/shuncheong.sql
You have to put username and password as an argument to mysqldump, before
your redirection
John Barton
Unix Systems Administrator
Primary Networks, Inc.
[EMAIL PROTECTED]
On Tue, 3 Apr 2001, Mark Lo
Probably because you need to redirect your output into the file AFTER all
the options. Rewrite your command like this:
In which shell? In SunOS /bin/sh, or in bash, the shell strips out
the redirection, and the program sees what's left. It doesn't matter
where the redirection is; it can even
Check the manual to make sure, but I believe that you need to also make sure
that the operating system privileges are set correctly too. Not sure what
you'll need in Windows, but in Linux, your hosting company probably runs
MySQL under the user mysql. Thus, for the database to write out the
Li Joe ([EMAIL PROTECTED]) writes:
I would like to perform database backup while the server is running. I
don't want to use mysqldump as the tables are huge. So I consider to use
BACKUP TABLE sql command to perform it. In addition, I find that this
command only backups the .MYD and .frm,
My script backuping up alla databases which is in my datadir.
It's works for me.
#!/bin/sh
USER=root
PASSWORD=somepassword
BACKUPTYPE=daily
if [ -x $BACKUPTYPE ]
then
echo "$0 Backup typ"
exit 0
fi
for i in `ls /var/mysql|grep -E -v ".pid|.err"` ; do
DB=$i ;
Hola alguien habla espaol. que pueda ayudarme como se hace copia de
seguridad a tablas exageradamente grande.
He consultado el comando backup table tablas, to 'ruta' .
hay otra forma?.
Gracias.
Roger Retamoza
ICQ 102090754
Barranquilla Colombia
While on the subject of backup scripts -
Someone had asked on a message board for my webhost about
whether a script existed for backing up a MySQL database,
and, rotating backups. I couldn't find anything that did
everything that he asked, so I wrote something myself. It's
written in Perl and
Its not recommended to just `cp' your data directory for use later. You should
always dump the database with mysqldump.
James Ervin wrote:
Can you restore from a backup of the mysql data directory or do you need to
dump the database in order to be able to restore? I have seen some traffic
James Ervin wrote:
Can you restore from a backup of the mysql data directory or do you need to
dump the database in order to be able to restore? I have seen some traffic
on the list that suggests that a dump is the way to go. I backup the data
directory each night, but I would hate to
Its not recommended to just `cp' your data directory for use
later. You should always dump the database with mysqldump.
Eh?
If you know what you're doing, there's nothing unsafe about it and it
is WAY faster than using mysqldump.
You're absolutely right.. but try telling that to a
Scott Baker wrote:
That's the way that I do. I setup my server to shutdown the MySQL process
at 3am, zip up my var directory, and then restart the process. Can you
copy the data with the server running?
If you are shutting down the server, why don't you just copy the files
out to the
Steve Ruby wrote:
Scott Baker wrote:
That's the way that I do. I setup my server to shutdown the MySQL process
at 3am, zip up my var directory, and then restart the process. Can you
copy the data with the server running?
If you are shutting down the server, why don't you just copy
Sorry if this is a little late- but at Abriasoft we are currently developing a tool
that can be used for automated backup of your MySQL databases from one or more servers
with the ability to restore from the backups in the event that you need to.
Our tool uses a C daemon and a php web
201 - 265 of 265 matches
Mail list logo