search for: myi

...ve the existing file and create the link like we wanted it to with --link-dest? Let's try another file just to prove that it will create a link if the destination file doesn't exist: Two different files, same use case though: # /bin/ls -li {source,dest}/var/lib/mysql/mythconverg/jobqueue.MYI 44695518 -rw-rw---- 2 sshd messagebus 5120 2012-01-19 00:31 source/var/lib/mysql/mythconverg/jobqueue.MYI 49676956 -rw-rw---- 1 sshd messagebus 5120 2012-01-18 12:00 dest/var/lib/mysql/mythconverg/jobqueue.MYI Different content again: # md5sum {source,dest}/var/lib/mysql/mythconverg/jobqueue.MYI...

...ve the existing file and create the link like we wanted it to with --link-dest? Let's try another file just to prove that it will create a link if the destination file doesn't exist: Two different files, same use case though: # /bin/ls -li {source,dest}/var/lib/mysql/mythconverg/jobqueue.MYI 44695518 -rw-rw---- 2 sshd messagebus 5120 2012-01-19 00:31 source/var/lib/mysql/mythconverg/jobqueue.MYI 49676956 -rw-rw---- 1 sshd messagebus 5120 2012-01-18 12:00 dest/var/lib/mysql/mythconverg/jobqueue.MYI Different content again: # md5sum {source,dest}/var/lib/mysql/mythconverg/jobqueue.MYI...

...e most common line, and work from there. I did go through the manpage for sort, and googled a bit, but I found nothing relevant. Here is an example of the output: [root@ log]# tail mysqld.log 110925 11:05:35 [ERROR] /usr/libexec/mysqld: Incorrect key file for table './ox_data_summary_ad_hourly.MYI'; try to repair it 110925 11:05:35 [ERROR] /usr/libexec/mysqld: Incorrect key file for table './ox_data_summary_ad_hourly.MYI'; try to repair it 110925 12:05:28 [ERROR] /usr/libexec/mysqld: Incorrect key file for table './ox_data_intermediate_ad.MYI'; try to repair it 110925 12:...

Hello group, I'm having a very hard time rsyncing efficiently a MySQL database which contains very large binary blobs. (Actually, it's the database of Mantis bug tracker [http://www.mantisbt.org/], with file attachments stored directly in the table rows. I know it's a bad idea from many other reasons, but let's say it was given to me as such.) First, I was dumping the

...receiver] send_msg_int(100, 1701) 04:41:03 [6281] recv_files(mysql/innodb_table_stats.ibd) 04:41:03 [6281] sender finished //mysql/innodb_table_stats.ibd 04:41:03 [6281] send_files(1749, //mysql/user.MYD) 04:41:03 [6281] sender finished //mysql/user.MYD 04:41:03 [6281] send_files(1750, //mysql/user.MYI) 04:41:03 [6281] sender finished //mysql/user.MYI 04:41:03 [6281] send_files(1806, //some_dbase) 04:41:03 [6281] send_files(1808, //some_dbase/actions.ibd) 04:41:03 [6281] >f.st...... mysql/innodb_table_stats.ibd 04:41:03 [6281] finishing mysql/innodb_table_stats.ibd 04:41:03 [6281] set modtime...

...re they could be transfered (code 24) at main.c(1048) In my server log,I get : 2004/08/11 12:19:23 [2912] rsync on db from db@beijingdb (192.168.0.12) 2004/08/11 12:19:23 [2912] file has vanished: "/phpinfo.php" (in db) 2004/08/11 12:19:23 [2912] file has vanished: "/mms/Downmmslog.MYI" (in db) 2004/08/11 12:19:23 [2912] file has vanished: "/mms/Downmmslog.MYD" (in db) 2004/08/11 12:19:23 [2912] file has vanished: "/mms/Downmmslog_20040420.frm" (in db) 2004/08/11 12:19:23 [2912] file has vanished: "/mms/Downmmslog_20040420.MYD" (in db) 2004/08...

Hi- I posted this under the MySQL group as well, but I thought some other Rails folks may have seen this before?? "Mysql::Error: Can''t create/write to file ''/var/lib/mysql/ #sql_146a_0.MYI'' (Errcode: 30)" Anyone know what this means, and how to fix it? Thanks! --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonr...

...this function with a vector argument, I got no error/warning messages in R1.5.1 (under Windows 2000). Furthermore, the results were generally incorect (please see the attached results). However, if I vectorized it using "ifelse" everything is fine (I created a function called "myI.1" to do this). I was wondering if there are functions in other packages, where such problems exist due to non-vectorization? thanks, Ravi. ####################################################### > require(CircStats) > I.1(1:10) [1] 0.5651591 1.5906369 3.9533702 9.75946...

Hi, I posted earlier about 'sip show registry' not showing any trunks and there seeming to be no attempt by one of my systems to register with our service provider. Following some notes elsewhere I ran 'myisamchk *.MYI' on the mysql database and it came up with an error in sip.MYI, which I repaired. Unfortunately, still no registration so I backed up the database, deleted the trunk details in the database using phpmyadmin and then re-made it. Still no joy. I am hoping I am close to solving this...

