In the last episode (Jun 05), Pabst Simon said:
> Description:
>
> When using mysqlhotcopy 1.15 for database backups with --regexp='.*' and
> having 640 or more Databases produces the following error:
>
> DBD::mysql::db do failed: File '/lvol1/mysql/data/mydatabase/mytable640.MYD' not
>found (
r with 640 or more Tables
Syntax:
mysql/bin/mysqlhotcopy --regexp='.*' /somedir
Fix:
?
Submitter-Id:
Originator:Simon Pabst
Organization: Siemens Business Services
MySQL support: none
Synopsis: mysqlhotcopy regexp problem with 640 and more Databases
Severity: s
I want to enable a user-friendly search for authors in a books database.
When an author's name is spelled in several ways (T.S. Eliot; Eliot, T S;
Eliot, Thomas Stearns, etc.) the user input using these different spellings
should find all entries from this author. I thought I could get this don
On Fri, Aug 17, 2001 at 03:46:11PM +0100, Lee Denny wrote:
> Hello,
>
> Can any one tell me why
>
> $sql="SELECT * FROM table WHERE pcsort REGEXP '^".$parts[0]."[0-9]'";
> (pcscot being a CHAR(10), $parts[0] being a single alpha charcater.)
>
> works OK in 3.23 but not in 3.22.
>
> I'm trying
Hello,
Can any one tell me why
$sql="SELECT * FROM table WHERE pcsort REGEXP '^".$parts[0]."[0-9]'";
(pcscot being a CHAR(10), $parts[0] being a single alpha charcater.)
works OK in 3.23 but not in 3.22.
I'm trying to find UK postcodes such as e17 but not ee17.
All the best,
Lee
--
On Fri, Jul 20, 2001 at 01:25:22AM -0700, Jeremy Zawodny wrote:
> >
> > If I specify just one database, I still get the "deprecated"
> > warning, but the hotcopy works...
>
> There are two bugs.
>
> (1) The "depricated" message. I'm submitting a patch for that.
>
> (2) The fact that if yo
On Wed, Jul 18, 2001 at 09:57:00AM -0800, Chris Lott wrote:
>
> Using the mysqhotcopy that came with the most recent MySQL (3.23.39)
> on a RedHat 7.1 box with perl 5.6.0, I am getting the following
> errors when trying to back up all databases:
>
> mysqlhotcopy --password="foo" --allowold --reg
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Using the mysqhotcopy that came with the most recent MySQL (3.23.39) on a
RedHat 7.1 box with perl 5.6.0, I am getting the following errors when
trying to back up all databases:
mysqlhotcopy --password="foo" --allowold --regexp=".*" /usr/backups/ \
