subject:"Problem with mysqlhotcopy"

Re: Problem with mysqlhotcopy

2005-02-23 Thread Gleb Paharenko

Hello.



 e:\mysql\scripts\mysqlhotcopy.pl -u root -p password db_name /backup_test



I think, the problem is in the missing period in /backup_test, it should be

./backup_test. But generally Windows isn't listed in operating systems list 

on which mysqlhotcopy works.



Maybe cygwin will help. 





MightyData [EMAIL PROTECTED] wrote:

 I am running MySQL and Perl on Windows 2003. I am trying to use the

 mysqlhotocpy script for backup. Mysqlhotcopy will execute but returns an

 error.

 

 Command:

 e:\mysql\scripts\mysqlhotcopy.pl -u root -p password db_name /backup_test

 

 Error:

 The system cannot find the path specified.

 Executing command failed (256) Trying backtick execution...

 ...list_of_files...

 Failed (32768) while copying files

 

 -

 Kirk Bowman   Phone: 972-390-8600

 MightyData, LLC http://www.mightydata.com

 FileMaker 7 Certified Developer  FileMaker Authorized Trainer

   Check out our FileMaker 7 training classes!

 -

 

 



-- 
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]

Problem with mysqlhotcopy

2005-02-22 Thread MightyData

I am running MySQL and Perl on Windows 2003. I am trying to use the
mysqlhotocpy script for backup. Mysqlhotcopy will execute but returns an
error.

Command:
e:\mysql\scripts\mysqlhotcopy.pl -u root -p password db_name /backup_test

Error:
The system cannot find the path specified.
Executing command failed (256) Trying backtick execution...
...list_of_files...
Failed (32768) while copying files

-
Kirk Bowman   Phone: 972-390-8600
MightyData, LLC http://www.mightydata.com
FileMaker 7 Certified Developer  FileMaker Authorized Trainer
   Check out our FileMaker 7 training classes!
-


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problem with mysqlhotcopy version 1.17 when using --record_log_pos

