Re: upgraded from 5.1-5.5. now getting a mysqldump ERROR 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES. a bug or my config?
I haven't bothered to look for the bug, but it seems to me to be quite reasonable default behaviour to lock the whole lot when you're dumping transactional tables - it ensures you dump all tables from the same consistent view. I would rather take this up with the ZRM people - it should just work. 3.3 came out last week, you may want to have a look at wether it's already been adressed there. Harald's solution is, as usual, technically superior; but he keeps having trouble understanding people not wanting to change their entire setup because their solution isn't optimal :-) -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: upgraded from 5.1-5.5. now getting a mysqldump ERROR 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES. a bug or my config?
On Mon, 06 Jun 2011 12:44 +0200, Johan De Meersman vegiv...@tuxera.be wrote: I haven't bothered to look for the bug, but it seems to me to be quite reasonable default behaviour to lock the whole lot when you're dumping transactional tables - it ensures you dump all tables from the same consistent view. thanks for the comment. I would rather take this up with the ZRM people - it should just work. this, http://bugs.mysql.com/bug.php?id=61414 suggests the same. so, i've already started that discussion as well, http://forums.zmanda.com/showthread.php?t=3703 Excluding 'performance_schema' appears to eliminate the error. And it seems does NOT cause a reliability-of-the-backup problem. 3.3 came out last week, you may want to have a look at wether it's already been adressed there. I believe that's an Amanda 3.3 release you're referring to. ZRM is still at 2.2, http://www.zmanda.com/download-zrm.php ZRM for MySQL, Version 2.2 is the Latest Stable Release and, i've MySQL-zrm-2.2.0-1.noarch installed. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: upgraded from 5.1-5.5. now getting a mysqldump ERROR 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES. a bug or my config?
- Original Message - From: ag...@airpost.net Excluding 'performance_schema' appears to eliminate the error. And it seems does NOT cause a reliability-of-the-backup problem. Hah, no, backing that up is utterly pointless. Never noticed it doing that. It's basically a virtual schema that contains realtime information about the database, intended to replace a lot of show tables parsing and similar mayhem with simple select statements. I believe that's an Amanda 3.3 release you're referring to. ZRM is still at 2.2, No, I do mean 3.3. Apparently the free downloadable version is quite a bit behind the commercial one. Maybe that's why I never noticed it backing up the performance schema, too :-) They're not really that expensive, either, it might well be worth it to grab licenses and support. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: upgraded from 5.1-5.5. now getting a mysqldump ERROR 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES. a bug or my config?
On Mon, 06 Jun 2011 18:54 +0200, Johan De Meersman vegiv...@tuxera.be wrote: Excluding 'performance_schema' appears to eliminate the error. And it seems does NOT cause a reliability-of-the-backup problem. Hah, no, backing that up is utterly pointless. that's a useful/final confirmation. thx. No, I do mean 3.3. Apparently the free downloadable version is quite a bit behind the commercial one. Maybe that's why I never noticed it backing up the performance schema, too :-) i didn't catch that ZRM's commercial version was at 3.3! thx. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
upgraded from 5.1-5.5. now getting a mysqldump ERROR 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES. a bug or my config?
i use ZRM to do backups of my databases. with v5.1.x, this works fine, mysql-zrm-scheduler --now --backup-set manual --backup-level 0 to execute a manual backup. i recently upgraded from v5.1.x - v5.5.12, mysqladmin -V mysqladmin Ver 8.42 Distrib 5.5.12, for Linux on i686 now, at exec of that backup cmd, i see an ERROR @ console, ... manual:backup:INFO: PHASE START: Creating raw backup manual:backup:INFO: Command used for raw backup is /usr/share/mysql-zrm/plugins/socket-copy.pl --mysqlhotcopy=/usr/bin --host=localhost --port=3306 --socket=/var/cache/mysql/mysql.sock --quiet mysql /var/mysql-bkup/manual/20110605131003 /var/cache/tmp/bZvaQFwQY2 21 manual:backup:INFO: raw-databases=mysql manual:backup:INFO: PHASE END: Creating raw backup manual:backup:INFO: PHASE START: Creating logical backup manual:backup:WARNING: The database(s) drupal6 performance_schema will be backed up in logical mode since they contain tables that use a transactional engine. manual:backup:INFO: Command used for logical backup is /usr/bin/mysqldump --opt --extended-insert --create-options --default-character-set=utf8 --routines --host=localhost --port=3306 --socket=/var/cache/mysql/mysql.sock --databases drupal6 performance_schema /var/mysql-bkup/manual/20110605131003/backup.sql mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES -- manual:backup:ERROR: mysqldump did not succeed. Command used is /usr/bin/mysqldump --opt --extended-insert --create-options --default-character-set=utf8 --routines --host=localhost --port=3306 --socket=/var/cache/mysql/mysql.sock --databases drupal6 performance_schema /var/mysql-bkup/manual/20110605131003/backup.sqlmanual:backup:INFO: PHASE START: Cleanup manual:backup:INFO: backup-status=Backup failed ... reading up on the error at, http://bugs.mysql.com/bug.php?id=33762 http://bugs.mysql.com/bug.php?id=49633 it looks to do with mysqldump itself. i modified in /etc/my.cnf ... [mysqldump] quick quote-names max_allowed_packet = 8M + skip-lock-tables ... but that doesn't seem to make any difference. something's changed between 5.1.x 5.5.x. what do i need to modify to get past this error? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: upgraded from 5.1-5.5. now getting a mysqldump ERROR 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES. a bug or my config?
have you checked you permissions-table if all privileges are active for root and have you started ymsql_upgrade after all updates? Am 05.06.2011 22:20, schrieb ag...@airpost.net: i use ZRM to do backups of my databases. with v5.1.x, this works fine, mysql-zrm-scheduler --now --backup-set manual --backup-level 0 to execute a manual backup. i recently upgraded from v5.1.x - v5.5.12, mysqladmin -V mysqladmin Ver 8.42 Distrib 5.5.12, for Linux on i686 now, at exec of that backup cmd, i see an ERROR @ console, ... manual:backup:INFO: PHASE START: Creating raw backup manual:backup:INFO: Command used for raw backup is /usr/share/mysql-zrm/plugins/socket-copy.pl --mysqlhotcopy=/usr/bin --host=localhost --port=3306 --socket=/var/cache/mysql/mysql.sock --quiet mysql /var/mysql-bkup/manual/20110605131003 /var/cache/tmp/bZvaQFwQY2 21 manual:backup:INFO: raw-databases=mysql manual:backup:INFO: PHASE END: Creating raw backup manual:backup:INFO: PHASE START: Creating logical backup manual:backup:WARNING: The database(s) drupal6 performance_schema will be backed up in logical mode since they contain tables that use a transactional engine. manual:backup:INFO: Command used for logical backup is /usr/bin/mysqldump --opt --extended-insert --create-options --default-character-set=utf8 --routines --host=localhost --port=3306 --socket=/var/cache/mysql/mysql.sock --databases drupal6 performance_schema /var/mysql-bkup/manual/20110605131003/backup.sql mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES -- manual:backup:ERROR: mysqldump did not succeed. Command used is /usr/bin/mysqldump --opt --extended-insert --create-options --default-character-set=utf8 --routines --host=localhost --port=3306 --socket=/var/cache/mysql/mysql.sock --databases drupal6 performance_schema /var/mysql-bkup/manual/20110605131003/backup.sqlmanual:backup:INFO: PHASE START: Cleanup manual:backup:INFO: backup-status=Backup failed ... reading up on the error at, http://bugs.mysql.com/bug.php?id=33762 http://bugs.mysql.com/bug.php?id=49633 it looks to do with mysqldump itself. i modified in /etc/my.cnf ... [mysqldump] quick quote-names max_allowed_packet = 8M + skip-lock-tables ... but that doesn't seem to make any difference. something's changed between 5.1.x 5.5.x. what do i need to modify to get past this error? -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm signature.asc Description: OpenPGP digital signature
Re: upgraded from 5.1-5.5. now getting a mysqldump ERROR 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES. a bug or my config?
hi, On Sun, 05 Jun 2011 22:24 +0200, Reindl Harald h.rei...@thelounge.net wrote: have you checked you permissions-table if all privileges are active for root i've got, mysql show grants for 'root'@'localhost'; ++ | Grants for root@localhost | ++ | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*3...4' WITH GRANT OPTION | | GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION | ++ and, mysql show grants for 'drupal_admin'@'localhost'; +--+ | Grants for drupal_admin@localhost | +--+ | GRANT USAGE ON *.* TO 'drupal_admin'@'localhost' IDENTIFIED BY PASSWORD '*D...D' | | GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON `drupal6`.* TO 'drupal_admin'@'localhost' | +--+ 17 rows in set (0.00 sec) are these sufficient? these permissions worked fine as far as i could tell for the v5.1.x install i had. and have you started ymsql_upgrade after all updates? yes, i'd already executed 'mysql_upgrade', following the instructions here: http://dev.mysql.com/doc/refman/5.5/en/upgrading-from-previous-series.html checking, mysql_upgrade Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck This installation of MySQL is already upgraded to 5.5.12, use --force if you still need to run mysql_upgrade -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: upgraded from 5.1-5.5. now getting a mysqldump ERROR 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES. a bug or my config?
the grant statements does nobody interest maybe use phpmyadmin for a clearer display mysql select * from mysql.user where user='root' limit 1; +---+--+---+-+-+-+-+-+---+-+---+--+---++-+++--++---+--+--+-+--+--++-++--++--++--++-+--+---+-+-+--++---+ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Create_user_priv | Event_priv | Trigger_priv | Create_tablespace_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | max_user_connections | plugin | authentication_string | +---+--+---+-+-+-+-+-+---+-+---+--+---++-+++--++---+--+--+-+--+--++-++--++--++--++-+--+---+-+-+--++---+ | localhost | root | * | Y | Y | Y | Y | Y | Y | Y | Y | Y| Y | Y | Y | Y | Y | Y | Y | Y | Y| Y | Y | Y | Y| Y | Y | Y | Y| Y | Y| Y | || | | 0 | 0 | 0 |0 || | +---+--+---+-+-+-+-+-+---+-+---+--+---++-+++--++---+--+--+-+--+--++-++--++--++--++-+--+---+-+-+--++---+ 1 row in set (0.00 sec) Am 05.06.2011 23:05, schrieb ag...@airpost.net: hi, On Sun, 05 Jun 2011 22:24 +0200, Reindl Harald h.rei...@thelounge.net wrote: have you checked you permissions-table if all privileges are active for root i've got, mysql show grants for 'root'@'localhost'; ++ | Grants for root@localhost | ++ | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*3...4' WITH GRANT OPTION | | GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION | ++ signature.asc Description: OpenPGP digital signature
Re: upgraded from 5.1-5.5. now getting a mysqldump ERROR 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES. a bug or my config?
fwiw, others are seeing this. e.g., in addition to the two bugs i'd already referenced, http://www.directadmin.com/forum/showthread.php?p=202053 and one http://qa.lampcms.com/q122897/Can-t-backup-mysql-table-with-mysqldump-SELECT-LOCK-TABL-command claims a solution Add --skip-add-locks to your mysqldump command which, having added as i mentioned above, to the [mysqldump] section of /etc/my.cnf, does NOT make a difference for me. On Sun, 05 Jun 2011 23:19 +0200, Reindl Harald h.rei...@thelounge.net wrote: the grant statements does nobody interest mysql select * from mysql.user where user='root' limit 1; and, my result for your cmd, mysql select * from mysql.user where user='root' limit 1; +---+--+---+-+-+-+-+-+---+-+---+--+---++-+++--++---+--+--+-+--+--++-++--++--++--++-+--+---+-+-+--++---+ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Create_user_priv | Event_priv | Trigger_priv | Create_tablespace_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | max_user_connections | plugin | authentication_string | +---+--+---+-+-+-+-+-+---+-+---+--+---++-+++--++---+--+--+-+--+--++-++--++--++--++-+--+---+-+-+--++---+ | localhost | root | *3..4 | Y | Y | Y | Y | Y | Y | Y | Y | Y| Y | Y | Y | Y | Y | Y| Y | Y | Y| Y| Y | Y| Y| Y | Y | Y | Y| Y | Y | Y | || | | 0 | 0 | 0 | 0 || NULL | +---+--+---+-+-+-+-+-+---+-+---+--+---++-+++--++---+--+--+-+--+--++-++--++--++--++-+--+---+-+-+--++---+ 1 row in set (0.06 sec) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: upgraded from 5.1-5.5. now getting a mysqldump ERROR 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES. a bug or my config?
hm - bad i would use a replication slave and stop him for consistent backups because dumb locks are not really a good solution independent if this works normally Am 05.06.2011 23:26, schrieb ag...@airpost.net: fwiw, others are seeing this. e.g., in addition to the two bugs i'd already referenced, http://www.directadmin.com/forum/showthread.php?p=202053 and one http://qa.lampcms.com/q122897/Can-t-backup-mysql-table-with-mysqldump-SELECT-LOCK-TABL-command claims a solution Add --skip-add-locks to your mysqldump command which, having added as i mentioned above, to the [mysqldump] section of /etc/my.cnf, does NOT make a difference for me. On Sun, 05 Jun 2011 23:19 +0200, Reindl Harald h.rei...@thelounge.net wrote: the grant statements does nobody interest mysql select * from mysql.user where user='root' limit 1; and, my result for your cmd, mysql select * from mysql.user where user='root' limit 1; +---+--+---+-+-+-+-+-+---+-+---+--+---++-+++--++---+--+--+-+--+--++-++--++--++--++-+--+---+-+-+--++---+ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Create_user_priv | Event_priv | Trigger_priv | Create_tablespace_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | max_user_connections | plugin | authentication_string | +---+--+---+-+-+-+-+-+---+-+---+--+---++-+++--++---+--+--+-+--+--++-++--++--++--++-+--+---+-+-+--++---+ | localhost | root | *3..4 | Y | Y | Y | Y | Y | Y | Y | Y | Y| Y | Y | Y | Y | Y | Y| Y | Y | Y| Y| Y | Y| Y| Y | Y | Y | Y| Y | Y | Y | || | | 0 | 0 | 0 | 0 || NULL | +---+--+---+-+-+-+-+-+---+-+---+--+---++-+++--++---+--+--+-+--+--++-++--++--++--++-+--+---+-+-+--++---+ 1 row in set (0.06 sec) -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm signature.asc Description: OpenPGP digital signature
Re: upgraded from 5.1-5.5. now getting a mysqldump ERROR 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES. a bug or my config?
BTW WHY is everybody ansering to the list AND the author of the last post? this reults in get every message twice :-( Am 05.06.2011 23:26, schrieb ag...@airpost.net: fwiw, others are seeing this. e.g., in addition to the two bugs i'd already referenced, http://www.directadmin.com/forum/showthread.php?p=202053 and one http://qa.lampcms.com/q122897/Can-t-backup-mysql-table-with-mysqldump-SELECT-LOCK-TABL-command claims a solution Add --skip-add-locks to your mysqldump command which, having added as i mentioned above, to the [mysqldump] section of /etc/my.cnf, does NOT make a difference for me. On Sun, 05 Jun 2011 23:19 +0200, Reindl Harald h.rei...@thelounge.net wrote: the grant statements does nobody interest mysql select * from mysql.user where user='root' limit 1; and, my result for your cmd, mysql select * from mysql.user where user='root' limit 1; +---+--+---+-+-+-+-+-+---+-+---+--+---++-+++--++---+--+--+-+--+--++-++--++--++--++-+--+---+-+-+--++---+ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Create_user_priv | Event_priv | Trigger_priv | Create_tablespace_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | max_user_connections | plugin | authentication_string | +---+--+---+-+-+-+-+-+---+-+---+--+---++-+++--++---+--+--+-+--+--++-++--++--++--++-+--+---+-+-+--++---+ | localhost | root | *3..4 | Y | Y | Y | Y | Y | Y | Y | Y | Y| Y | Y | Y | Y | Y | Y| Y | Y | Y| Y| Y | Y| Y| Y | Y | Y | Y| Y | Y | Y | || | | 0 | 0 | 0 | 0 || NULL | +---+--+---+-+-+-+-+-+---+-+---+--+---++-+++--++---+--+--+-+--+--++-++--++--++--++-+--+---+-+-+--++---+ 1 row in set (0.06 sec) -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm signature.asc Description: OpenPGP digital signature
Re: upgraded from 5.1-5.5. now getting a mysqldump ERROR 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES. a bug or my config?
On Sun, 05 Jun 2011 23:30 +0200, Reindl Harald h.rei...@thelounge.net wrote: BTW WHY is everybody ansering to the list AND the author of the last post? this reults in get every message twice :-( Reply - sends to ONLY the From == h.rei...@thelounge.net Reply to all sends to BOTH the From == h.rei...@thelounge.net AND the list. I suppose if the list manager software, or your client were configured differently ... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: upgraded from 5.1-5.5. now getting a mysqldump ERROR 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES. a bug or my config?
On Sun, 05 Jun 2011 23:29 +0200, Reindl Harald h.rei...@thelounge.net wrote: i would use a replication slave and stop him for consistent backups because dumb locks are not really a good solution independent if this works normally unfortunately, i have no idea what that means. something's apparently broken with mysqldump -- enough so that lots of people are seeing and reporting this same error after the 5.1 - 5.5 upgrade. why would setting up a replication slave be necessary or a good solution to the problem? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: upgraded from 5.1-5.5. now getting a mysqldump ERROR 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES. a bug or my config?
Am 05.06.2011 23:49, schrieb ag...@airpost.net: On Sun, 05 Jun 2011 23:29 +0200, Reindl Harald h.rei...@thelounge.net wrote: i would use a replication slave and stop him for consistent backups because dumb locks are not really a good solution independent if this works normally unfortunately, i have no idea what that means. something's apparently broken with mysqldump -- enough so that lots of people are seeing and reporting this same error after the 5.1 - 5.5 upgrade. why would setting up a replication slave be necessary or a good solution to the problem? because there is no lock on any production table? have fun using mysqldump with really hughe databases :-) a replication slave is synchron, you can stop the slave, copy the whole datadir and after starting the slave it will make all changes from the binary log signature.asc Description: OpenPGP digital signature
Re: upgraded from 5.1-5.5. now getting a mysqldump ERROR 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES. a bug or my config?
i still have no idea why this is necessary. there seems to be a but, problem, misconfiguration, etc. wouldn't it make some sense to try to FIX it, rather than setting up a completely different server? perhaps someone with an idea of the problem and its solution will be able to chime in. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: upgraded from 5.1-5.5. now getting a mysqldump ERROR 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES. a bug or my config?
Am 05.06.2011 23:55, schrieb ag...@airpost.net: i still have no idea why this is necessary. take it or not it is a professional solution which works for databses with 20 GB every day here with rsync without interrupt/lock mysqld a second and it is much faster there seems to be a but, problem, misconfiguration, etc. wouldn't it make some sense to try to FIX it, rather than setting up a completely different server? it takes 5 minutes starting a replication salve on the same machine with its own socket/port perhaps someone with an idea of the problem and its solution will be able to chime in. wait until it is fixed or think about a better solution which will work in the future signature.asc Description: OpenPGP digital signature
Re: mysqldump error 1064 for database Use command
Hi win.a, I tried with another user the problem still persists. I am getting same error for another user as well. -- Regards, Manasi Save On Tue, 7 Sep 2010 11:41:35 0800, win.a wrote: use another user and dump the data ,eg the root . mysqldump -uroot -p --al-databases AllNew_Databases_20100904.sql All you best What we are struggling for ? The life or the life ? On Mon, Sep 6, 2010 at 8:33 PM, Manasi Save manasi.s...@artificialmachines.com wrote: Hi win.a, How am I suppose put that command. Could you help me with the syntax: If I am giving it this way:- mysqldump --all-databases AllNew_Databases_20100904.sql then it says it will not work with my system user. nor with this it is working :- mysqldump -u --all-databases AllNew_Databases_20100904.sql -- Regards, Manasi Save On Mon, 6 Sep 2010 20:12:26 0800, win.a wrote: try it without username and password in command line,type it it prompts. All you best What we are struggling for ? The life or the life ? On Mon, Sep 6, 2010 at 3:28 PM, Manasi Save manasi.s...@artificialmachines.com wrote: No it does not. But when I dump database name mydb it does. but not the database with name 1. -- Regards, Manasi Save On Mon, 06 Sep 2010 09:23:21 0200, Jangita wrote: On 06/09/2010 6:54 a, Manasi Save wrote: Dear Nitin, I have newly installed mysql on this server. mysql Select version(); - | version() | - | 5.1.22-rc-Debian_2~ppa5-log | - Earlier I use to run the same command on Fedora-with same mysql version. I could not possibly change the database name. There are quite a few databases I have on the system. -- Regards, Manasi Save Does it work when you dump only the database `1`? -- Jangita | 256 76 91 8383 | Y! MSN: jang...@yahoo.com Skype: jangita | GTalk: jangita.nyag...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=manasi.s...@artificialmachines.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=win@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysqldump error 1064 for database Use command
I'm not sure but you might try with sql_mode set to ANSI. Otherwise try the dump remotely from a Linux box. Regards, Nitin From: Manasi Save manasi.s...@artificialmachines.com To: win.a win@gmail.com Cc: mysql@lists.mysql.com mysql@lists.mysql.com Sent: Wed, September 8, 2010 3:57:40 PM Subject: Re: mysqldump error 1064 for database Use command Hi win.a, I tried with another user the problem still persists. I am getting same error for another user as well. -- Regards, Manasi Save On Tue, 7 Sep 2010 11:41:35 0800, win.a wrote: use another user and dump the data ,eg the root . mysqldump -uroot -p --al-databases AllNew_Databases_20100904.sql All you best What we are struggling for ? The life or the life ? On Mon, Sep 6, 2010 at 8:33 PM, Manasi Save manasi.s...@artificialmachines.com wrote: Hi win.a, How am I suppose put that command. Could you help me with the syntax: If I am giving it this way:- mysqldump --all-databases AllNew_Databases_20100904.sql then it says it will not work with my system user. nor with this it is working :- mysqldump -u --all-databases AllNew_Databases_20100904.sql -- Regards, Manasi Save On Mon, 6 Sep 2010 20:12:26 0800, win.a wrote: try it without username and password in command line,type it it prompts. All you best What we are struggling for ? The life or the life ? On Mon, Sep 6, 2010 at 3:28 PM, Manasi Save manasi.s...@artificialmachines.com wrote: No it does not. But when I dump database name mydb it does. but not the database with name 1. -- Regards, Manasi Save On Mon, 06 Sep 2010 09:23:21 0200, Jangita wrote: On 06/09/2010 6:54 a, Manasi Save wrote: Dear Nitin, I have newly installed mysql on this server. mysql Select version(); - | version() | - | 5.1.22-rc-Debian_2~ppa5-log | - Earlier I use to run the same command on Fedora-with same mysql version. I could not possibly change the database name. There are quite a few databases I have on the system. -- Regards, Manasi Save Does it work when you dump only the database `1`? -- Jangita | 256 76 91 8383 | Y! MSN: jang...@yahoo.com Skype: jangita | GTalk: jangita.nyag...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=manasi.s...@artificialmachines.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=win@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=ntn...@yahoo.com
Re: mysqldump error 1064 for database Use command
On 06/09/2010 6:54 a, Manasi Save wrote: Dear Nitin, I have newly installed mysql on this server. mysql Select version(); +-+ | version() | +-+ | 5.1.22-rc-Debian_2~ppa5-log | +-+ Earlier I use to run the same command on Fedora-with same mysql version. I could not possibly change the database name. There are quite a few databases I have on the system. -- Regards, Manasi Save Does it work when you dump only the database `1`? -- Jangita | +256 76 91 8383 | Y! MSN: jang...@yahoo.com Skype: jangita | GTalk: jangita.nyag...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysqldump error 1064 for database Use command
No it does not. But when I dump database name mydb it does. but not the database with name 1. -- Regards, Manasi Save On Mon, 06 Sep 2010 09:23:21 0200, Jangita wrote: On 06/09/2010 6:54 a, Manasi Save wrote: Dear Nitin, I have newly installed mysql on this server. mysql Select version(); - | version() | - | 5.1.22-rc-Debian_2~ppa5-log | - Earlier I use to run the same command on Fedora-with same mysql version. I could not possibly change the database name. There are quite a few databases I have on the system. -- Regards, Manasi Save Does it work when you dump only the database `1`? -- Jangita | 256 76 91 8383 | Y! MSN: jang...@yahoo.com Skype: jangita | GTalk: jangita.nyag...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=manasi.s...@artificialmachines.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysqldump error 1064 for database Use command
Dear Nitin, I have newly installed mysql on this server. mysql Select version(); +-+ | version() | +-+ | 5.1.22-rc-Debian_2~ppa5-log | +-+ Earlier I use to run the same command on Fedora-with same mysql version. I could not possibly change the database name. There are quite a few databases I have on the system. --Regards, Manasi Save On Sat, 4 Sep 2010 21:00:22 -0700 (PDT), Nitin Mehta wrote: Hi, Have you recently upgraded your MySQL installation? 1064 in earlier days used to mean use of reserved word. Few clients have reported this error in last couple of months after they upgraded from 5.1.41 to higher versions. As of now, I don't have a solution other than changing the name (of database in your case). Hope that helps. Regards, Nitin From: Manasi Save manasi.s...@artificialmachines.comTo: "mysql@lists.mysql.com" mysql@lists.mysql.comSent: Sat, September 4, 2010 12:06:27 PMSubject: mysqldump error 1064 for database Use commandHi All,I have 10 mysql databases all the tables use MyIsAm mysql storage engine.Database names are 1,2,3,4,...10.When I use mysqldump command with --all-databases option. This gives me following error:mysqldump -u myuser -p --all-databases AllNew_Databases_20100904.sqlERROR MESSAGE :-mysqldump: Couldn't execute 'use 1': You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1' at line 1 (1064)Can anyone provide any input on this. I have never got this error before. The backups uptill now was happening properly. Please let me know if I am missing out any information which should be provided to get more clear idea about this error.Any input will be a great help.Thanks in advance.--Regards,Manasi Save
mysqldump error 1064 for database Use command
Hi All, I have 10 mysql databases all the tables use MyIsAm mysql storage engine. Database names are 1,2,3,4,...10. When I use mysqldump command with --all-databases option. This gives me following error: mysqldump -u myuser -p --all-databases AllNew_Databases_20100904.sql ERROR MESSAGE :- mysqldump: Couldn't execute 'use 1': You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1' at line 1 (1064) Can anyone provide any input on this. I have never got this error before. The backups uptill now was happening properly. Please let me know if I am missing out any information which should be provided to get more clear idea about this error. Any input will be a great help. Thanks in advance. -- Regards, Manasi Save
Re: mysqldump error 1064 for database Use command
Hi, Have you recently upgraded your MySQL installation? 1064 in earlier days used to mean use of reserved word. Few clients have reported this error in last couple of months after they upgraded from 5.1.41 to higher versions. As of now, I don't have a solution other than changing the name (of database in your case). Hope that helps. Regards, Nitin From: Manasi Save manasi.s...@artificialmachines.com To: mysql@lists.mysql.com mysql@lists.mysql.com Sent: Sat, September 4, 2010 12:06:27 PM Subject: mysqldump error 1064 for database Use command Hi All, I have 10 mysql databases all the tables use MyIsAm mysql storage engine. Database names are 1,2,3,4,...10. When I use mysqldump command with --all-databases option. This gives me following error: mysqldump -u myuser -p --all-databases AllNew_Databases_20100904.sql ERROR MESSAGE :- mysqldump: Couldn't execute 'use 1': You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1' at line 1 (1064) Can anyone provide any input on this. I have never got this error before. The backups uptill now was happening properly. Please let me know if I am missing out any information which should be provided to get more clear idea about this error. Any input will be a great help. Thanks in advance. -- Regards, Manasi Save
MYSQLDUMP ERROR
Hi lists, I have given select privileges to database tables. when i am taking mysqldump remotely it's giving error. [prajap...@beta2 prajapati]$ mysqldump --verbose -h 152.20.1.115 -u dip dip states -pdip state.sql -- Connecting to 152.20.1.115... mysqldump: Got error: 1044: Access denied for user 'dip'@'152.20.1.%' to database 'dip' when doing LOCK TABLES Thanks, Krishna Chandra Prajapati
Re: MYSQLDUMP ERROR
MySQL dump calls LOCK TABLES before dumping the data (presumably to prevent data modification halfway through the process). LOCK TABLES has its own privilege (conveniently given the same name) which your user account will have to be given in order to run a mysqldump. On Fri, 2009-05-01 at 15:49 +0530, Krishna Chandra Prajapati wrote: Hi lists, I have given select privileges to database tables. when i am taking mysqldump remotely it's giving error. [prajap...@beta2 prajapati]$ mysqldump --verbose -h 152.20.1.115 -u dip dip states -pdip state.sql -- Connecting to 152.20.1.115... mysqldump: Got error: 1044: Access denied for user 'dip'@'152.20.1.%' to database 'dip' when doing LOCK TABLES Thanks, Krishna Chandra Prajapati -- Ian Simpson System Administrator MyJobGroup -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
mysqldump error
Just recently a script that backups up
? Solved ? Re: mysqldump: Error 2 013: Lost connection to MySQL server
On Tue, 2009-01-13 at 12:19 +0530, Chandru wrote: Hi, Did u try using this command mysqldump --opt db_name db_name.sql -p 2bkp.err Not quite. Firstly, I had to alter the normal backup cron job, and that doesn't happen until late at night. Secondly, yes I added the redirection to capture errors. There were none ( empty file this time ). Thirdly, I didn't use '--opt'. I had no other suggestions yesterday ( before I went to bed anyway - there's 1 in my inbox this morning ), so I did some experimenting of my own and changed the dump command to: mysqldump --skip-opt --add-drop-table --add-locks --create-options --quick --lock-tables --set-charset --disable-keys dbmail dbmail.sql -pSOME_PASSWORD 2bkp.err This made mysql do 1 insert per record. The backup *appears* to have completed successfully. At least the end of the dump file looks valid. It ends dumping the last table, then a view, then I get: -- Dump completed on 2009-01-13 17:23:13 Previously it just finished part-way through dumping a blob. I have yet to do extensive testing on it. I suppose I should try importing the dump file into another server and see if I get the correct number of rows in each table ... The only issue now is that the dump file is much smaller than I would have expected. When using --opt, I was getting 30GB dump files. I would have expected the current format ( 1 insert statement per record ) to be much bigger, but it's 23GB. Now having said that, I did email the current DB administrator and ask him to get people to archive all emails with huge attachments somewhere on a network share ( people have some pretty big attachments ). Also I asked him to get people to clean out their Trash ( which happens only when we tell them to ). So I suppose it's not completely infeasible that this alone is responsible for the difference. Anyway, it's been a very disconcerting experience. It goes without saying that people would expect that anything that gets into a MySQL database should be able to be backed up by mysqldump. And it's worrying that the default --opt can't do that. When I get some time I'll enter a bug ... Thanks for you help Chandru. Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: ? Solved ? Re: mysqldump: Error 2013: Lost connection to MySQL server
This sounds like you need to raise max_allowed_packet for mysqldump (and possibly mysqld) - these are separate settings for both the client and the server. You can do this via the my.cnf (or ~/.my.cnf) or specify it as an option on the command line mysqldump --opt ... --max_allowed_packet=1G dbname backup-file. On Tue, Jan 13, 2009 at 2:58 PM, Dan d...@entropy.homelinux.org wrote: On Tue, 2009-01-13 at 12:19 +0530, Chandru wrote: Hi, Did u try using this command mysqldump --opt db_name db_name.sql -p 2bkp.err Not quite. Firstly, I had to alter the normal backup cron job, and that doesn't happen until late at night. Secondly, yes I added the redirection to capture errors. There were none ( empty file this time ). Thirdly, I didn't use '--opt'. I had no other suggestions yesterday ( before I went to bed anyway - there's 1 in my inbox this morning ), so I did some experimenting of my own and changed the dump command to: mysqldump --skip-opt --add-drop-table --add-locks --create-options --quick --lock-tables --set-charset --disable-keys dbmail dbmail.sql -pSOME_PASSWORD 2bkp.err This made mysql do 1 insert per record. The backup *appears* to have completed successfully. At least the end of the dump file looks valid. It ends dumping the last table, then a view, then I get: -- Dump completed on 2009-01-13 17:23:13 Previously it just finished part-way through dumping a blob. I have yet to do extensive testing on it. I suppose I should try importing the dump file into another server and see if I get the correct number of rows in each table ... The only issue now is that the dump file is much smaller than I would have expected. When using --opt, I was getting 30GB dump files. I would have expected the current format ( 1 insert statement per record ) to be much bigger, but it's 23GB. Now having said that, I did email the current DB administrator and ask him to get people to archive all emails with huge attachments somewhere on a network share ( people have some pretty big attachments ). Also I asked him to get people to clean out their Trash ( which happens only when we tell them to ). So I suppose it's not completely infeasible that this alone is responsible for the difference. Anyway, it's been a very disconcerting experience. It goes without saying that people would expect that anything that gets into a MySQL database should be able to be backed up by mysqldump. And it's worrying that the default --opt can't do that. When I get some time I'll enter a bug ... Thanks for you help Chandru. Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=andrew.b.gar...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: ? Solved ? Re: mysqldump: Error 2013: Lost connection to MySQL server
On Tue, 13 Jan 2009 18:34:44 -0600, Andrew Garner andrew.b.gar...@gmail.com wrote: This sounds like you need to raise max_allowed_packet for mysqldump (and possibly mysqld) - these are separate settings for both the client and the server. You can do this via the my.cnf (or ~/.my.cnf) or specify it as an option on the command line mysqldump --opt ... --max_allowed_packet=1G dbname backup-file. This is certainly the most common advice for this error, yes. I increased the max_allowed_packet size from 1M to 128M when the problem initially occured. This didn't fix anything. Since dbmail splits up all email body / attachments into small chunks and inserts these chunks in separate records, I really don't see how a max_allowed_packet size of 128M would fail ... especially since the data got in there with a max_allowed_packet size of 1M to begin with. The biggest email in the database is 50M. So even if dbmail *hadn't* split the email into separate records, a max_allowed_packet size of 128M should be *easily* big enough, shouldn't it? As for a max_allowed_packet size of 1G, that just sounds dangerous. The server has 900MB or so of chip RAM and 512MB of swap. It's also running a LOT of other services. I don't want something stupid happening like Linux's out-of-memory-killer coming along and killing MySQL, causing database corruption. Can someone please comment on this? If it's not dangerous, I will try it. As noted in a prior post, I 'successfully' completed a backup last night, and I'm testing it now, but it took 10 hours to complete, and was still running when people came in this morning, which is obviously not desirable, so if I can somehow still use the --opt option of mysqldump by making max_allowed_packet to some absolutely astronomical level without endangering things, maybe that's the way to go. Maybe ... Anyway, thanks for the comments Andrew. Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: ? Solved ? Re: mysqldump: Error 2013: Lost connection to MySQL server
On Tue, Jan 13, 2009 at 6:06 PM, Dan d...@entropy.homelinux.org wrote: On Tue, 13 Jan 2009 18:34:44 -0600, Andrew Garner andrew.b.gar...@gmail.com wrote: This sounds like you need to raise max_allowed_packet for mysqldump (and possibly mysqld) - these are separate settings for both the client and the server. You can do this via the my.cnf (or ~/.my.cnf) or specify it as an option on the command line mysqldump --opt ... --max_allowed_packet=1G dbname backup-file. This is certainly the most common advice for this error, yes. I increased the max_allowed_packet size from 1M to 128M when the problem initially occured. This didn't fix anything. My apologies. I hadn't read up-thread where this was discussed, and given that, max_allowed_packet is almost certainly not the problem. Sorry for the noise. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
mysqldump: Error 2013: Lost connection to MySQL server
Hi all. I have a 30GB innodb-only database in mysql-5.0.54. I have always done nightly backups with: mysqldump --opt db_name db_name.sql -p Recently this started failing with: Error 2013: Lost connection to MySQL server I have checked all tables for corruption - nothing found. Also as far as I can tell there are no issues with clients using the database. There have been no crashes since I did a full restore. So I assume we can rule out corruption. I have searched around for the error message, and found people discussing the max_allowed_packet option. I've tried increasing the server's max_allowed_packet to many different values. Currently it's at 128M, which is *way* over the default. I have also used the --max_allowed_packet option simultaneously with mysqldump. And lastly, I have been restarting the server after each my.cnf change. The data was inserted via the 'dbmail' application ( http://www.dbmail.org ), while the server was set up with the default max_allowed_packet size. DBMail breaks up message into chunks, and stores these chunks in individual records. I'm not sure what the default size of these chunks is, but I belive it's a reasonable value anyway. What next? I *must* get regular backups working again ... Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysqldump: Error 2013: Lost connection to MySQL server
Hi, please increase your interactive_timeout variable to some big number and also try to log the erros if any thing by using the command: mysqldump --opt db_name db_name.sql -p 2bkp.err check if you get some thing in the bkp.err file. Regards, Chandru, www.mafiree.com On Mon, Jan 12, 2009 at 9:07 AM, Daniel Kasak d...@entropy.homelinux.orgwrote: Hi all. I have a 30GB innodb-only database in mysql-5.0.54. I have always done nightly backups with: mysqldump --opt db_name db_name.sql -p Recently this started failing with: Error 2013: Lost connection to MySQL server I have checked all tables for corruption - nothing found. Also as far as I can tell there are no issues with clients using the database. There have been no crashes since I did a full restore. So I assume we can rule out corruption. I have searched around for the error message, and found people discussing the max_allowed_packet option. I've tried increasing the server's max_allowed_packet to many different values. Currently it's at 128M, which is *way* over the default. I have also used the --max_allowed_packet option simultaneously with mysqldump. And lastly, I have been restarting the server after each my.cnf change. The data was inserted via the 'dbmail' application ( http://www.dbmail.org ), while the server was set up with the default max_allowed_packet size. DBMail breaks up message into chunks, and stores these chunks in individual records. I'm not sure what the default size of these chunks is, but I belive it's a reasonable value anyway. What next? I *must* get regular backups working again ... Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=chandru@gmail.com
Re: mysqldump: Error 2013: Lost connection to MySQL server
On Mon, 12 Jan 2009 16:25:12 +0530, Chandru chandru@gmail.com wrote: Hi, please increase your interactive_timeout variable to some big number and also try to log the erros if any thing by using the command: mysqldump --opt db_name db_name.sql -p 2bkp.err check if you get some thing in the bkp.err file. Thanks for responding :) Unfortunately I don't think this is the problem for us. This value is already at 28800 seconds ( equals 8 hours ). The backup certainly never used to take that long. The mysql portion of the backup used to take about 90 minutes. I will retry with your suggestion anyway tonight and post back if something new happens. Here are our server variables which I should have posted the 1st time ( minus version_bdb as it will cause horrible text wrapping ): mysql show variables - where Variable_name != 'version_bdb'; +-+-+ | Variable_name | Value | +-+-+ | auto_increment_increment| 1 | | auto_increment_offset | 1 | | automatic_sp_privileges | ON | | back_log| 50 | | basedir | /usr/ | | bdb_cache_size | 8384512 | | bdb_home| | | bdb_log_buffer_size | 262144 | | bdb_logdir | | | bdb_max_lock| 1 | | bdb_shared_data | OFF | | bdb_tmpdir | | | binlog_cache_size | 32768 | | bulk_insert_buffer_size | 8388608 | | character_set_client| latin1 | | character_set_connection| latin1 | | character_set_database | latin1 | | character_set_filesystem| binary | | character_set_results | latin1 | | character_set_server| latin1 | | character_set_system| utf8| | character_sets_dir | /usr/share/mysql/charsets/ | | collation_connection| latin1_swedish_ci | | collation_database | latin1_swedish_ci | | collation_server| latin1_swedish_ci | | completion_type | 0 | | concurrent_insert | 1 | | connect_timeout | 10 | | datadir | /mnt/stuff/mysql/ | | date_format | %Y-%m-%d| | datetime_format | %Y-%m-%d %H:%i:%s | | default_week_format | 0 | | delay_key_write | ON | | delayed_insert_limit| 100 | | delayed_insert_timeout | 300 | | delayed_queue_size | 1000| | div_precision_increment | 4 | | keep_files_on_create| OFF | | engine_condition_pushdown | OFF | | expire_logs_days| 0 | | flush | OFF | | flush_time | 0 | | ft_boolean_syntax | + -()~*:| | | ft_max_word_len | 84 | | ft_min_word_len | 4 | | ft_query_expansion_limit| 20 | | ft_stopword_file| (built-in) | | group_concat_max_len| 1024| | have_archive| NO | | have_bdb| DISABLED| | have_blackhole_engine | NO | | have_compress | YES | | have_crypt | YES | | have_csv| NO | | have_dynamic_loading| YES | | have_example_engine | NO | | have_federated_engine | NO | | have_geometry | YES | | have_innodb | YES
Re: mysqldump: Error 2013: Lost connection to MySQL server
I'm also having a similar issue with some tables I've been trying to dump (total data set is around 3TB). I'm dumping directly from one host to another (mysqldump -hSOURCE DATABASE | mysql -hLOCALHOST DATABASE) using mysql 4.1.22. One system is Solaris 10 SPARC, while the other is Solaris 10 x64 (64bit MySQL as well). I wrote a script that starts a mysqldump process for each table within a database, which shouldn't be a problem since the host currently has around 12G unused memory. Midway through the dump I seem to lose the connection as Dan described. After attempting to drop/re-import (using a single process), the larger tables continue to fail (though at different points) while some of the small-medium sized tables made it across. Anyone else run into this before? Ideas? Thanks, -Aaron
Re: mysqldump: Error 5: Out of memory
Show the details of your hardware us. On Thu, Oct 2, 2008 at 3:02 PM, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote: Hi, Just try the below command on console. It will give that the error is exactly related to what. $perror 5 What is total ram in your box. On Thu, Oct 2, 2008 at 12:26 PM, Uma Bhat [EMAIL PROTECTED] wrote: Hey Guys! I have been googling a lot on this error and read various suggestions. But havnt found an appropriate solution yet. I get this error while taking mysqldump of an InnoDB table (say mytable) mysqldump: Error 5: *Out of memory (Needed 632894352 bytes) when dumping table `mytable` at row: 484911* *current my.cnf settings:* innodb_buffer_pool_size = 256M innodb_additional_mem_pool_size = 32M max_allowed_packet = 1024M -q with mysqldump option did not help. it resulted in same error. Appreciate your quick response ! Much Thanks, Uma -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 53 Office Number: 040-66489771 Mob: 9912924044 URL: ed-ventures-online.com Email-id: [EMAIL PROTECTED] -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
mysqldump: Error 5: Out of memory
Hey Guys! I have been googling a lot on this error and read various suggestions. But havnt found an appropriate solution yet. I get this error while taking mysqldump of an InnoDB table (say mytable) mysqldump: Error 5: *Out of memory (Needed 632894352 bytes) when dumping table `mytable` at row: 484911* *current my.cnf settings:* innodb_buffer_pool_size = 256M innodb_additional_mem_pool_size = 32M max_allowed_packet = 1024M -q with mysqldump option did not help. it resulted in same error. Appreciate your quick response ! Much Thanks, Uma
Re: mysqldump: Error 5: Out of memory
Hi, Just try the below command on console. It will give that the error is exactly related to what. $perror 5 What is total ram in your box. On Thu, Oct 2, 2008 at 12:26 PM, Uma Bhat [EMAIL PROTECTED] wrote: Hey Guys! I have been googling a lot on this error and read various suggestions. But havnt found an appropriate solution yet. I get this error while taking mysqldump of an InnoDB table (say mytable) mysqldump: Error 5: *Out of memory (Needed 632894352 bytes) when dumping table `mytable` at row: 484911* *current my.cnf settings:* innodb_buffer_pool_size = 256M innodb_additional_mem_pool_size = 32M max_allowed_packet = 1024M -q with mysqldump option did not help. it resulted in same error. Appreciate your quick response ! Much Thanks, Uma -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 53 Office Number: 040-66489771 Mob: 9912924044 URL: ed-ventures-online.com Email-id: [EMAIL PROTECTED]
mysqldump error
Hi ALL I am getting the below error [EMAIL PROTECTED] drupal]# mysqldump --tab=/usr/local/drupal/drupalbckup/ --opt drupal mysqldump: Got error: 1: Can't create/write to file '/usr/local/drupal/drupalbckup/access.txt' (Errcode: 13) when executing 'SELECT INTO OUTFILE' Thanks and Regards Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqldump error
I am getting the below error [EMAIL PROTECTED] drupal]# mysqldump --tab=/usr/local/drupal/drupalbckup/ --opt drupal mysqldump: Got error: 1: Can't create/write to file '/usr/local/drupal/drupalbckup/access.txt' (Errcode: 13) when executing 'SELECT INTO OUTFILE' Change the owner of that directory so the mysql server can write into it. Regards Dominik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqldump error
[EMAIL PROTECTED] drupal]# mysqldump --tab=/usr/local/drupal/drupalbckup/ --opt drupal mysqldump: Got error: 1: Can't create/write to file '/usr/local/drupal/drupalbckup/access.txt' (Errcode: 13) when executing 'SELECT INTO OUTFILE' Change the owner of that directory so the mysql server can write into it. Regards Dominik Thanks it did worked but i want it to dump on a single file for example backup.sql, as i could see lot of file Please write to the list next time. If you want a single file use mysqldump [your options] [your database] backup.sql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysqldump: Error 2013
Hello everyone! I just wanted to give everyone an update. I'm still getting this error when I try to back up this database table. I don't get it at the same row each time - today was at row 1,618, yesterday it was at row 24,566. Just a reminder of my symptoms: 1. mysqldump is the only thing reporting any errors 2. the database server itself is not crashing 3. the timeouts on the database server are all set to 86,400 seconds 4. there is plenty of disk space on both the database server and the backup media 5. the max_packet_size is 100MB 6. the maximum row size is less than 50MB I have run the backup by hand a few times (not as part of a cron job, but rather from my session instead) and it does complete (after about 4-5 hours). That would be fine, except that the backup slows the entire system down, so I can't run it during the day - that's why it's usually part of a cron job that runs at 1AM UTC. Can anyone offer some suggestions as to what's causing this, and what I might be able to do to fix it? Is there any way to maybe split the backups into 3 or 4 pieces so that no one .sql file is so big and no one run against the database is so long? Thanks in advance! Tim Gustafson MEI Technology Consulting, Inc [EMAIL PROTECTED] (516) 379-0001 Office (516) 908-4185 Fax http://www.meitech.com/ smime.p7s Description: S/MIME cryptographic signature
RE: mysqldump: Error 2013
Have a look here: http://dev.mysql.com/doc/mysql/en/gone-away.html Gleb, Thanks for the response. The only one that seems to apply is this one: You may also see the MySQL server has gone away error if MySQL is started with the --skip-networking option. I do start mySQL without networking enabled - it's only accessible from the local machine (for security reasons). I can tell you for certain that the mySQL server is definitely not crashing itself - it chugs along happily without incident. Interestingly, I ran the backup command from my shell yesterday during the day (when the server is actually much more active) and the backup completed successfully. That one table took about 5 hours to back up though - I'm not sure if that is normal or not. Then last night's automated (unattended) backup completed successfully for the first time in a few days. Tim Gustafson MEI Technology Consulting, Inc [EMAIL PROTECTED] (516) 379-0001 Office (516) 908-4185 Fax http://www.meitech.com/ smime.p7s Description: S/MIME cryptographic signature
mysqldump: Error 2013
Hello I am using mysqldump to backup my entire database (about 40GB total) each night. I dump each table separetly, so that if mysqldump crashes in the middle somewhere, the rest of the database still gets backed up. Most of the tables are fairly small. About 20GB of the database is spread across more than a hundred tables. However, one table is very large - it accounts for the other 20GB of the dataset. When backing up this table, I get this error message every night: /usr/local/bin/mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `DocumentVariants` at row: 13456 The table actually has 94,916 rows in it. There are no entries in the mySQL server log and nothing in /var/log/messages. There is plenty of disk space available on the backup drive. The file is about 4.5GB when this happens, which is about 1/5 of the total table size. The table itself contains a lot of binary data in a longblob field, in case that makes any difference. wait_timeout on my server is set to 86400, and the whole backup takes less than an hour, so the timeout is not the problem. Has anyone else had similar problems? Can anyone shed some light on how to successfully back up this database? Thanks! Tim Gustafson MEI Technology Consulting, Inc [EMAIL PROTECTED] (516) 379-0001 Office (516) 908-4185 Fax http://www.meitech.com/ smime.p7s Description: S/MIME cryptographic signature
Re: mysqldump: Error 2013
Gustafson, Tim [EMAIL PROTECTED] wrote on 08/29/2005 09:24:36 AM: Hello I am using mysqldump to backup my entire database (about 40GB total) each night. I dump each table separetly, so that if mysqldump crashes in the middle somewhere, the rest of the database still gets backed up. Most of the tables are fairly small. About 20GB of the database is spread across more than a hundred tables. However, one table is very large - it accounts for the other 20GB of the dataset. When backing up this table, I get this error message every night: /usr/local/bin/mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `DocumentVariants` at row: 13456 The table actually has 94,916 rows in it. There are no entries in the mySQL server log and nothing in /var/log/messages. There is plenty of disk space available on the backup drive. The file is about 4.5GB when this happens, which is about 1/5 of the total table size. The table itself contains a lot of binary data in a longblob field, in case that makes any difference. wait_timeout on my server is set to 86400, and the whole backup takes less than an hour, so the timeout is not the problem. Has anyone else had similar problems? Can anyone shed some light on how to successfully back up this database? Thanks! Tim Gustafson MEI Technology Consulting, Inc [EMAIL PROTECTED] (516) 379-0001 Office (516) 908-4185 Fax http://www.meitech.com/ The one thing I can think of is to check that you are not trying to buffer your output. Use the quick option when you start mysqldump (to skip memory buffering the dump file) and write the data straight to disk as it arrives. With a 20GB file it will be very easy to exceed available system memory allocation limits. With the buffering turned off, you shouldn't hit that limit. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
RE: mysqldump: Error 2013
Shawn, Thanks. I should have included the switches I was using to make the backup. I'm using --opt --quote-names, and according to the manual, --opt includes --quick. Tim Gustafson MEI Technology Consulting, Inc [EMAIL PROTECTED] (516) 379-0001 Office (516) 908-4185 Fax http://www.meitech.com/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, August 29, 2005 9:35 AM To: Gustafson, Tim Cc: mysql@lists.mysql.com Subject: Re: mysqldump: Error 2013 Gustafson, Tim [EMAIL PROTECTED] wrote on 08/29/2005 09:24:36 AM: Hello I am using mysqldump to backup my entire database (about 40GB total) each night. I dump each table separetly, so that if mysqldump crashes in the middle somewhere, the rest of the database still gets backed up. Most of the tables are fairly small. About 20GB of the database is spread across more than a hundred tables. However, one table is very large - it accounts for the other 20GB of the dataset. When backing up this table, I get this error message every night: /usr/local/bin/mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `DocumentVariants` at row: 13456 The table actually has 94,916 rows in it. There are no entries in the mySQL server log and nothing in /var/log/messages. There is plenty of disk space available on the backup drive. The file is about 4.5GB when this happens, which is about 1/5 of the total table size. The table itself contains a lot of binary data in a longblob field, in case that makes any difference. wait_timeout on my server is set to 86400, and the whole backup takes less than an hour, so the timeout is not the problem. Has anyone else had similar problems? Can anyone shed some light on how to successfully back up this database? Thanks! Tim Gustafson MEI Technology Consulting, Inc [EMAIL PROTECTED] (516) 379-0001 Office (516) 908-4185 Fax http://www.meitech.com/ The one thing I can think of is to check that you are not trying to buffer your output. Use the quick option when you start mysqldump (to skip memory buffering the dump file) and write the data straight to disk as it arrives. With a 20GB file it will be very easy to exceed available system memory allocation limits. With the buffering turned off, you shouldn't hit that limit. Shawn Green Database Administrator Unimin Corporation - Spruce Pine smime.p7s Description: S/MIME cryptographic signature
Re: mysqldump: Error 2013
Gustafson, Tim wrote: When backing up this table, I get this error message every night: /usr/local/bin/mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `DocumentVariants` at row: 13456 The table actually has 94,916 rows in it. There are no entries in the mySQL server log and nothing in /var/log/messages. There is plenty of disk space available on the backup drive. The file is about 4.5GB when this happens, which is about 1/5 of the total table size. The table itself contains a lot of binary data in a longblob field, in case that makes any difference. Does the size of the contents of that field exceed your defined max_allowed_packet size? -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysqldump: Error 2013
No, max_allowed_packet is 100 megabytes, and the maximum data field in the database is 50MB right now, and most are well below 10MB. Tim Gustafson MEI Technology Consulting, Inc [EMAIL PROTECTED] (516) 379-0001 Office (516) 908-4185 Fax http://www.meitech.com/ -Original Message- From: Hassan Schroeder [mailto:[EMAIL PROTECTED] Sent: Monday, August 29, 2005 9:51 AM To: mysql@lists.mysql.com Subject: Re: mysqldump: Error 2013 Gustafson, Tim wrote: When backing up this table, I get this error message every night: /usr/local/bin/mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `DocumentVariants` at row: 13456 The table actually has 94,916 rows in it. There are no entries in the mySQL server log and nothing in /var/log/messages. There is plenty of disk space available on the backup drive. The file is about 4.5GB when this happens, which is about 1/5 of the total table size. The table itself contains a lot of binary data in a longblob field, in case that makes any difference. Does the size of the contents of that field exceed your defined max_allowed_packet size? -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] smime.p7s Description: S/MIME cryptographic signature
Re: mysqldump: Error 2013
Gustafson, Tim wrote: No, max_allowed_packet is 100 megabytes, and the maximum data field in the database is 50MB right now, and most are well below 10MB. mmm. OK, not having any more bright ideas :-) I would try dumping it using an explicit `--where=` claus to guarantee fixed ordering, and see if it fails on the same row every time. HTH! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqldump: Error 2013
Hello. Has anyone else had similar problems? Can anyone shed some light on how to successfully back up this database? Have a look here: http://dev.mysql.com/doc/mysql/en/gone-away.html Hello I am using mysqldump to backup my entire database (about 40GB total) each night. I dump each table separetly, so that if mysqldump crashes in the middle somewhere, the rest of the database still gets backed up. Most of the tables are fairly small. About 20GB of the database is spread across more than a hundred tables. However, one table is very large - it accounts for the other 20GB of the dataset. When backing up this table, I get this error message every night: /usr/local/bin/mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `DocumentVariants` at row: 13456 The table actually has 94,916 rows in it. There are no entries in the mySQL server log and nothing in /var/log/messages. There is plenty of disk space available on the backup drive. The file is about 4.5GB when this happens, which is about 1/5 of the total table size. The table itself contains a lot of binary data in a longblob field, in case that makes any difference. wait_timeout on my server is set to 86400, and the whole backup takes less than an hour, so the timeout is not the problem. Has anyone else had similar problems? Can anyone shed some light on how to successfully back up this database? Thanks! Gustafson, Tim [EMAIL PROTECTED] wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqldump: Error 2013
Hassan Schroeder wrote: Does the size of the contents of that field exceed your defined max_allowed_packet size? Gustafson, Tim wrote: No, max_allowed_packet is 100 megabytes, and the maximum data field in the database is 50MB right now, and most are well below 10MB. Tim Gustafson MEI Technology Consulting, Inc [EMAIL PROTECTED] (516) 379-0001 Office (516) 908-4185 Fax http://www.meitech.com/ I believe it's the size of the row, not the size of a single field, that matters. Is it possible you have a row which exceeds max_allowed_packet size? Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysqldump: Error 2013
I believe it's the size of the row, not the size of a single field, that matters. Is it possible you have a row which exceeds max_allowed_packet size? No. There is one blob fields (always less than 50MB) and like 10 other fields, all integers. smime.p7s Description: S/MIME cryptographic signature
Re: Mysqldump error 1017: errno: 24 - help?
Hello. Try '--open-files-limit=8192' at least. Check the real value of open_file_limits with such statement: show variables like '%open_f%'; You can find some recommendations for SuSe Linux at: http://dev.mysql.com/doc/mysql/en/Linux-post-install.html Mysql user [EMAIL PROTECTED] wrote: Hi.. I've got an ISP, and all of our customers have databases in our mysql system. My backup command is: mysqldump --force --opt -A -p' | gzip -c /var/sqlbackup/mysqldump-`date +\%A`.sql.gz This has worked fine for some time. Now, however, I get an error message: mysqldump: Got error: 1017: Can't find file: './usr_web22_1/invoices_va.frm' (errno: 24) when using LOCK TABLES On different runs, it reports different files, even right after restarting mysqld. I've looked at the mysql documentation for this error; it's at http://dev.mysql.com/doc/mysql/en/Not_enough_file_handles.html I've looked at the startup script, put in '--open-files-limit=1024', restarted mysql, and the error is the same. I've looked at the table_cache and max_connections system variables, which are 64 and 100, respectively. My question is: what should I do now? Since table_cache and max_connections are far less than 1024, do I reduce them even further? Is there something else I should be looking at? This is mysql-3.23.52-106 on SuSE Linux 8.1, running on a dual PIII 866Mhz system, with 512M of ram and 1G of swap, on a RAID-1 pair of 17G hard drives. Thanks! -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysqldump error 1017: errno: 24 - help?
Yep, that seems to have done it, at least when I'm testing it. I'm pretty sure the problem is fixed, but the next couple of days of automated backups will tell. Thanks! On Tue, 2005-01-11 at 00:43, Gleb Paharenko wrote: Hello. Try '--open-files-limit=8192' at least. Check the real value of open_file_limits with such statement: show variables like '%open_f%'; You can find some recommendations for SuSe Linux at: http://dev.mysql.com/doc/mysql/en/Linux-post-install.html Mysql user [EMAIL PROTECTED] wrote: Hi.. I've got an ISP, and all of our customers have databases in our mysql system. My backup command is: mysqldump --force --opt -A -p' | gzip -c /var/sqlbackup/mysqldump-`date +\%A`.sql.gz This has worked fine for some time. Now, however, I get an error message: mysqldump: Got error: 1017: Can't find file: './usr_web22_1/invoices_va.frm' (errno: 24) when using LOCK TABLES On different runs, it reports different files, even right after restarting mysqld. I've looked at the mysql documentation for this error; it's at http://dev.mysql.com/doc/mysql/en/Not_enough_file_handles.html I've looked at the startup script, put in '--open-files-limit=1024', restarted mysql, and the error is the same. I've looked at the table_cache and max_connections system variables, which are 64 and 100, respectively. My question is: what should I do now? Since table_cache and max_connections are far less than 1024, do I reduce them even further? Is there something else I should be looking at? This is mysql-3.23.52-106 on SuSE Linux 8.1, running on a dual PIII 866Mhz system, with 512M of ram and 1G of swap, on a RAID-1 pair of 17G hard drives. Thanks! -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- Mysql user [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysqldump error 1017: errno: 24 - help?
Hi.. I've got an ISP, and all of our customers have databases in our mysql system. My backup command is: mysqldump --force --opt -A -p' | gzip -c /var/sqlbackup/mysqldump-`date +\%A`.sql.gz This has worked fine for some time. Now, however, I get an error message: mysqldump: Got error: 1017: Can't find file: './usr_web22_1/invoices_va.frm' (errno: 24) when using LOCK TABLES On different runs, it reports different files, even right after restarting mysqld. I've looked at the mysql documentation for this error; it's at http://dev.mysql.com/doc/mysql/en/Not_enough_file_handles.html I've looked at the startup script, put in '--open-files-limit=1024', restarted mysql, and the error is the same. I've looked at the table_cache and max_connections system variables, which are 64 and 100, respectively. My question is: what should I do now? Since table_cache and max_connections are far less than 1024, do I reduce them even further? Is there something else I should be looking at? This is mysql-3.23.52-106 on SuSE Linux 8.1, running on a dual PIII 866Mhz system, with 512M of ram and 1G of swap, on a RAID-1 pair of 17G hard drives. Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqldump error
Running MySQL 4.0.12-NT on a Windows 2k Pro Server. When I attempt to execute mysqldump.exe, I get the following error: mysqldump: ERROR: unknown variable 'local-infile=1' I tried using --force and it didn't help. Showing the variables, I get local-infile to be TRUE. I looked in my.ini and found 3 instances of local-infile=1, for [mysqld], [mysql], and [client]. I thought perhaps if I put spaces around the = sign, that may help, but after editing the file, stopping and starting the service, the same error. This mysql server has been running for well over a year with no problems, but I've never had to do a dump before. Any suggestions welcome. -Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqldump error
At 15:47 -0400 10/27/04, Michael Ragsdale wrote: Running MySQL 4.0.12-NT on a Windows 2k Pro Server. When I attempt to execute mysqldump.exe, I get the following error: mysqldump: ERROR: unknown variable 'local-infile=1' I tried using --force and it didn't help. Showing the variables, I get local-infile to be TRUE. I looked in my.ini and found 3 instances of local-infile=1, for [mysqld], [mysql], and [client]. I Remove it from [client]. thought perhaps if I put spaces around the = sign, that may help, but after editing the file, stopping and starting the service, the same error. This mysql server has been running for well over a year with no problems, but I've never had to do a dump before. Any suggestions welcome. -Mike -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqldump error
Hi. See http://dev.mysql.com/doc/mysql/en/LOAD_DATA_LOCAL.html and upgrade to the latest stable release. Michael Ragsdale [EMAIL PROTECTED] wrote: Running MySQL 4.0.12-NT on a Windows 2k Pro Server. When I attempt to execute mysqldump.exe, I get the following error: mysqldump: ERROR: unknown variable 'local-infile=1' I tried using --force and it didn't help. Showing the variables, I get local-infile to be TRUE. I looked in my.ini and found 3 instances of local-infile=1, for [mysqld], [mysql], and [client]. I thought perhaps if I put spaces around the = sign, that may help, but after editing the file, stopping and starting the service, the same error. This mysql server has been running for well over a year with no problems, but I've never had to do a dump before. Any suggestions welcome. -Mike -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqldump: Error 2013
Hello - Since recently switching from MyISAM to InnoDB tables in 4.1 on RH Linux I receive this error when attempting to dump some tables. mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `campaigns` at row: 14721 Any idea what could be causing this? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqldump error
hi all, I'm a newbie to mysql. have os10.3.2 running mysql v4.0.17 am trying to dump a database called 'mtweblog' into a sql file called 'BckUpmtweblog.sql'. when i do 'mysqldump mtweblog BckUpmtweblog.sql' from CLI it gives Error: 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) when trying to connect. when i log into mysql and do 'mysqldump --opt mtweblog BckUpmtweblog.sql;' it gives Error: 1064: You have an error in your SQL syntax. can anyone help me to dump this databse? ta tait tait sanders computer technician sir robert webster bldg trc unsw 02 9385 6802 0415 556 303 [EMAIL PROTECTED]
RE: mysqldump error
First, mysqldump is a command in and of itself so it does NOT execute from within the mysql command line tool. Next, expand your command entry a bit to include your userid and password, for example: mysqldump -uuserid -ppassword --add-drop-table mtweblog BckUpmtweblog.sql -Original Message- From: tait sanders [mailto:[EMAIL PROTECTED] Sent: Sunday, March 21, 2004 4:50 PM To: mysql Subject: mysqldump error hi all, I'm a newbie to mysql. have os10.3.2 running mysql v4.0.17 am trying to dump a database called 'mtweblog' into a sql file called 'BckUpmtweblog.sql'. when i do 'mysqldump mtweblog BckUpmtweblog.sql' from CLI it gives Error: 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) when trying to connect. when i log into mysql and do 'mysqldump --opt mtweblog BckUpmtweblog.sql;' it gives Error: 1064: You have an error in your SQL syntax. can anyone help me to dump this databse? ta tait tait sanders computer technician sir robert webster bldg trc unsw 02 9385 6802 0415 556 303 [EMAIL PROTECTED]
RE: mysqldump error
Errorcode 13 indicates that there is a permissions error of some sort. I'd double check that the mysql user/group own the data directories on the new machine. I've also found that setting up the new database on the new server helps before loading data to it. For example: mysqldump -uuser -ppassword --no-data mtweblog mtweblog.ddl mysql -uuser -ppassword mtweblog.ddl mysql -uuser -ppassword bkupmtweblog.sql -Original Message- From: tait sanders [mailto:[EMAIL PROTECTED] Sent: Sunday, March 21, 2004 5:13 PM To: [EMAIL PROTECTED] Cc: mysql Subject: Re: mysqldump error thanks - i ran the command below and it worked. and now I'm trying to import using: 'mysql -u root -p mtweblog Bckupmtweblog.sql' on CLI on different machine and am getting Error 1 at line 11: Can't create/write to file'./mtweblog/mt_author.frm' Errorcode 13. any suggestions here? tait On 22/03/2004, at 10:15 AM, [EMAIL PROTECTED] wrote: First, mysqldump is a command in and of itself so it does NOT execute from within the mysql command line tool. Next, expand your command entry a bit to include your userid and password, for example: mysqldump -uuserid -ppassword --add-drop-table mtweblog BckUpmtweblog.sql -Original Message- From: tait sanders [mailto:[EMAIL PROTECTED] Sent: Sunday, March 21, 2004 4:50 PM To: mysql Subject: mysqldump error hi all, I'm a newbie to mysql. have os10.3.2 running mysql v4.0.17 am trying to dump a database called 'mtweblog' into a sql file called 'BckUpmtweblog.sql'. when i do 'mysqldump mtweblog BckUpmtweblog.sql' from CLI it gives Error: 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) when trying to connect. when i log into mysql and do 'mysqldump --opt mtweblog BckUpmtweblog.sql;' it gives Error: 1064: You have an error in your SQL syntax. can anyone help me to dump this databse? tait sanders computer technician sir robert webster bldg trc unsw 02 9385 6802 0415 556 303 [EMAIL PROTECTED]
Re: mysqldump error
thanks - i ran the command below and it worked. and now I'm trying to import using: 'mysql -u root -p mtweblog Bckupmtweblog.sql' on CLI on different machine and am getting Error 1 at line 11: Can't create/write to file'./mtweblog/mt_author.frm' Errorcode 13. any suggestions here? tait On 22/03/2004, at 10:15 AM, [EMAIL PROTECTED] wrote: First, mysqldump is a command in and of itself so it does NOT execute from within the mysql command line tool. Next, expand your command entry a bit to include your userid and password, for example: mysqldump -uuserid -ppassword --add-drop-table mtweblog BckUpmtweblog.sql -Original Message- From: tait sanders [mailto:[EMAIL PROTECTED] Sent: Sunday, March 21, 2004 4:50 PM To: mysql Subject: mysqldump error hi all, I'm a newbie to mysql. have os10.3.2 running mysql v4.0.17 am trying to dump a database called 'mtweblog' into a sql file called 'BckUpmtweblog.sql'. when i do 'mysqldump mtweblog BckUpmtweblog.sql' from CLI it gives Error: 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) when trying to connect. when i log into mysql and do 'mysqldump --opt mtweblog BckUpmtweblog.sql;' it gives Error: 1064: You have an error in your SQL syntax. can anyone help me to dump this databse? tait sanders computer technician sir robert webster bldg trc unsw 02 9385 6802 0415 556 303 [EMAIL PROTECTED]
Re: mysqldump error
At 10:12 +1100 3/22/04, tait sanders wrote: thanks - i ran the command below and it worked. and now I'm trying to import using: 'mysql -u root -p mtweblog Bckupmtweblog.sql' on CLI on different machine and am getting Error 1 at line 11: Can't create/write to file'./mtweblog/mt_author.frm' Errorcode 13. any suggestions here? tait % perror 13 Error code 13: Permission denied This typically indicates that the server doesn't have permission to write to its own data directory. Make sure the data directory and its files and subdirectories have their permissions set to allow full access to the login account that you're using to run the server. On 22/03/2004, at 10:15 AM, [EMAIL PROTECTED] wrote: First, mysqldump is a command in and of itself so it does NOT execute from within the mysql command line tool. Next, expand your command entry a bit to include your userid and password, for example: mysqldump -uuserid -ppassword --add-drop-table mtweblog BckUpmtweblog.sql -Original Message- From: tait sanders [mailto:[EMAIL PROTECTED] Sent: Sunday, March 21, 2004 4:50 PM To: mysql Subject: mysqldump error hi all, I'm a newbie to mysql. have os10.3.2 running mysql v4.0.17 am trying to dump a database called 'mtweblog' into a sql file called 'BckUpmtweblog.sql'. when i do 'mysqldump mtweblog BckUpmtweblog.sql' from CLI it gives Error: 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) when trying to connect. when i log into mysql and do 'mysqldump --opt mtweblog BckUpmtweblog.sql;' it gives Error: 1064: You have an error in your SQL syntax. can anyone help me to dump this databse? -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqldump error (mysql 4.0.14)
I have a user who unfortunately named one of his tables order. He also has table names with a dash in them. mysqldump is unable to dump the order table and I'm unable to use the ALTER command on it and the tables with the dashes in their names to rename them. Is there any way to quote the table names so it doesn't treat them as sql commands? /local_a/servers/mysql/bin/mysqldump: Got error: 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'order READ /*!32311 LOCAL */,order_pricing READ /*!32311 LOCAL when using LOCK TABLES -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqldump error (mysql 4.0.14)
Try putting the name inside of backticks; From the Manual: 6.1.2 Database, Table, Index, Column, and Alias Names --- Note that if the identifier is a restricted word or contains special characters you must always quote it with a ` (backtick) when you use it: mysql SELECT * FROM `select` WHERE `select`.id 100; See Section 6.1.7 [Reserved words], page 437. KL Rusty Wright wrote: I have a user who unfortunately named one of his tables order. He also has table names with a dash in them. mysqldump is unable to dump the order table and I'm unable to use the ALTER command on it and the tables with the dashes in their names to rename them. Is there any way to quote the table names so it doesn't treat them as sql commands? /local_a/servers/mysql/bin/mysqldump: Got error: 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'order READ /*!32311 LOCAL */,order_pricing READ /*!32311 LOCAL when using LOCK TABLES -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqldump error (mysql 4.0.14)
Rusty Wright [EMAIL PROTECTED] wrote: I have a user who unfortunately named one of his tables order. He also has table names with a dash in them. mysqldump is unable to dump the order table and I'm unable to use the ALTER command on it and the tables with the dashes in their names to rename them. Is there any way to quote the table names so it doesn't treat them as sql commands? /local_a/servers/mysql/bin/mysqldump: Got error: 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'order READ /*!32311 LOCAL */,order_pricing READ /*!32311 LOCAL when using LOCK TABLES Use -Q option of mysqldump: http://www.mysql.com/doc/en/mysqldump.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqldump error (mysql 4.0.14)
`TableNamesOr FieldNames` - Original Message - From: Kelley Lingerfelt [EMAIL PROTECTED] To: Rusty Wright [EMAIL PROTECTED]; Mysql List [EMAIL PROTECTED] Sent: Monday, September 29, 2003 09:10 Subject: Re: mysqldump error (mysql 4.0.14) Try putting the name inside of backticks; From the Manual: 6.1.2 Database, Table, Index, Column, and Alias Names --- Note that if the identifier is a restricted word or contains special characters you must always quote it with a ` (backtick) when you use it: mysql SELECT * FROM `select` WHERE `select`.id 100; See Section 6.1.7 [Reserved words], page 437. KL Rusty Wright wrote: I have a user who unfortunately named one of his tables order. He also has table names with a dash in them. mysqldump is unable to dump the order table and I'm unable to use the ALTER command on it and the tables with the dashes in their names to rename them. Is there any way to quote the table names so it doesn't treat them as sql commands? /local_a/servers/mysql/bin/mysqldump: Got error: 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'order READ /*!32311 LOCAL */,order_pricing READ /*!32311 LOCAL when using LOCK TABLES -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqldump ERROR 1064
- Original Message - From: David Angela Ehmer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, January 04, 2003 11:00 PM Subject: mysqldump ERROR 1064 Hi I am having problems generating the mysqldump file. I have tried a range of options and carefully studied several tutorials I have on using this command. Each time I get the following errror. ERROR 1064 you have an error in your SQL syntax near 'mysqldump -u root -p adrienne netno_db sql.dump' at line 1. I appear to have other problems with some commands. For example if I type; mysqladmin --help at the command line I get the 1064 ERROR Appreciate any suggestions about what may be the problem here David It looks like you're trying to run the mysqldump and mysqladmin commands from within the mysql client rather than from the shell's command line. Quit out of the mysql client and try running them from the command line. And when you specify the -p password on the command line, do not include a space between the -p and the password. Try instead: mysqldump -u root -padrienne netno_db sql.dump Best regards, Bruce - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqldump ERROR 1064
Hi I am having problems generating the mysqldump file. I have tried a range of options and carefully studied several tutorials I have on using this command. Each time I get the following errror. ERROR 1064 you have an error in your SQL syntax near 'mysqldump -u root -p adrienne netno_db sql.dump' at line 1. I appear to have other problems with some commands. For example if I type; mysqladmin --help at the command line I get the 1064 ERROR Appreciate any suggestions about what may be the problem here David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqldump ERROR 1064
On Sun, 2003-01-05 at 00:00, David Angela Ehmer wrote: Hi I am having problems generating the mysqldump file. I have tried a range of options and carefully studied several tutorials I have on using this command. Each time I get the following errror. ERROR 1064 you have an error in your SQL syntax near 'mysqldump -u root -p adrienne netno_db sql.dump' at line 1. Don't have a space between p and password it should be as : mysqldump -u root -padrienne netno-db sql.dump - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqldump error
mysql 3.23.49a From: Stefan Hinz, iConnect \(Berlin\) [EMAIL PROTECTED] Reply-To: Stefan Hinz, iConnect \(Berlin\) [EMAIL PROTECTED] To: Carlos A. [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: mysqldump error Date: Thu, 5 Dec 2002 22:02:49 +0100 Dear Carlos, ERROR 2013 at line 1: Lost connection to MySQL server during query I think is problem with the binary, but I don't know why.. an idea may be install a recent new version from mysql. Which version do you have? Regards, -- Stefan Hinz [EMAIL PROTECTED] CEO / Geschäftsleitung iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Carlos A. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 7:25 PM Subject: Re: mysqldump error thanks for your answer. Now the problem is worst. When I do a sql request with mysql client and the number of register is a litte big, for example 50, the error appears again: mysql --debug -eselect * from table /tmp/lista.log ERROR 2013 at line 1: Lost connection to MySQL server during query I think is problem with the binary, but I don't know why.. an idea may be install a recent new version from mysql. From: Listen Hinz [EMAIL PROTECTED] To: Carlos A. [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: mysqldump error Date: Thu, 5 Dec 2002 18:16:40 +0100 Dear Carlos, Got error: 2013: Lost connection to MySQL server during query when retrieving data from server In your my.cnf / my.ini configuration file, set the value for the communication buffer high (maximum is 16 MB): [mysqldump] set-variable = max_allowed_packet=16M Restart the server, and the dump should work. HTH! -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Carlos A. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 3:13 PM Subject: mysqldump error Hello I have a Red Hat 7.1 server with mysql 3.23.49a installed. Recently I get an error when run mysqldump in order to backup my dbs. The error is following: /usr/local/bin/mysqldump: Got error: 2013: Lost connection to MySQL server during query when retrieving data from server I ran mysqldump with --opt or without it, the error is the same. I must say the table have many registers, almost 200.000 PD: I ran myisamchk before do the dump, and the error remains. Thanks in advance. _ MSN Fotos: la forma más fácil de compartir e imprimir fotos. http://photos.msn.es/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ MSN. Más Útil Cada Día http://www.msn.es/intmap/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Charla con tus amigos en línea mediante MSN Messenger: http://messenger.microsoft.com/es - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqldump error
Hello I have a Red Hat 7.1 server with mysql 3.23.49a installed. Recently I get an error when run mysqldump in order to backup my dbs. The error is following: /usr/local/bin/mysqldump: Got error: 2013: Lost connection to MySQL server during query when retrieving data from server I ran mysqldump with --opt or without it, the error is the same. I must say the table have many registers, almost 200.000 PD: I ran myisamchk before do the dump, and the error remains. Thanks in advance. _ MSN Fotos: la forma más fácil de compartir e imprimir fotos. http://photos.msn.es/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqldump error
Dear Carlos, Got error: 2013: Lost connection to MySQL server during query when retrieving data from server In your my.cnf / my.ini configuration file, set the value for the communication buffer high (maximum is 16 MB): [mysqldump] set-variable = max_allowed_packet=16M Restart the server, and the dump should work. HTH! -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Carlos A. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 3:13 PM Subject: mysqldump error Hello I have a Red Hat 7.1 server with mysql 3.23.49a installed. Recently I get an error when run mysqldump in order to backup my dbs. The error is following: /usr/local/bin/mysqldump: Got error: 2013: Lost connection to MySQL server during query when retrieving data from server I ran mysqldump with --opt or without it, the error is the same. I must say the table have many registers, almost 200.000 PD: I ran myisamchk before do the dump, and the error remains. Thanks in advance. _ MSN Fotos: la forma más fácil de compartir e imprimir fotos. http://photos.msn.es/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqldump error
thanks for your answer. Now the problem is worst. When I do a sql request with mysql client and the number of register is a litte big, for example 50, the error appears again: mysql --debug -eselect * from table /tmp/lista.log ERROR 2013 at line 1: Lost connection to MySQL server during query I think is problem with the binary, but I don't know why.. an idea may be install a recent new version from mysql. From: Listen Hinz [EMAIL PROTECTED] To: Carlos A. [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: mysqldump error Date: Thu, 5 Dec 2002 18:16:40 +0100 Dear Carlos, Got error: 2013: Lost connection to MySQL server during query when retrieving data from server In your my.cnf / my.ini configuration file, set the value for the communication buffer high (maximum is 16 MB): [mysqldump] set-variable = max_allowed_packet=16M Restart the server, and the dump should work. HTH! -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Carlos A. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 3:13 PM Subject: mysqldump error Hello I have a Red Hat 7.1 server with mysql 3.23.49a installed. Recently I get an error when run mysqldump in order to backup my dbs. The error is following: /usr/local/bin/mysqldump: Got error: 2013: Lost connection to MySQL server during query when retrieving data from server I ran mysqldump with --opt or without it, the error is the same. I must say the table have many registers, almost 200.000 PD: I ran myisamchk before do the dump, and the error remains. Thanks in advance. _ MSN Fotos: la forma más fácil de compartir e imprimir fotos. http://photos.msn.es/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ MSN. Más Útil Cada Día http://www.msn.es/intmap/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqldump error
Dear Carlos, ERROR 2013 at line 1: Lost connection to MySQL server during query I think is problem with the binary, but I don't know why.. an idea may be install a recent new version from mysql. Which version do you have? Regards, -- Stefan Hinz [EMAIL PROTECTED] CEO / Geschäftsleitung iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Carlos A. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 7:25 PM Subject: Re: mysqldump error thanks for your answer. Now the problem is worst. When I do a sql request with mysql client and the number of register is a litte big, for example 50, the error appears again: mysql --debug -eselect * from table /tmp/lista.log ERROR 2013 at line 1: Lost connection to MySQL server during query I think is problem with the binary, but I don't know why.. an idea may be install a recent new version from mysql. From: Listen Hinz [EMAIL PROTECTED] To: Carlos A. [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: mysqldump error Date: Thu, 5 Dec 2002 18:16:40 +0100 Dear Carlos, Got error: 2013: Lost connection to MySQL server during query when retrieving data from server In your my.cnf / my.ini configuration file, set the value for the communication buffer high (maximum is 16 MB): [mysqldump] set-variable = max_allowed_packet=16M Restart the server, and the dump should work. HTH! -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Carlos A. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 3:13 PM Subject: mysqldump error Hello I have a Red Hat 7.1 server with mysql 3.23.49a installed. Recently I get an error when run mysqldump in order to backup my dbs. The error is following: /usr/local/bin/mysqldump: Got error: 2013: Lost connection to MySQL server during query when retrieving data from server I ran mysqldump with --opt or without it, the error is the same. I must say the table have many registers, almost 200.000 PD: I ran myisamchk before do the dump, and the error remains. Thanks in advance. _ MSN Fotos: la forma más fácil de compartir e imprimir fotos. http://photos.msn.es/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ MSN. Más Útil Cada Día http://www.msn.es/intmap/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqldump error
I have mysql 3.23.49a installed. I have noted that some directories under /usr/local/mysql was wrong owner. I change it and try again. The problem is reduced to only one database, because with another with same size of tables (180.000 registers) there is no problem. A tip: when I make a backup remotely there is no problem, the problem is local. I think is a version problem. From: Stefan Hinz, iConnect \(Berlin\) [EMAIL PROTECTED] Reply-To: Stefan Hinz, iConnect \(Berlin\) [EMAIL PROTECTED] To: Carlos A. [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: mysqldump error Date: Thu, 5 Dec 2002 22:02:49 +0100 Dear Carlos, ERROR 2013 at line 1: Lost connection to MySQL server during query I think is problem with the binary, but I don't know why.. an idea may be install a recent new version from mysql. Which version do you have? Regards, -- Stefan Hinz [EMAIL PROTECTED] CEO / Geschäftsleitung iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Carlos A. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 7:25 PM Subject: Re: mysqldump error thanks for your answer. Now the problem is worst. When I do a sql request with mysql client and the number of register is a litte big, for example 50, the error appears again: mysql --debug -eselect * from table /tmp/lista.log ERROR 2013 at line 1: Lost connection to MySQL server during query I think is problem with the binary, but I don't know why.. an idea may be install a recent new version from mysql. From: Listen Hinz [EMAIL PROTECTED] To: Carlos A. [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: mysqldump error Date: Thu, 5 Dec 2002 18:16:40 +0100 Dear Carlos, Got error: 2013: Lost connection to MySQL server during query when retrieving data from server In your my.cnf / my.ini configuration file, set the value for the communication buffer high (maximum is 16 MB): [mysqldump] set-variable = max_allowed_packet=16M Restart the server, and the dump should work. HTH! -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Carlos A. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 3:13 PM Subject: mysqldump error Hello I have a Red Hat 7.1 server with mysql 3.23.49a installed. Recently I get an error when run mysqldump in order to backup my dbs. The error is following: /usr/local/bin/mysqldump: Got error: 2013: Lost connection to MySQL server during query when retrieving data from server I ran mysqldump with --opt or without it, the error is the same. I must say the table have many registers, almost 200.000 PD: I ran myisamchk before do the dump, and the error remains. Thanks in advance. _ MSN Fotos: la forma más fácil de compartir e imprimir fotos. http://photos.msn.es/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ MSN. Más Útil Cada Día http://www.msn.es/intmap/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Charla con tus amigos en línea mediante MSN Messenger: http://messenger.microsoft.com/es - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to direct mysqldump error to a file?
Hi, all, sql, query. I am scheduling a cronjob to backup mysql database using mysqldump. mysql@/usr/local/mysql/output /usr/local/mysql/bin/mysqldump -umysql -pmysqlpw --opt nondb bkp1.sql 2 err.log Ambiguous output redirect. How I can direct any stderr to a file? Thank you, Jing _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to direct mysqldump error to a file?
At 20:45 + 11/19/02, Jannie Qu wrote: Hi, all, sql, query. I am scheduling a cronjob to backup mysql database using mysqldump. mysql@/usr/local/mysql/output /usr/local/mysql/bin/mysqldump -umysql -pmysqlpw --opt nondb bkp1.sql 2 err.log Ambiguous output redirect. How I can direct any stderr to a file? Thank you, Jing In this case, you can't, because your command itself is malformed. mysqldump isn't even executing. What's that mysql@/usr/local/mysql/output stuff at the beginning supposed to represent? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to direct mysqldump error to a file?
Hi, paul, I got why, the first time I run the command is under tcsh, after I change to bash the command works. === mysql@/usr/local/mysql /usr/local/bin/mysql -ujqu -pjqu1234@ --opt nondb bkp_nondb.sql 2 err.log Ambiguous output redirect. mysql@/usr/local/mysql echo $0 -tcsh mysql@/usr/local/mysql bash bash-2.05a$ /usr/local/bin/mysql -ujqu -pjqu1234@ --opt nondb bkp_nondb.sql 2 err.log === mysql@/usr/local/mysql is PS1 setting. bash-2.05a$ is PS1 setting. From: Paul DuBois [EMAIL PROTECTED] To: Jannie Qu [EMAIL PROTECTED] Subject: Re: How to direct mysqldump error to a file? Date: Tue, 19 Nov 2002 16:12:53 -0600 At 22:09 + 11/19/02, Jannie Qu wrote: Hi, Paul, Here is more meaningful representation: === shell /usr/local/mysql/output /usr/local/mysql/bin/mysqldump -umysql -pmysqlpw --opt nondb bkp1.sql 2 err.log === mysql@ is our PS1 prompt (am I using the right term?) I guess stdin=0 stdout=1 stderr=2, so I put 2err.log there. It's still malformed. What is the /usr/local/mysql/output supposed to represent? Your command has two output redirection operators in it, that's why you get the ambiguous output redirect error message. From: Paul DuBois [EMAIL PROTECTED] To: Jannie Qu [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: How to direct mysqldump error to a file? Date: Tue, 19 Nov 2002 16:00:28 -0600 At 20:45 + 11/19/02, Jannie Qu wrote: Hi, all, sql, query. I am scheduling a cronjob to backup mysql database using mysqldump. mysql@/usr/local/mysql/output /usr/local/mysql/bin/mysqldump -umysql -pmysqlpw --opt nondb bkp1.sql 2 err.log Ambiguous output redirect. How I can direct any stderr to a file? Thank you, Jing In this case, you can't, because your command itself is malformed. mysqldump isn't even executing. What's that mysql@/usr/local/mysql/output stuff at the beginning supposed to represent? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqldump ERROR
Please help me mysqldump: ON: mysqldump --opt --user=user_name -pPassword _stat_ | gzip -1 database.gz I have an error : mysqldump: Got error: 1017: Can't find file: './_stat_/_stat_193_219_2_250.frm' (errno: 24) when using LOCK TABLES Thanks very much. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: mysqldump ERROR
tl, Thursday, September 26, 2002, 3:44:30 PM, you wrote: t Please help me mysqldump: t ON: t mysqldump --opt --user=user_name -pPassword _stat_ | gzip -1 database.gz t I have an error : t mysqldump: Got error: 1017: Can't find file: './_stat_/_stat_193_219_2_250.frm' (errno: 24) when using LOCK TABLES $ perror 24 Error code 24: Too many open files Take a look at: http://www.mysql.com/doc/en/Not_enough_file_handles.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqldump Error
I'm trying to use mysqldump to dump a database (obviously). Here's the commandline I'm using: [root@fugu work]# mysqldump --tab=. wonderdesk mysqldump: Got error: 1: Can't create/write to file '/root/work/Calls.txt' (Errcode: 13) The interesting thing, is that is IS creating Calls.sql, but it then crashes on Calls.txt. I've got plenty of drive space, file permissions aren't a problem, and it's creating some files, but not all of them. Anyone got any Ideas? I've searched around a bit, and haven't been able to find what an errcode 13 is, so I'm out of ideas. Thanks guys! Joel
Re: mysqldump Error
ah but I do.. Allow me to prove it.. drwxr-xr-x 4 root wheel 512 Mar 14 12:50 work [root@fugu work]# touch this_works [root@fugu work]# ls -la -rw-r--r-- 1 root wheel0 Mar 14 13:42 this_works And, as I stated before, the Calls.sql file IS being created in this same directory. Is it possible this sort of permission denied is related to some part of the database?? I should mention that I can run a "normal" mysqldump till I'm blue in the face, it's just when I try and create these tab deliminated files that is chokes. Thanks! Joel - Original Message - From: "Gerald L. Clark" [EMAIL PROTECTED] To: "Joel Caturia" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, March 14, 2001 1:43 PM Subject: Re: mysqldump Error Joel Caturia wrote: I'm trying to use mysqldump to dump a database (obviously). Here's the commandline I'm using: [root@fugu work]# mysqldump --tab=. wonderdesk mysqldump: Got error: 1: Can't create/write to file '/root/work/Calls.txt' (Errcode: 13) The interesting thing, is that is IS creating Calls.sql, but it then crashes on Calls.txt. I've got plenty of drive space, file permissions aren't a problem, and it's creating some files, but not all of them. Anyone got any Ideas? I've searched around a bit, and haven't been able to find what an errcode 13 is, so I'm out of ideas. Thanks guys! Joel perror 13 Permission denied You don't have write permission in /root/work. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysqldump Error
Hi, Error 13 is permissions. Your server has to have permission to write to the directory, and over-write any existing file of the same name. Regards Quentin -Original Message- From: Joel Caturia [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 March 2001 10:07 a.m. To: [EMAIL PROTECTED] Subject: mysqldump Error I'm trying to use mysqldump to dump a database (obviously). Here's the commandline I'm using: [root@fugu work]# mysqldump --tab=. wonderdesk mysqldump: Got error: 1: Can't create/write to file '/root/work/Calls.txt' (Errcode: 13) The interesting thing, is that is IS creating Calls.sql, but it then crashes on Calls.txt. I've got plenty of drive space, file permissions aren't a problem, and it's creating some files, but not all of them. Anyone got any Ideas? I've searched around a bit, and haven't been able to find what an errcode 13 is, so I'm out of ideas. Thanks guys! Joel The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysqldump Error
Hi, But is your mysql server run by root, or, as advised, by 'mysql'? Quentin -Original Message- From: Joel Caturia [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 March 2001 10:56 a.m. To: Gerald L. Clark Cc: [EMAIL PROTECTED] Subject: Re: mysqldump Error ah but I do.. Allow me to prove it.. drwxr-xr-x 4 root wheel 512 Mar 14 12:50 work [root@fugu work]# touch this_works [root@fugu work]# ls -la -rw-r--r-- 1 root wheel0 Mar 14 13:42 this_works And, as I stated before, the Calls.sql file IS being created in this same directory. Is it possible this sort of permission denied is related to some part of the database?? I should mention that I can run a "normal" mysqldump till I'm blue in the face, it's just when I try and create these tab deliminated files that is chokes. Thanks! Joel - Original Message - From: "Gerald L. Clark" [EMAIL PROTECTED] To: "Joel Caturia" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, March 14, 2001 1:43 PM Subject: Re: mysqldump Error Joel Caturia wrote: I'm trying to use mysqldump to dump a database (obviously). Here's the commandline I'm using: [root@fugu work]# mysqldump --tab=. wonderdesk mysqldump: Got error: 1: Can't create/write to file '/root/work/Calls.txt' (Errcode: 13) The interesting thing, is that is IS creating Calls.sql, but it then crashes on Calls.txt. I've got plenty of drive space, file permissions aren't a problem, and it's creating some files, but not all of them. Anyone got any Ideas? I've searched around a bit, and haven't been able to find what an errcode 13 is, so I'm out of ideas. Thanks guys! Joel perror 13 Permission denied You don't have write permission in /root/work. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqldump Error
ahhh.. ok, I understand.. So the moral of the story is the mysql process itself touches the local filesystem. It's NOT the UID of the person running the command that matters, it's who the daemon is running as. Hence the reason the help page says "this only works when running on the same machine the daemon is on." But, I imagine the first part of the export IS running as root, because it works. Thank you for clearing this up, that didn't make a whole lot of sense to me, not it makes perfect sense. The export works now, case closed.. Thanks again! Joel - Original Message - From: "Quentin Bennett" [EMAIL PROTECTED] To: "'Joel Caturia'" [EMAIL PROTECTED]; "Gerald L. Clark" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, March 14, 2001 2:19 PM Subject: RE: mysqldump Error Hi, But is your mysql server run by root, or, as advised, by 'mysql'? Quentin -Original Message- From: Joel Caturia [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 March 2001 10:56 a.m. To: Gerald L. Clark Cc: [EMAIL PROTECTED] Subject: Re: mysqldump Error ah but I do.. Allow me to prove it.. drwxr-xr-x 4 root wheel 512 Mar 14 12:50 work [root@fugu work]# touch this_works [root@fugu work]# ls -la -rw-r--r-- 1 root wheel0 Mar 14 13:42 this_works And, as I stated before, the Calls.sql file IS being created in this same directory. Is it possible this sort of permission denied is related to some part of the database?? I should mention that I can run a "normal" mysqldump till I'm blue in the face, it's just when I try and create these tab deliminated files that is chokes. Thanks! Joel - Original Message - From: "Gerald L. Clark" [EMAIL PROTECTED] To: "Joel Caturia" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, March 14, 2001 1:43 PM Subject: Re: mysqldump Error Joel Caturia wrote: I'm trying to use mysqldump to dump a database (obviously). Here's the commandline I'm using: [root@fugu work]# mysqldump --tab=. wonderdesk mysqldump: Got error: 1: Can't create/write to file '/root/work/Calls.txt' (Errcode: 13) The interesting thing, is that is IS creating Calls.sql, but it then crashes on Calls.txt. I've got plenty of drive space, file permissions aren't a problem, and it's creating some files, but not all of them. Anyone got any Ideas? I've searched around a bit, and haven't been able to find what an errcode 13 is, so I'm out of ideas. Thanks guys! Joel perror 13 Permission denied You don't have write permission in /root/work. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php