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 Ma
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 My
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 wrote:
> Hi,
>
> After following the steps at the following website, I tried
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 cluste
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 backu
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,
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 b
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
- Original Message -
> From: "Krishna Chandra Prajapati"
>
> 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 up in what are b
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: http:
xtrabackup, mysqlhotcopy for myisam, incremental backup using zamanda.
Krishna
On Tue, Mar 15, 2011 at 9:09 PM, petya 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 in Da
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
c
Hmm, I haven't seen the mail from Singer, yet.
On Thu, Feb 10, 2011 at 9:33 AM, Ananda Kumar wrote:
> On Thu, Feb 10, 2011 at 1:58 PM, Singer X.J. Wang wrote:
>
>> mysqldump -u[user] -p[pass] --where="db=`whatyouwant` and
>> name=`whatyouwant`" mysql proc
>>
>
Yes, I thought of that, too; but th
sorry, my bad.
Its -R and not -p.
regards
anandkl
On Thu, Feb 10, 2011 at 1:58 PM, Singer X.J. Wang wrote:
> 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 02:55, Anand
there is -p option please used that.
On Thu, Feb 10, 2011 at 12:47 PM, Johan De Meersman wrote:
> On Thu, Feb 10, 2011 at 7:43 AM, Adarsh Sharma >wrote:
>
> > 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 i
On Thu, Feb 10, 2011 at 7:43 AM, Adarsh Sharma wrote:
> 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 it
will yield a statem
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 a
/var/log/mysql/bin.123456 \
>
> > /tmp/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:
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 Desire on 3 --
- Reply message -
From: "ext kranthi"
Date: Sun, Oct 10, 20
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 wrote:
> 2010/10/10 kranthi :
> >
> >
> > Hi ,
> >
> > My database size is 900GB.i don'
2010/10/10 kranthi :
>
>
> 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
--
MySQL General Mailing L
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 you
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
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
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
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
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 :(
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
PROTECTED]
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?
>
>
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
12GB,
# 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 anothe
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 Perfor
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 en
> -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:
>
>
> -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
> 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 a mysqldump of DB1 from
> > 10.10.0.1
> > > into file DB
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
> -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, Jef
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: 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, s
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
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 -ppasswo
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 d
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 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 | grep "tablename u want to restore" > mysql -u
user -ppassword should do it.
Also, i have take
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
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 databa
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 bac
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
table
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 ( www.i
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 PROTECT
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
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 mysqldu
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 cons
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' comman
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 :
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
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 da
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
mys
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]
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, Dani
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 w
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 qu
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 b
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 < ~/dr
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
> -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
> >
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
> a
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 to
ysql@lists.mysql.com
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.
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
ks,
Jesse
- Original Message -
From: "Brad Jahnke" <[EMAIL PROTECTED]>
To: "Jesse" <[EMAIL PROTECTED]>; "MySQL List"
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
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"
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...
> 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.
http://dev.mysql.com/doc/admi
--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 ne
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 window
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 creat
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 g
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 to
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
'/usr/local/src/mysql_curre
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
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
> >
>
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:
mysqldum
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 lib
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:
Sent: Thursday, September 29, 2005 7:45 PM
Subject: Backup / Restore database with foreign keys
Greetings
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
H
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 mydb>mydbfile
> > or restore a database in
> 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 mydb>mydbfile
> or restore a database in a query like below ?
> mysql.exe -h 192.168.0.1 -u root -p -C mydb
> Then we can do backup and restore in
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 mydb>mydbfile
or restore a database in a query like below ?
mysql.exe -h 192.168.0.1 -u root -p -C mydbThen we can do backup a
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
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
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, i
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 clien
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 s
ucture.
Our table defintitions are relatively stable so we don't do it every
night. You could put 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: Ba
>
> -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 I
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
1 - 100 of 277 matches
Mail list logo