2003-01-29 Thread Søren Thing Andersen

 Description:
   With mysqlhotcopy version 1.15 (from MySQL-3.23.49-1) I used
   to do like this:
 mysqlhotcopy --user=root --password=foo -q --allowold
 --record_log_pos backup.log_pos db1 db2 backup $TMPDIR
   After upgrading to MySQL-3.23.55-1 and thus mysqlhotcopy
   version 1.17 the same command gave this error:
 DBD::mysql::db do failed: Not unique table/alias: 'log_pos' at
 /usr/bin/mysqlhotcopy line 437.
   The problem is that line 311 now adds backticks around
   database and table names:
 my @hc_tables = map { `$db`.`$_` } @dbh_tables;
   This is not taken into account at line 422 where $table comes
   directly from $opt{checkpoint} or $opt{record_log_pos}:
 unless ( $hc_locks =~ s/$table\s+READ/$table WRITE/ );
   The resulting lock-command becomes:
 LOCK TABLES `db1`.`table1` READ, `db2`.`table1` READ,
 `backup`.`log_pos` READ, backup.log_pos WRITE
 How-To-Repeat:
   Try issuing the command
 mysqlhotcopy --user=root --password=foo -q --allowold
 --record_log_pos backup.log_pos db1 db2 backup $TMPDIR
   where the database that the log_pos is recorded in is also in the
   list of databases to backup.
 Fix:
   Fix documentation so it doesn't say
 The name of the log-pos table should be supplied in database.table
 format.
   but
 ... supplied in \`database\`.\`table\` format.
   
   Or better, add this fix (sorry about my Perl - I know it is
   bad):
 --- mysqlhotcopy.orig   Wed Jan 29 14:00:00 2003
 +++ mysqlhotcopyWed Jan 29 14:00:14 2003
 @@ -113,6 +113,14 @@
  dryrun|n,
  ) or usage(Invalid option);
 
 +# Make sure that $opt{record_log_pos} is of form `db`.`table`
 +if (defined($opt{record_log_pos}))
 +{
 +$opt{record_log_pos} =~ tr/\`//d;
 +$opt{record_log_pos} =~ s/\./\`\.\`/;
 +$opt{record_log_pos} = \`$opt{record_log_pos}\`;
 +}
 +
  # @db_desc
  # ==
  # a list of hash-refs containing:
 
The same should probably be done for $opt{checkpoint}.

 Submitter-Id:[EMAIL PROTECTED]
 Originator:  Soeren Thing Andersen
 Organization:
  TDC
 MySQL support: none
 Synopsis:Backticks not added to $opt{record_log_pos}
 Severity:non-critical
 Priority:medium
 Category:mysql
 Class:   sw-bug
 Release: mysql-3.23.55 (Official MySQL RPM)
 
 Environment:
 System: Linux alarmnetgw2.vpn.alarm-net.dk 2.4.9-31 #1 Tue Feb 26 07:11:02
 EST 2002 i686 unknown
 Architecture: i686
 
 Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
 /usr/bin/cc
 GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
 gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-85)
 Compilation info: CC='gcc'  CFLAGS='-O6 -fno-omit-frame-pointer -mpentium'
 CXX='gcc'  CXXFLAGS='-O6 -fno-omit-frame-pointer
 -felide-constructors -fno-exceptions -fno-rtti -mpentium'  LDFLAGS=''
 LIBC: 
 lrwxrwxrwx1 root root   13 Oct 10 14:51 /lib/libc.so.6 -
 libc-2.2.4.so
 -rwxr-xr-x1 root root  1285884 Sep  9 18:10 /lib/libc-2.2.4.so
 -rw-r--r--1 root root 27336078 Sep  9 17:48 /usr/lib/libc.a
 -rw-r--r--1 root root  178 Sep  9 17:48 /usr/lib/libc.so
 Configure command: ./configure '--disable-shared'
 '--with-mysqld-ldflags=-all-static' '--with-client-ldflags=-all-static'
 '--without-berkeley-db' '--without-innodb' '--enable-assembler'
 '--enable-local-infile' '--with-mysqld-user=mysql'
 '--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--prefix=/'
 '--with-extra-charsets=complex' '--exec-prefix=/usr'
 '--libexecdir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share'
 '--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info'
 '--includedir=/usr/include' '--mandir=/usr/share/man'
 '--with-comment=Official MySQL RPM' 'CC=gcc' 'CFLAGS=-O6
 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer
 -felide-constructors -fno-exceptions -fno-rtti -mpentium' 'CXX=gcc'

-
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

problem with mysqlhotcopy

2002-07-03 Thread Ralf Juengling


Hi mysql wizards,

I've a problem with mysqlhotcopy, i.e. the 'copy step' fails. I've no
idea why  (for I don't understand perl), could anyone help?

Here is how mysqlhotcopy is invoked (intentionaly using option
'-n' here):

 mysqlhotcopy webimages /swpr_ss02-2/frisbee/dbbackups --allowold
--keepold  -u frisbeebackup -p DOIT -n
rmtree /swpr_ss02-2/frisbee/dbbackups/webimages_old
rename /swpr_ss02-2/frisbee/dbbackups/webimages,
/swpr_ss02-2/frisbee/dbbackups/webimages_old
mkdir /swpr_ss02-2/frisbee/dbbackups/webimages/, 0750
LOCK TABLES webimages.CONFIGURATION READ, webimages.CONTEXTS READ,
webimages.HOSTS READ, webimages.HTMLPAGES READ, webimages.HTMLPAGES_OLD
READ, webimages.IMAGES READ, webimages.IMAGES_OLD READ,
webimages.IMAGE_DATA READ, webimages.JOBENTRY_CONTEXTANALYSIS READ,
webimages.JOBENTRY_DLCONTEXT READ, webimages.JOBENTRY_DLIMAGE READ,
webimages.JOBENTRY_IMAGE_FEATURES READ, webimages.JOBENTRY_IMAGE_INFO
READ, webimages.JOBLIST_CONTEXTANALYSIS READ,
webimages.JOBLIST_DLCONTEXT READ, webimages.JOBLIST_DLIMAGE READ,
webimages.JOBLIST_IMAGE_FEATURES READ, webimages.JOBLIST_IMAGE_INFO
READ, webimages.KEYWORDS READ, webimages.KEYWORDS_OLD READ,
webimages.MN_IMAGES_KEYWORDS READ
FLUSH TABLES /*!32323 webimages.CONFIGURATION, webimages.CONTEXTS,
webimages.HOSTS, webimages.HTMLPAGES, webimages.HTMLPAGES_OLD,
webimages.IMAGES, webimages.IMAGES_OLD, webimages.IMAGE_DATA,
webimages.JOBENTRY_CONTEXTANALYSIS, webimages.JOBENTRY_DLCONTEXT,
webimages.JOBENTRY_DLIMAGE, webimages.JOBENTRY_IMAGE_FEATURES,
webimages.JOBENTRY_IMAGE_INFO, webimages.JOBLIST_CONTEXTANALYSIS,
webimages.JOBLIST_DLCONTEXT, webimages.JOBLIST_DLIMAGE,
webimages.JOBLIST_IMAGE_FEATURES, webimages.JOBLIST_IMAGE_INFO,
webimages.KEYWORDS, webimages.KEYWORDS_OLD, webimages.MN_IMAGES_KEYWORDS
*/
Copying 63 files...
cp -p /swpr_ss02-2/frisbee/dbbackups/webimages
Copying indices for 0 files...
UNLOCK TABLES

As you can see, the cp command is missing the source parameter...
This is mysqlhotcopy version 1.14 running on a debian linux.

Regards,
Ralf

-- 
-
Ralf Jüngling
Institut für Informatik - Lehrstuhl f. Mustererkennung 
Bildverarbeitung
Georges-Köhler-Allee
Gebäude 52   Tel:
+49-(0)761-203-8215
79110 Freiburg   Fax:
+49-(0)761-203-8262
-


-
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

problem with mysqlhotcopy

2002-07-03 Thread Ralf Juengling


Hi mysql wizards,

I've a problem with mysqlhotcopy, i.e. the 'copy step' fails. I've no
idea why  (for I don't understand perl), could anyone help?

Here is how mysqlhotcopy is invoked (intentionaly using option
'-n' here):

 mysqlhotcopy webimages /swpr_ss02-2/frisbee/dbbackups --allowold
--keepold  -u frisbeebackup -p DOIT -n
rmtree /swpr_ss02-2/frisbee/dbbackups/webimages_old
rename /swpr_ss02-2/frisbee/dbbackups/webimages,
/swpr_ss02-2/frisbee/dbbackups/webimages_old
mkdir /swpr_ss02-2/frisbee/dbbackups/webimages/, 0750
LOCK TABLES webimages.CONFIGURATION READ, webimages.CONTEXTS READ,
webimages.HOSTS READ, webimages.HTMLPAGES READ, webimages.HTMLPAGES_OLD
READ, webimages.IMAGES READ, webimages.IMAGES_OLD READ,
webimages.IMAGE_DATA READ, webimages.JOBENTRY_CONTEXTANALYSIS READ,
webimages.JOBENTRY_DLCONTEXT READ, webimages.JOBENTRY_DLIMAGE READ,
webimages.JOBENTRY_IMAGE_FEATURES READ, webimages.JOBENTRY_IMAGE_INFO
READ, webimages.JOBLIST_CONTEXTANALYSIS READ,
webimages.JOBLIST_DLCONTEXT READ, webimages.JOBLIST_DLIMAGE READ,
webimages.JOBLIST_IMAGE_FEATURES READ, webimages.JOBLIST_IMAGE_INFO
READ, webimages.KEYWORDS READ, webimages.KEYWORDS_OLD READ,
webimages.MN_IMAGES_KEYWORDS READ
FLUSH TABLES /*!32323 webimages.CONFIGURATION, webimages.CONTEXTS,
webimages.HOSTS, webimages.HTMLPAGES, webimages.HTMLPAGES_OLD,
webimages.IMAGES, webimages.IMAGES_OLD, webimages.IMAGE_DATA,
webimages.JOBENTRY_CONTEXTANALYSIS, webimages.JOBENTRY_DLCONTEXT,
webimages.JOBENTRY_DLIMAGE, webimages.JOBENTRY_IMAGE_FEATURES,
webimages.JOBENTRY_IMAGE_INFO, webimages.JOBLIST_CONTEXTANALYSIS,
webimages.JOBLIST_DLCONTEXT, webimages.JOBLIST_DLIMAGE,
webimages.JOBLIST_IMAGE_FEATURES, webimages.JOBLIST_IMAGE_INFO,
webimages.KEYWORDS, webimages.KEYWORDS_OLD, webimages.MN_IMAGES_KEYWORDS
*/
Copying 63 files...
cp -p /swpr_ss02-2/frisbee/dbbackups/webimages
Copying indices for 0 files...
UNLOCK TABLES

As you can see, the cp command is missing the source parameter...
This is mysqlhotcopy version 1.14 running on a debian linux.

Regards,
Ralf

-- 
-
Ralf Jüngling
Institut für Informatik - Lehrstuhl f. Mustererkennung 
Bildverarbeitung
Georges-Köhler-Allee
Gebäude 52   Tel:
+49-(0)761-203-8215
79110 Freiburg   Fax:
+49-(0)761-203-8262
-


-
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: Problem with mysqlhotcopy

Problem with mysqlhotcopy

Problem with mysqlhotcopy version 1.17 when using --record_log_pos

problem with mysqlhotcopy

problem with mysqlhotcopy

5 matches

Site Navigation

Mail list logo

Footer information