Grokbase Groups MySQL backup
FAQ

Search Discussions

53 discussions - 171 posts

  • Hiya folks. So I have this bash script that performs a repair and analyze on a database. It then does a mysqldump into a chosen directory. When I call this script in the shell, it works just fine ...
    VPVP
    Jul 3, 2013 at 5:58 pm
    Jul 3, 2013 at 7:12 pm
  • Hello! We use mysqlhotcopy to make backups. What is the proper way to use it on slave server? I've found in doc that I should stop the sql thread and check the value of Slave_open_temp_tables, if ...
    Hleb ValoshkaHleb Valoshka
    Mar 21, 2013 at 10:11 am
    Mar 21, 2013 at 10:11 am
  • My Mysql-Server (based on Debian Squeeze) will not start. If i try to start manually i get this messages: ----------------------------------------------- 130212 20:29:57 [Note] Plugin 'FEDERATED' is ...
    Martin WodrichMartin Wodrich
    Feb 12, 2013 at 8:08 pm
    Feb 13, 2013 at 8:03 am
  • Hello. I am a new user of MySQL and do not know which is the correct group to post this to. I hope I did not violate protocol by sending it to two groups at once. I am running MySQL on a Microsoft ...
    HaisHais
    Oct 17, 2012 at 9:24 pm
    Oct 17, 2012 at 9:24 pm
  • Hello *, My INNODB database has a size of 80GO. I've a replication setup on 3 slaves and I backup my db from them. If a problem occurs on the database, a recovery from a dump takes around 6H ! That's ...
    Manuel ArosteguiManuel Arostegui
    Sep 1, 2012 at 7:16 pm
    Sep 2, 2012 at 11:53 am
  • Hello *, My INNODB database has a size of 80GO. I've a replication setup on 3 slaves and I backup my db from them. If a problem occurs on the database, a recovery from a dump takes around 6H ! That's ...
    Bob SauvageBob Sauvage
    Aug 14, 2012 at 8:00 am
    Aug 14, 2012 at 8:00 am
  • To confirm that you would like <span class="m_body_email_addr" title="38c5e321ea462d1a40de26a6353ba09d" jlistreader@gmail.com</span added to the backup mailing list, please click on the following ...
    Backup-helpBackup-help
    Dec 5, 2011 at 10:15 am
    Dec 5, 2011 at 10:15 am
  • Hello, It is very fast to copy raw files, say for MyISAM, compared to mysqldump. I am wondering if the raw file format ever evolves that later releases on a different arch won't get it right. Thanks, ...
    Kaiwang ChenKaiwang Chen
    Oct 21, 2010 at 5:01 pm
    Oct 21, 2010 at 5:01 pm
  • Hi all, How to install multiple instances in windows??? Thank you.
    KranthiKranthi
    Oct 19, 2010 at 4:45 pm
    Oct 19, 2010 at 4:48 pm
  • PhpMyAdmin is commonly used to administer MySQL databases including for backup and export purposes - however, sometimes a test database becomes considerably large in size running into several ...
    Junaid NazirJunaid Nazir
    Oct 13, 2010 at 2:16 pm
    Oct 13, 2010 at 2:16 pm
  • Hi Please be send sample incremental backup script (bash Shell script Easy to understand) Thanks & Regards, Kranthikiran
    KranthiKranthi
    Oct 13, 2010 at 1:19 pm
    Oct 13, 2010 at 2:23 pm
  • 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. Thanks & Regards, Kranti
    KranthiKranthi
    Oct 10, 2010 at 3:51 am
    Oct 11, 2010 at 10:30 am
  • HI we are having a mysql database <http://www.dbforums.com/# which is around 200gb.iam using mysqldump for backup this database. the restoration is taking so much of time. Could anyone suggest me to ...
    Asmith varmaAsmith varma
    Sep 28, 2010 at 7:30 pm
    Sep 30, 2010 at 5:37 pm
  • Hi team, just in case that this is not common knowledge: $MYSQL_TMP_DIR is not necessarily equal to $MYSQLTEST_VARDIR/tmp. I always thought, it was. And in my environment it is. On Pushbuild it is ...
    Ingo StrüwingIngo Strüwing
    May 11, 2010 at 7:21 am
    May 11, 2010 at 7:21 am
  • Hi Pekka, please help. In our test environment "Pushbuild", innobackup 1.5.2 fails with an error message, which doesn't help me to guess, what the possible problem could be. Innobackup writes the ...
    Ingo StrüwingIngo Strüwing
    May 10, 2010 at 7:07 pm
    May 11, 2010 at 2:47 pm
  • Hi team, please note that I collected these deficiencies of innobackup with respect to mysql-test-run testing by now: 1. innobackup does not allow its caller to select the target directory. It allows ...
    Ingo StrüwingIngo Strüwing
    May 3, 2010 at 2:47 pm
    May 4, 2010 at 8:57 am
  • Hi all, We're currently looking for a way to backup a pretty big mysql table to a csv file. However, we don't want to allow the user ssh or file access to the server, so it'd have to happen remotely. ...
    Marijn VandevoordeMarijn Vandevoorde
    Apr 22, 2010 at 9:08 am
    Apr 22, 2010 at 9:08 am
  • Hi Pekka, on http://www.innodb.com/products/hot-backup/features/, I read: "High performance — backup time is comparable to file copy, applying logs for recovery is even faster." While I have an idea, ...
    Ingo StrüwingIngo Strüwing
    Mar 31, 2010 at 1:24 pm
    Apr 1, 2010 at 8:43 am
  • Hi guys, I've been reading High Performance MySQL 2nd Edition book, Maatkit documentation, and googling to try to learn what my options are in terms of backing up and recovery of MySQL. For our ...
    Konstantin KKonstantin K
    Feb 21, 2010 at 12:54 am
    Feb 21, 2010 at 12:54 am
  • Hi Hema, as far as I can imagine, the problem is that the test uses character strings, which do not contain valid SJIS characters. Some change in the server seems to behave different on invalid ...
    Ingo StrüwingIngo Strüwing
    Feb 20, 2010 at 6:26 pm
    Feb 22, 2010 at 2:53 pm
  • Hi Runtime-Team, one backup test relies on the ability of dynamic arrays to do a memory allocation for every insert. In 6.0 this could be done by setting initial allocation to 0 and allocation ...
    Ingo StrüwingIngo Strüwing
    Feb 3, 2010 at 5:19 pm
    Feb 3, 2010 at 7:18 pm
  • Hi Thava, according to https://intranet.mysql.com/~lthalmann/ltplan.pl?file=faq.org&section=Merge_Captain? you are Merge Captain for the backup team this month. ...
    Ingo StrüwingIngo Strüwing
    Feb 1, 2010 at 11:55 am
    Feb 1, 2010 at 11:55 am
  • Hi Chuck, in mysql-backup-backport we have a mysql-test/collections/mysql-backup-next.push Due to mysql-test/collections/README it is improbable that this file will be used. It does not match the ...
    Ingo StrüwingIngo Strüwing
    Jan 15, 2010 at 8:22 pm
    Jan 15, 2010 at 8:36 pm
  • Hi Rafal, In 6.0 I found: #ifndef DBUG_OFF if (lex- sql_command != SQLCOM_SET_OPTION) DEBUG_SYNC(thd,"before_execute_sql_command"); #endif Hi Chuck, In 5.6 I found #ifndef DBUG_OFF // if (lex- ...
    Ingo StrüwingIngo Strüwing
    Jan 12, 2010 at 9:45 am
    Jan 14, 2010 at 10:46 am
  • Hi Alik, Bug#50087 (Interval arithmetic for Event_queue_element is not portable) makes mysql-6.0-backup pretty red. I would like to have the fix in our tree. Will mysql-6.0-codebase-bugfixing be ...
    Ingo StrüwingIngo Strüwing
    Jan 11, 2010 at 12:07 pm
    Jan 11, 2010 at 12:26 pm
  • Hi Ritheesh, Team, Ritheesh Vedire, 07.12.2009 18:48: ... Under these circumstances I vote for either: 1. accept that a warning appears in error log only. or 2. reject as not a bug. I re-read the bug ...
    Ingo StrüwingIngo Strüwing
    Dec 8, 2009 at 9:15 am
    Dec 8, 2009 at 9:15 am
  • Hi there. I just subscribed to this list, but I have a few questions. I have been running a MySQL server on my desktop, to import a LOT of data, so that I don't bog down the server (it's been running ...
    Steven StaplesSteven Staples
    Dec 3, 2009 at 1:18 pm
    Dec 3, 2009 at 3:59 pm
  • So... I'm trying to export a fairly large database (~10 GB). I've done it dozens of times before, using scripts on a regular basis. Now, the database is growing, and lately, every dump file produced ...
    René FournierRené Fournier
    Nov 22, 2009 at 7:42 am
    Nov 22, 2009 at 7:42 am
  • I've been using automysqlbackup 2.5 for years on a particular database, and it's always performed great. Recently, however, I've become encountering problems when trying to re-import one of its ...
    René FournierRené Fournier
    Nov 20, 2009 at 7:39 pm
    Nov 23, 2009 at 8:24 am
  • Hi Chuck, please have a look at my note to the bug report. http://bugs.mysql.com/bug.php?id=47804 I guess, you could create a Windows image locally and look, if it shows the same behavior. Please ...
    Ingo StrüwingIngo Strüwing
    Nov 13, 2009 at 3:46 pm
    Nov 13, 2009 at 6:22 pm
  • Hi Lars, Rafal, Andreas, I approved the HLS in its current version. We can now write the LLD. Regards Ingo -- Ingo Strüwing, Database Group Sun Microsystems GmbH, Sonnenallee 1, D-85551 ...
    Ingo StrüwingIngo Strüwing
    Nov 4, 2009 at 12:28 pm
    Nov 6, 2009 at 10:29 am
  • Dear team members, lately I've seen an increasing number of commits that miss due care. Added end-space, scrambled indentation even in existing lines, seemingly forgotten runs of the test suite, etc. ...
    Ingo StrüwingIngo Strüwing
    Nov 3, 2009 at 8:29 pm
    Nov 3, 2009 at 8:29 pm
  • I posted this bug with OpenSuSE - but there's been no action on it. Thought I'd see if anyone here had some ideas. Mysqldump hangs with ** DEAD ** processes in the processlist and concurrently an ...
    LisaLisa
    Nov 2, 2009 at 11:38 pm
    Nov 2, 2009 at 11:38 pm
  • Hi Mats, I am working on a design for backup storage modules (WL#5046). One of the aspects of the design is how errors from the modules are reported to the module user and then to the final mysqld ...
    Rafal SomlaRafal Somla
    Oct 27, 2009 at 1:48 pm
    Nov 5, 2009 at 11:28 am
  • Hi, I've described in HLS a proposition how to handle errors from backup storage modules. Please have a look and let me know if you have any comments on that. Rafal
    Rafal SomlaRafal Somla
    Oct 24, 2009 at 2:03 pm
    Nov 4, 2009 at 9:29 am
  • Hi, I want your comments on my proposition to change specification of the "initialize backup session" service (S1) and its consequences for the logic selecting BSM for a given location. I propose to ...
    Rafal SomlaRafal Somla
    Oct 24, 2009 at 10:32 am
    Oct 24, 2009 at 4:45 pm
  • Hi Again, I'm afraid I misunderstood Ingo's suggestion of how to specify native/internal compression and did not describe it correctly in HLS (alternative A2). Looks like now we have 3 alternatives ...
    Rafal SomlaRafal Somla
    Oct 22, 2009 at 12:41 pm
    Oct 23, 2009 at 7:30 am
  • Ingo, Andreas, I have updated HLS. You might want to check if I accurately described the alternatives which you suggested in your comments and if I haven't missed something you consider important. ...
    Rafal SomlaRafal Somla
    Oct 14, 2009 at 12:35 pm
    Oct 23, 2009 at 2:04 pm
  • Hi Andreas, I'm sending you replies to your comments on the design (which I should really have done long time ago :/). We can also discuss/calrify these during our call tomorrow. I will update ...
    Rafal SomlaRafal Somla
    Oct 14, 2009 at 8:25 am
    Oct 14, 2009 at 8:25 am
  • Hi Ingo, Thank you for your comments and my apologies again for delaying my answer for so long. The actions which I'm going (or not going) to take in response to your comments are: 1. Add to HLS the ...
    Rafal SomlaRafal Somla
    Oct 13, 2009 at 12:51 pm
    Nov 3, 2009 at 1:52 pm
  • Hi Rafal, Last merge main- team: September 9 Last merge team- main: August 28 Disabled Tests: none Experimental Tests: backup.backup_all # BUG#42756 (patch queued, seems to be stable now) ...
    Ingo StrüwingIngo Strüwing
    Oct 2, 2009 at 1:21 pm
    Oct 5, 2009 at 7:19 am
  • Hi Lars, at a backup decision meeting, I suggest to talk about the creation and modification dates of stored functions and procedures. At the moment, RESTORE creates the procedures right away, which ...
    Ingo StrüwingIngo Strüwing
    Sep 23, 2009 at 11:18 am
    Sep 24, 2009 at 4:23 pm
  • Hi Chuck, team, after a merge of mysql-6.0-backup and mysql-6.0-codebase, I get the following failure on my local Linux x86_64 machine: backup.backup_logs w4 [ fail ] Test ended at 2009-09-21 ...
    Ingo StrüwingIngo Strüwing
    Sep 22, 2009 at 9:57 am
    Sep 28, 2009 at 8:45 am
  • Hi Lars, please mark my action items in the minutes-of-meeting from the 2009-09-01 backup meeting as closed. 1. I verified that it is not possible with plain INSERT and ALTER statements to generate ...
    Ingo StrüwingIngo Strüwing
    Sep 21, 2009 at 3:44 pm
    Sep 23, 2009 at 5:23 am
  • Hi Lars, Disclaimer: I may have missed the respective announcement(s). In this case please point me at them. Problem: If I understand correctly, Betony will be built on Azalea, which is built on 5.1. ...
    Ingo StrüwingIngo Strüwing
    Sep 17, 2009 at 4:02 pm
    Sep 17, 2009 at 4:10 pm
  • Hi Jørgen, Rafal and I tracked the problem down to a bug in be_default.cc. In Backup::get_data() we have a wrong "optimization": /* Optimization: If this is the last table to read, close the tables ...
    Ingo StrüwingIngo Strüwing
    Sep 11, 2009 at 2:44 pm
    Sep 13, 2009 at 7:01 pm
  • Hi team, For your information: Today I pushed a merge of mysql-next and mysql-6.0-backup to mysql-6.0-backup. Regards Ingo -- Ingo Strüwing, Database Group Sun Microsystems GmbH, Sonnenallee 1, ...
    Ingo StrüwingIngo Strüwing
    Sep 9, 2009 at 7:56 pm
    Sep 9, 2009 at 7:56 pm
  • Hi Hema, Can we please make backup_row_size a "big" test? To run backup_row_size successfully on my machine, I need to increase the per-process memory limit to 4GB! The consequence is that some ...
    Ingo StrüwingIngo Strüwing
    Sep 8, 2009 at 9:05 am
    Sep 8, 2009 at 9:05 am
  • Hi Chuck, I don't know, what to do about it. The information in this email is too little to draw any conclusions from it. On my 64-bit Ubuntu machine, backup_log_filesize crashes in getenv() from ...
    Ingo StrüwingIngo Strüwing
    Sep 4, 2009 at 12:43 pm
    Sep 4, 2009 at 12:43 pm
  • There are errors in backup files when compiling with distcheck target. Does anyone feel responsible? $ make distcheck (...) ../../../unittest/backup/test_stream.c:7:23: error: my_global.h: No such ...
    Jørgen LølandJørgen Løland
    Aug 18, 2009 at 1:15 pm
    Aug 20, 2009 at 8:28 am
Group Navigation
period‹ prev | Latest | first ›
Group Overview
groupbackup @
categoriesmysql
discussions53
posts171
users36
websitemysql.com
irc#mysql

Top users

Ingo Strüwing: 62 posts Rafal Somla: 34 posts Charles Bell: 10 posts Andreas Almroth: 10 posts Martin Wodrich: 8 posts Kranthi: 4 posts Jørgen Løland: 4 posts Manuel Arostegui: 3 posts Pekka Lampio: 3 posts Steven Staples: 2 posts René Fournier: 2 posts VP: 2 posts Asmith varma: 2 posts Susanne Ebrecht: 2 posts Hleb Valoshka: 2 posts Emre Hasegeli: 1 post Junaid Nazir: 1 post Mats Kindahl: 1 post Shawn Green (MySQL): 1 post Bob Sauvage: 1 post
show more