..."entrezgene",seqType="peptide", mart=ensembl) Error in getBM(c(seqType, type), filters = type, values = id, mart = mart,  :    Query ERROR: caught BioMart::Exception::Database: Error during query execution: Can't create/write to file '/mnt/ephemeral0/mysqltmp/#sql_40a_0.MYI' (Errcode: 2) I need help please. /.......Tanvir Ahamed [[alternative HTML version deleted]]

I receive the error: #126: Incorrect key file for table '/tmp/#sql_aa5_0.MYI'; try to repair it when I try to load `reviews.llvm.org` with my logged-in session. This error does not crop up if I use incognito mode. Can anyone else repo this? Thanks, ~Siddhart -- Sending this from my phone, please excuse any typos! -------------- next part -------------- An HTML attach...

...t;%t %b %f %l %M" --delete --stats -e "ssh -i /root/rsync/authors-rsync-key" backup at mydomain.com:/disk2/www /backup/seic37 2>&1 >> /var/log/rsync/rsync.log This works fine and I get the log file entry that shows this: 2011/11/22 13:20:51 2089 acad0304/alllibdirstaff.MYI 2048 2011/08/31-12:46:20 I would like to include the IP and/or hostname of the machine being backed up, but when I use %a (remote IP) or %h (remote host) in the -log-format=, it just writes the literal %a or %h in those fields. Could this be because I am running scripts from the machine that is on...

...<j.ray at qmul.ac.uk> Computing Services (http://pub.tsn.dk/how-to-quote.php) Queen Mary, University of London -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAktxLvgACgkQcGHKt+AwrtjkZgCgjmqOJ5GH/Myi/siTlx+1hbNE m3IAniZmq2vxv98P8OxMcunlWj6jTnFS =GNAH -----END PGP SIGNATURE-----

In our low-traffic server we have always kept the default value for IMAP mail_max_userip_connections (10). The server has been working fine! (Thank you Timo for this!) However, recently we have been having: Maximum number of connections from user+IP exceeded errors both for IMAP and webmail users. Thus, we have now changed the value to 100. The questions: 1.Might this lead to

...0}) read(0, "\246\336}\243\356\4\335\211\324\222\227\246D\333\204\207"..., 8184) = 8184 select(1, [0], [], NULL, {60, 0}) = 1 (in [0], left {60, 0}) read(0, "\336d\255\322\314\\\t\2565\4\335\366V\31\1\10\342\221\264"..., 8184) = 1270 open("/var/lib/mysql/phphits/log.MYI", O_RDONLY|O_LARGEFILE) = 3 fstat64(3, {st_mode=S_IFREG|0660, st_size=2628608, ...}) = 0 mmap2(NULL, 266240, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0xb5a3f000 read(3, "\376\376\7\1\0\2\1\224\0\260\0d\0\310\0\2\0\0\1\0\10\1"..., 263408) = 263408 read(3, "2.13...

Hi, I want to apologise for my bad english (I'm french). So I need to Back-up a lot of datas from a place to an another by the way of rsync with ssh naturally. A good question from my boss was : What happened when the mysql database is used by a user during the Backup ? Is the system stop the Backup or is it transparency for rsync ? Sorry if my question is stupid but I haven't

...xt2 partition to an ext3 and kjournald crashed. Here are the last reminants of my shell scrollback: [*ROOT* mofo /mnt/sda1/mysql/fd 641 ] ll oldmail/ total 2363288 -rw-rw---- 1 mysql mysql 2147483647 Jan 23 18:04 maillog.MYD -rw-rw---- 1 mysql mysql 270138368 Jan 23 18:06 maillog.MYI -rw-rw---- 1 mysql mysql 8910 Mar 22 2002 maillog.frm [*ROOT* mofo /mnt/sda1/mysql/fd 642 ] df Filesystem 1k-blocks Used Available Use% Mounted on /dev/hda1 8064272 4529888 3124732 60% / /dev/hda3 29387900 1488316 26406744 6% /home non...

...xt2 partition to an ext3 and kjournald crashed. Here are the last reminants of my shell scrollback: [*ROOT* mofo /mnt/sda1/mysql/fd 641 ] ll oldmail/ total 2363288 -rw-rw---- 1 mysql mysql 2147483647 Jan 23 18:04 maillog.MYD -rw-rw---- 1 mysql mysql 270138368 Jan 23 18:06 maillog.MYI -rw-rw---- 1 mysql mysql 8910 Mar 22 2002 maillog.frm [*ROOT* mofo /mnt/sda1/mysql/fd 642 ] df Filesystem 1k-blocks Used Available Use% Mounted on /dev/hda1 8064272 4529888 3124732 60% / /dev/hda3 29387900 1488316 26406744 6% /home non...

...error: rsync: chown "/east/volcombo_a1/fpga-gt/tools/fpgaLampServer/backups/lamp/2011.09.17.00.30.05/mysql/idte/.Downloads.MYD.BQayuj" failed: Permission denied (13) rsync: chown "/east/volcombo_a1/fpga-gt/tools/fpgaLampServer/backups/lamp/2011.09.17.00.30.05/mysql/idte/.Downloads.MYI.CQayuj" failed: Permission denied (13) rsync: chown "/east/volcombo_a1/fpga-gt/tools/fpgaLampServer/backups/lamp/2011.09.17.00.30.05/mysql/idte/.FPGACheckOut.MYD.DQayuj" failed: Permission denied (13) rsync: chownfailed: Permission denied (13) Were using the following cmds at prese...

depends on "autoconf: regenerate configure scripts with 4.4 version" This series removes some of the really old deadwood from the tools build and makes some other things which are on their way out configurable at build time with a default depending on how far down the slope I judge them to be. * nuke in tree copy of libaio * nuke obsolete tools: xsview, miniterm, lomount & sv *