Am 22.08.2014 um 19:40 schrieb Lentes, Bernd:
i've been already reading the documentation the whole day, but still confused
and unsure what to do.
We have two databases which are important for our work. So both are stored
hourly. Now I recognized that each database has a mixture of
XTrabackup can handle both InnoDB and MyISAM in
a consistent way while minimizing lock time on
MyISAM tables ...
http://www.percona.com/doc/percona-xtrabackup/2.1/
--
Hartmut Holzgraefe, Principal Support Engineer (EMEA)
SkySQL - The MariaDB Company | http://www.skysql.com/
--
MySQL General
On 10/24/2012 11:57 AM, Bheemsen Aitha wrote:
Hi,
After following the steps at the following website, I tried to do an online
backup of the cluster.
http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster-backup-using-management-client.html
It is a plain vanilla command which is below. The
Just for others to know, it was the memory problem. I re-set the memory
parameters for ndbmtd (two nodes) to minimum. Then I could run the backup
successfully.
Thanks
BA
On Wed, Oct 24, 2012 at 11:57 AM, Bheemsen Aitha pgb...@motorola.comwrote:
Hi,
After following the steps at the following
Interestingly, this page does not say anything about MySQL Enterprise
Backups.
On Mar 15, 2011, at 8:48 AM, a.sm...@ukgrid.net wrote:
Hi,
there is a lot of info on different backup methods here:
http://dev.mysql.com/doc/refman/5.1/en/backup-methods.html
For example, for incremental
Hi,
What storage engine are you using?
Peter Boros
On 03/15/2011 02:12 PM, Adarsh Sharma wrote:
Dear all,
Taking Backup is must needed task in Database Servers. I research a lot
and find techniques to perform it in Mysql.
We have options RAID, mylvmbackup , mysqldump. But it depends on the
xtrabackup, mysqlhotcopy for myisam, incremental backup using zamanda.
Krishna
On Tue, Mar 15, 2011 at 9:09 PM, petya pe...@petya.org.hu wrote:
Hi,
What storage engine are you using?
Peter Boros
On 03/15/2011 02:12 PM, Adarsh Sharma wrote:
Dear all,
Taking Backup is must needed task
Hi,
there is a lot of info on different backup methods here:
http://dev.mysql.com/doc/refman/5.1/en/backup-methods.html
For example, for incremental backups see Making Incremental Backups
by Enabling the Binary Log,
cheers Andy.
--
MySQL General Mailing List
For list archives:
- Original Message -
From: Krishna Chandra Prajapati prajapat...@gmail.com
incremental backup using zamanda.
I'm running Zmanda on about two dozen hosts, and it comes well-recommended. It
doesn't do anything that you can't do yourself, but it's easy to set up,
reports well and backs
Hi!
Adarsh Sharma wrote:
Dear all,
Taking Backup is must needed task in Database Servers. [[...]]
Correct.
We have options RAID, mylvmbackup , mysqldump. But it depends on the
company requirement too.
RAID is no backup!
A RAID system may give you protection against a single disk
On Tue, March 15, 2011 12:36, Joerg Bruehe wrote:
Hi!
Adarsh Sharma wrote:
Dear all,
Taking Backup is must needed task in Database Servers. [[...]]
Correct.
We have options RAID, mylvmbackup , mysqldump. But it depends on the
company requirement too.
RAID is no backup!
A RAID
You might want to look into replication
(http://dev.mysql.com/doc/refman/5.5/en/replication.html). You can set up a
replication slave to follow the master DB in real time, or offset by minutes,
hours, days, or weeks, or whatever. That way you have a copy already served up
waiting in the wings,
sorry, my bad.
Its -R and not -p.
regards
anandkl
On Thu, Feb 10, 2011 at 1:58 PM, Singer X.J. Wang w...@singerwang.comwrote:
Remember that procedure is defined per database,
mysqldump -u[user] -p[pass] --where=db=`whatyouwant` and
name=`whatyouwant` mysql proc
On Thu, Feb 10, 2011 at
Hmm, I haven't seen the mail from Singer, yet.
On Thu, Feb 10, 2011 at 9:33 AM, Ananda Kumar anan...@gmail.com wrote:
On Thu, Feb 10, 2011 at 1:58 PM, Singer X.J. Wang w...@singerwang.comwrote:
mysqldump -u[user] -p[pass] --where=db=`whatyouwant` and
name=`whatyouwant` mysql proc
Yes, I
On Thu, Feb 10, 2011 at 7:43 AM, Adarsh Sharma adarsh.sha...@orkash.comwrote:
I am researching all the ways to backup in mysql and donot able to find a
command that take individual backup of only one procedure in mysql.
Have a look at the SHOW CREATE PROCEDURE syntax. It's not mysqldump, but
there is -p option please used that.
On Thu, Feb 10, 2011 at 12:47 PM, Johan De Meersman vegiv...@tuxera.bewrote:
On Thu, Feb 10, 2011 at 7:43 AM, Adarsh Sharma adarsh.sha...@orkash.com
wrote:
I am researching all the ways to backup in mysql and donot able to find a
command that take
/mysql_restore.sql
Thanks all
From: andrew.2.mo...@nokia.com [mailto:andrew.2.mo...@nokia.com]
Sent: Sunday, October 10, 2010 4:46 AM
To: kranthikiran@gmail.com
Subject: Re: Backup
hmm a yesterday backup? MySqldump using where clauses? Why do you only want
yesterday?
-- Sent from my HTC
Hi kranthi,
Take a look at LVM and xtrabackup.
http://www.mysqlperformanceblog.com/2009/02/24/xtrabackup-open-source-alternative-for-innodb-hot-backup-call-for-ideas/
http://marcus.bointon.com/archives/87-MySQL-backups-with-Perconas-XtraBackup.html
Krishna
CGI (cgi.com)
On Sun, Oct 10, 2010
Hey Kranthi,
If you have binlogs enabled, do a binary logs backup everyday i.e going to
be your everyday backup which consists of the sql modified statements.
On Sun, Oct 10, 2010 at 11:13 AM, yung inno...@gmail.com wrote:
2010/10/10 kranthi kranthikiran@gmail.com:
Hi ,
, 2010 4:46 AM
To: kranthikiran@gmail.com
Subject: Re: Backup
hmm a yesterday backup? MySqldump using where clauses? Why do you only want
yesterday?
-- Sent from my HTC Desire on 3 --
- Reply message -
From: ext kranthi kranthikiran@gmail.com
Date: Sun, Oct 10, 2010 04:51
Subject
2010/10/10 kranthi kranthikiran@gmail.com:
Hi ,
My database size is 900GB.i don't want full database backup. I
need only yesterday backup. how can I take, please help me.
How about the document there:
http://dev.mysql.com/doc/refman/5.1/en/backup-strategy-example.html
--
One way to do this would be to issue a 'stop slave;' on the slave
you are taking a backup from just before the backup starts. Then
issue a 'show slave status\G' to get the master log file and
position. You can use this to setup the new slave properly.
ok, thanks, I was thinking it'd be a
One way to do this would be to issue a 'stop slave;' on the slave
you are taking a backup from just before the backup starts. Then
issue a 'show slave status\G' to get the master log file and
position. You can use this to setup the new slave properly.
ok, thanks, I was thinking it'd be
One way to do this would be to issue a 'stop slave;' on the slave
you are taking a backup from just before the backup starts. Then
issue a 'show slave status\G' to get the master log file and
position. You can use this to setup the new slave properly.
ok, thanks, I was thinking it'd be
MAS! wrote:
btw, I have to get the Master_Log_File and Read_Master_Log_Pos or
Relay_Master_Log_File and Exec_Master_Log_Pos to start the new slave
correctly !?
If the Master_Log_File and Exec_Master_Log_Pos are not equivalent,
you'll want to note the Exec_Master_Log_Pos value as that is the
Are the values of these variables all accessible via the command: show
variables?
Josh Miller wrote:
MAS! wrote:
btw, I have to get the Master_Log_File and Read_Master_Log_Pos or
Relay_Master_Log_File and Exec_Master_Log_Pos to start the new slave
correctly !?
If the Master_Log_File and
Lawrence Sorrillo wrote:
Are the values of these variables all accessible via the command: show
variables?
If the Master_Log_File and Exec_Master_Log_Pos are not equivalent,
you'll want to note the Exec_Master_Log_Pos value as that is the value
which determines where in the binary logs
MAS! wrote:
I'd like to use that backup to setup a new slave (from the same (and
unique) master); the problem is I don't know how set-up this new slave,
since I don't know the right master binary-log num and position; in the
backup I have the slave's binary-log/pos and not the master ones :(
# mysqldump --help
look for the flag --no-data
Ben
Esbach, Brandon wrote:
Is there any way to backup a complete database structure
(tables/fields/indexes/etc), without the data? Or even get a creation
script per table?
At present the only way I can think of is to restore a backup to
Is there any way to backup a complete database structure
(tables/fields/indexes/etc), without the data? Or even get a creation
script per table?
At present the only way I can think of is to restore a backup to another
server and just delete records (a legacy database with data hitting over
]
Sent: 18 February 2008 11:24
To: Esbach, Brandon
Cc: MySQL User Group
Subject: Re: Backup table structure, not data
Is there any way to backup a complete database structure
(tables/fields/indexes/etc), without the data? Or even get a creation
script per table?
At present the only way I can
This works fine for me:
http://www.mysql.com/products/tools/administrator/
-Original Message-
From: Esbach, Brandon [mailto:[EMAIL PROTECTED]
Sent: Monday, February 18, 2008 12:22 PM
To: [EMAIL PROTECTED]
Cc: MySQL User Group
Subject: RE: Backup table structure, not data
I ended up
Hi,
Option 2 will not work. InnoDB has background threads that continue
to change data even when the database is quiet.
This is a simplification. The details are too complicated to write in
this thread, but there's an entire chapter on this topic in the book
I'm writing right now, High
Hi Alex,
I've used this method to start a replication slave without using MySQLdump to
get the data from one machine to another.
Option 1 works for sure,
Options 3 and 4 do not work for sure (if a .MYI, .MYD or ibdatax file is
changed while you are copying, you get a broken file on the other
-Original Message-
From: js [mailto:[EMAIL PROTECTED]
Sent: Saturday, December 01, 2007 8:11 PM
To: Jeff Mckeon
Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: Re: backup InnoDB db to another server
You might want to use --single-transaction option when mysqldumping
innodb
-Original Message-
From: Osvaldo Sommer [mailto:[EMAIL PROTECTED]
Sent: Saturday, December 01, 2007 8:23 AM
To: 'Jeff Mckeon'; 'David Campbell'; mysql@lists.mysql.com
Subject: RE: backup InnoDB db to another server
Jeff:
Mysqldump don't back up your index, that's your data only
Jeff:
Mysqldump don't back up your index, that's your data only.
Osvaldo Sommer
-Mensaje original-
De: Jeff Mckeon [mailto:[EMAIL PROTECTED]
Enviado el: Viernes, 30 de Noviembre de 2007 03:24 p.m.
Para: 'David Campbell'; mysql@lists.mysql.com
Asunto: RE: backup InnoDB db to another
: Re: backup InnoDB db to another server
On Friday 30 November 2007 17:12, Jeff Mckeon wrote:
Ok, so what would be the command to get a mysqldump of DB1 from
10.10.0.1
into file DB1backup.sql on 10.10.0.2?
What about running mysqldump on 10.10.0.2?
or
mysqldump DB1 -uroot
Jørn Dahl-Stamnes wrote:
On Friday 30 November 2007 17:12, Jeff Mckeon wrote:
Ok, so what would be the command to get a mysqldump of DB1 from 10.10.0.1
into file DB1backup.sql on 10.10.0.2?
What about running mysqldump on 10.10.0.2?
or
scp dump.sql [EMAIL PROTECTED]:.
Onliner
mysqldump
-Original Message-
From: David Campbell [mailto:[EMAIL PROTECTED]
Sent: Friday, November 30, 2007 11:29 AM
To: mysql@lists.mysql.com
Subject: Re: backup InnoDB db to another server
Jørn Dahl-Stamnes wrote:
On Friday 30 November 2007 17:12, Jeff Mckeon wrote:
Ok, so what would
On Friday 30 November 2007 17:12, Jeff Mckeon wrote:
Ok, so what would be the command to get a mysqldump of DB1 from 10.10.0.1
into file DB1backup.sql on 10.10.0.2?
What about running mysqldump on 10.10.0.2?
or
mysqldump DB1 -uroot -ppassword dump.sql
scp dump.sql [EMAIL PROTECTED]:.
--
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Baron Schwartz
Sent: Friday, November 30, 2007 11:06 AM
To: Jeff Mckeon
Cc: mysql list
Subject: Re: backup InnoDB db to another server
On Nov 30, 2007 10:55 AM, Jeff Mckeon [EMAIL PROTECTED] wrote
On Nov 30, 2007 10:55 AM, Jeff Mckeon [EMAIL PROTECTED] wrote:
I'm trying to use mysqldump to backup an innoDB based db from one server to
an sql file on another. It doesn't seem to be working however...
Here is the command I'm using on the source server
mysqldump DB1 -uroot -ppassword |
-Original Message-
From: Jørn Dahl-Stamnes [mailto:[EMAIL PROTECTED]
Sent: Friday, November 30, 2007 11:16 AM
To: mysql@lists.mysql.com
Subject: Re: backup InnoDB db to another server
On Friday 30 November 2007 17:12, Jeff Mckeon wrote:
Ok, so what would be the command to get
I am not sure if you can restore just one table from a dump with the mysql
client, you could however just copy the table entries out of you dump into a
new file and restore that
On 5/15/07 12:28 AM, Ananda Kumar [EMAIL PROTECTED] wrote:
Hi All,
I have take a mysqldump of my entire database,
Hi All,
The table is close to 5 GB in size.
regards
anandkl
On 5/15/07, Olaf Stein [EMAIL PROTECTED] wrote:
I am not sure if you can restore just one table from a dump with the mysql
client, you could however just copy the table entries out of you dump into
a
new file and restore that
On
On 5/15/07, Ananda Kumar [EMAIL PROTECTED] wrote:
Hi All,
I have take a mysqldump of my entire database, is it possible to restore
just one table from this mysqldump.
Yes thats possible.
cat your-dump-filename | grep tablename u want to restore mysql -u
user -ppassword should do it.
Hi Alex,
Thanks for the info,
For the second question, do you mean i should restore the entire backup or
just that one file from my backup.
regards
anandkl
On 5/15/07, Alex Arul Lurthu [EMAIL PROTECTED] wrote:
On 5/15/07, Ananda Kumar [EMAIL PROTECTED] wrote:
Hi All,
I have take a
On 5/15/07, Ananda Kumar [EMAIL PROTECTED] wrote:
Hi Alex,
Thanks for the info,
For the second question, do you mean i should restore the entire backup or
just that one file from my backup.
All the files should be from the same backup. AFAIK, MySQL doesnt have an
option to recover only one
Juan,
InnoDB Hot Backup is non-free. A 1-year license costs 390 euros + VAT,
and a perpetual license 990 euros + VAT.
http://www.innodb.com/order.php
The Perl script innobackup can be used to make consistent backups of
MyISAM tables also, but those backup require the locking of MyISAM
Whats wrong with using the --single-transaction switch for backing up
InnoDB tables? What does the Hot Backup product do that this doesn't?
Thanks,
-Ryan
Juan Eduardo Moreno wrote:
Ananda,
For Innodb the best is Innodb Hot Backup ( www.innodb.com (US$) )
For MyISAM you can use a simple
Ananda,
For Innodb the best is Innodb Hot Backup ( www.innodb.com (US$) )
For MyISAM you can use a simple backup ( copy/paste) of your files. Also,
you can do snapshots using mysqldump.
Also, you can use Zmanda ( www.zmanda.com).
Regards,
Juan Eduardo
On 2/23/07, Ananda Kumar [EMAIL
Hi Juan,
Thanks a lot for the quick reply. Any idea how much it would cost for
ibbackup for innodb. Will mysql be providing this with any of their new
release.
regards
anandkl
On 2/23/07, Juan Eduardo Moreno [EMAIL PROTECTED] wrote:
Ananda,
For Innodb the best is Innodb Hot Backup (
On 1/23/07, Alex Arul [EMAIL PROTECTED] wrote:
Hi,
MySQL Dump is logical. Hence it is mostly slower than locking the MyISAM
tables and copying them or shutting down the server and taring the entire
MySQL directory if you are using innodb. If you are using innodb tables only
you can run
I used mysqlhotcopy and all is fine.
Daniel da Veiga wrote:
On 1/23/07, Alex Arul [EMAIL PROTECTED] wrote:
Hi,
MySQL Dump is logical. Hence it is mostly slower than locking the MyISAM
tables and copying them or shutting down the server and taring the entire
MySQL directory if you are
Hi,
Hope I have faced this:
If we copy the files with 'cp' command, the permissions will not be
retained. You have to assign it on restoring. But in the mysqldump
utility, everything are retained as it is. Hope, mysqldump utility provides
more options related to db than that of 'cp'
Hi,
MySQL Dump is logical. Hence it is mostly slower than locking the MyISAM
tables and copying them or shutting down the server and taring the entire
MySQL directory if you are using innodb. If you are using innodb tables only
you can run mysqldump with --single-transaction option to take a
On 8/23/06, matt_lists [EMAIL PROTECTED] wrote:
We did not see this on 5.0.19, with 5.0.24 our backup jobs lock the
tables for selects
the backup takes 3 hours, so the site is down the whole time
I'm using this backup line
mysqldump -d -f --quote-names --skip-add-locks database outfile
chris smith wrote:
On 8/23/06, matt_lists [EMAIL PROTECTED] wrote:
We did not see this on 5.0.19, with 5.0.24 our backup jobs lock the
tables for selects
the backup takes 3 hours, so the site is down the whole time
I'm using this backup line
mysqldump -d -f --quote-names --skip-add-locks
matt_lists wrote:
chris smith wrote:
On 8/23/06, matt_lists [EMAIL PROTECTED] wrote:
We did not see this on 5.0.19, with 5.0.24 our backup jobs lock the
tables for selects
the backup takes 3 hours, so the site is down the whole time
I'm using this backup line
mysqldump -d -f --quote-names
Dilipkumar wrote:
Hi,
While taking backup in MySQL 5.0.24 for (ndbcluster tables) i am getting the
following errors :
mysqldump: Error 1296: Got error 241 'Invalid schema object version' from ndbcluster when dumping
table `iib_candidate_tracking` at row: 0
When i checked out using ndberror :
On Friday 04 August 2006 04:04 am, Kaushal Shriyan wrote:
mysql -u kaushal -h example.com -p drupal
/home/kaushal/drupal/new/a-l.sql and then do
mysql -u kaushal -h example.com -p drupal
/home/kaushal/drupal/new/m-s.sql
Better would be:
mysql -u kaushal -h example.com -p drupal
On 8/4/06, Chris White [EMAIL PROTECTED] wrote:
On Friday 04 August 2006 04:04 am, Kaushal Shriyan wrote:
mysql -u kaushal -h example.com -p drupal
/home/kaushal/drupal/new/a-l.sql and then do
mysql -u kaushal -h example.com -p drupal
/home/kaushal/drupal/new/m-s.sql
Better would be:
On Friday 04 August 2006 10:35 am, Daniel da Veiga wrote:
What if each .sql contains a DROP TABLE IF EXISTS statement at the
start? Something to be carefull if its the program that generated the
backup likes to add this tags.
What if my website code breaks? This train of what if type
On 8/4/06, Chris White [EMAIL PROTECTED] wrote:
On Friday 04 August 2006 10:35 am, Daniel da Veiga wrote:
What if each .sql contains a DROP TABLE IF EXISTS statement at the
start? Something to be carefull if its the program that generated the
backup likes to add this tags.
What if my website
If you're using Myphpadmin, you can turn this option off when generating the
dump file.
-Original Message-
From: Chris White [mailto:[EMAIL PROTECTED]
Sent: Friday, August 04, 2006 12:14 PM
To: mysql@lists.mysql.com
Subject: Re: Backup SQL
On Friday 04 August 2006 10:35 am, Daniel da
On Friday 04 August 2006 11:26 am, Daniel da Veiga wrote:
Think better before you hit send.
Dude
--
--
Chris White
PHP Programmer/DBarn
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
From: Amir Bukhari Sent: 18 July 2006 09:23
I have local mysql 5.0 and I have developed an arabic site.
The database
encoding is utf8-bin. Localy everything work fine, all arabic text are
displayed OK.
Now I want to move it to a server in internet. The server has
mysql 4.1 and
as I
-Original Message-
From: Addison, Mark [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 18, 2006 1:22 PM
To: Amir Bukhari; mysql@lists.mysql.com
Subject: RE: Backup problem from 5.0 to mysql 4.1
From: Amir Bukhari Sent: 18 July 2006 09:23
I have local mysql 5.0 and I have
Amir Bukhari wrote:
-Original Message-
From: Addison, Mark [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 18, 2006 1:22 PM
To: Amir Bukhari; mysql@lists.mysql.com
Subject: RE: Backup problem from 5.0 to mysql 4.1
From: Amir Bukhari Sent: 18 July 2006 09:23
I have local mysql 5.0
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
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
Paul Nowosielski wrote:
Dear all,
I've been testing our backup and recovery strategies here at work.
When dumping all the databases I'm using this command:
mysqldump --all-databases --force -u root -p -h 192.168.45.7 all.sql
When this command is run I receive these error messages:
On Thursday 25 May 2006 12:09, you wrote:
Paul Nowosielski wrote:
Dear all,
I've been testing our backup and recovery strategies here at work.
When dumping all the databases I'm using this command:
mysqldump --all-databases --force -u root -p -h 192.168.45.7 all.sql
When this
Paul Nowosielski wrote:
On Thursday 25 May 2006 12:09, you wrote:
Paul Nowosielski wrote:
Dear all,
I've been testing our backup and recovery strategies here at work.
When dumping all the databases I'm using this command:
mysqldump --all-databases --force -u root -p -h 192.168.45.7
Gerald,
Thank you that worked. now I'm receiving this error:
dev:/tmp # /usr/local/mysql/bin/mysqldump -u root -p -h 192.168.45.7 --force
--all-databases all.sql
Enter password:
/usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table
`help_category` (File
Daniel Kasak wrote:
Greetings.
I've just hit an interesting problem. Luckily I don't actually *need* to
restore from a backup right now - I'm just trying to create a database
dump to submit an unrelated bug report.
Anyway ...
I'm using the command:
mysqldump -K DATABASE_NAME db.sql -p
i think you can use -K on your mysqldump and it'll put the hints in there
for the mysql command to use as well
- Original Message -
From: Daniel Kasak [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, September 29, 2005 7:45 PM
Subject: Backup / Restore database with foreign
Michael Stassen wrote:
Before loading the file,
SET FOREIGN_KEY_CHECKS = 0;
after loading the file,
SET FOREIGN_KEY_CHECKS = 1;
That's it! Thanks :)
Even better, upgrade to a newer mysql (4.1.1+), where they are
automatically added to the dump file for you.
Not until the client
shuming wang wrote:
Hi,
Could we do a database dump/backup in a query like below ?
mysqldump.exe --default-character-set=gb2312 --opt --host 192.168.0.1
-u root -p -C mydbmydbfile
or restore a database in a query like below ?
mysql.exe -h 192.168.0.1 -u root -p -C mydbmydbfile
Then we can
Could we do a database dump/backup in a query like below ?
mysqldump.exe --default-character-set=gb2312 --opt --host 192.168.0.1 -u
root -p -C mydbmydbfile
or restore a database in a query like below ?
mysql.exe -h 192.168.0.1 -u root -p -C mydbmydbfile
Then we can do backup and restore
Arno Coetzee [EMAIL PROTECTED] wrote on 09/02/2005 04:37:48 AM:
shuming wang wrote:
Hi,
Could we do a database dump/backup in a query like below ?
mysqldump.exe --default-character-set=gb2312 --opt --host 192.168.0.1
-u root -p -C mydbmydbfile
or restore a database in a query like
Selon James Tu [EMAIL PROTECTED]:
What have people done in the past regarding backup strategies?
Is it adequate enough to rely on filesystem backups for mysql? Basically
such that we can restore MySQL to the last filesystem backup. Is there a
reason not to do this?
I don't have any mission
I don't know how big your tables are, and if you can withstand any
downtime. Because we're using MyISAM tables, we use mysqlhotcopy,
which locks the database as it copies the tables to another location.
Once that's been done you can rely on your filesystem backup to keep
copies of the data
if you are accessing mysql server using phpmyadmin
(http://sourceforge.net/projects/phpmyadmin/), then you have an option
to export the databases in many formats, I guess this should work in
your case...
Kishore Jalleda
On 6/21/05, Alex Aris [EMAIL PROTECTED] wrote:
How do backup at the client
Hello.
The situation is not clear for me. Are you
able to connect and execute queries on server
using mysql command line client?
Alex Aris [EMAIL PROTECTED] wrote:
How do backup at the client side?
I don't have an account, nor a shell on the server
side. When I give the path, it
Hello.
Among other suggestions think about such way.
If you MyISAM and InnoDB tables are used by different applications or
consistent state between them doesn't play big value, and the size
of MyISAM tables is low enough, you could perform the dump in two steps
listing the tables of the
If you are runing binary log and do a
FLUSH LOGS
mysqldump --opt --skip-lock-tables MyISAM table names
FLUSH LOGS
mysqldump --opt --single-transaction INNODB table names
You have a recoverable state with the combination of the mysqldump file
and the binary log file that was started by the 1st
-Original Message-
From: Scott Plumlee [mailto:[EMAIL PROTECTED]
Sent: Friday, June 17, 2005 10:21 AM
To: mysql@lists.mysql.com
Subject: Backup database with MyISAM and InnoDB tables together
I'm not clear on best practice to use on a database containing both
MyISAM and InnoDB
it in the cron job to do it with the backup.
-Original Message-
From: Scott Plumlee [mailto:[EMAIL PROTECTED]
Sent: Friday, June 17, 2005 12:36 PM
To: mysql@lists.mysql.com
Subject: Re: Backup database with MyISAM and InnoDB tables together
-Original Message-
From: Scott Plumlee
1 - 100 of 265 matches
Mail list logo