Hlo all,
I wanted to move around 50 GB of data on Machine A to Machine B. Both the
machines are of same architecture ( LAMP )
Dumping and restoring takes a lot of time. Is there a faster method to
accomplish the same?
Is there a way to tar the whole thing and untar on Machine B? or any other
Hlo all,
I wanted to move around 50 GB of data on Machine A to Machine B. Both the
machines are of same architecture ( LAMP )
Dumping and restoring takes a lot of time. Is there a faster method to
accomplish the same?
Is there a way to tar the whole thing and untar on Machine B? or any other
Hi !
Any clue will be appriciated.
I have following problem while cross compiling for powerpc. (Configure)
checking "return type of sprintf"... configure: error: cannot run test
program while cross compiling
This occurs when makefile is generated with the following configure option.
CC=powerpc-li
Hi !
Any clue will be appriciated.
I have following problem while cross compiling for powerpc. (Configure)
checking "return type of sprintf"... configure: error: cannot run test
program while cross compiling
This occurs when makefile is generated with the following configure option.
CC=powerpc-li
Hi Dan:
Not very sure, but you could try exploring "user variables":
http://dev.mysql.com/doc/refman/5.0/en/user-variables.html
Regards,
Alvaro Cobo
Dan Jakubiec escribió:
> Hi Chris,
>
> On 9/10/06, Chris W <[EMAIL PROTECTED]> wrote:
>>
>> This works on a table I have.
>>
>> SELECT MIN(tone)
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> I need some inputs regarding my.cnf :
>
> We are using INNODB in our application.We have around 10
> million records in the database. This will size up to
> around 10GB of data.
>
> Could you please suggest a sample my.cnf for this
> configuratio
Hi Chris,
On 9/10/06, Chris W <[EMAIL PROTECTED]> wrote:
This works on a table I have.
SELECT MIN(tone) as `min`, MAX(tone) as `max`, MIN(tone)/MAX(tone) as
ratio FROM pltone p
Thanks for the suggestion. This works for me too, but what I'm really
looking for is a way to *alias* the first t
You are absolutely right. The entire data base is UTF-8.
That explains why the examples I found were not in English.
Thanks.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Paul
> I'm using MySQL Linux version 4.1.21 standard.
>
> I have a table with fields of a variety of types, including varchar(255)
and
> text (which might matter). When I do
>
> SELECT MAX(LENGTH(x)) FROM tx;
>
> where x is a varchar(255), I get back 266 as the result of the query!
>
> This isn't list
Jerry Schwartz wrote:
I'm using MySQL Linux version 4.1.21 standard.
I have a table with fields of a variety of types, including varchar(255) and
text (which might matter). When I do
SELECT MAX(LENGTH(x)) FROM tx;
where x is a varchar(255), I get back 266 as the result of the query!
This
>Is it possible to rename a DB schema? if so how? Using mysql
5.0, innodb engine.
See 'Rename Database' at http://www.artfulsoftware.com/queries.php for
a start on the solution.
PB
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268
I'm using MySQL Linux version 4.1.21 standard.
I have a table with fields of a variety of types, including varchar(255) and
text (which might matter). When I do
SELECT MAX(LENGTH(x)) FROM tx;
where x is a varchar(255), I get back 266 as the result of the query!
This isn't listed as one of
Hi,
Is it possible to rename a DB schema? if so how? Using mysql 5.0, innodb
engine.
-nikita
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
Ok, thx for your help, it's a little bit faster, but also much too slow.
And what can I do that I can find such characters like 'ä' with a select
like:
SELECT * FROM myTable WHERE myField like '%a%'
in the unicode-field?
br
Charlie
> -Ursprüngliche Nachricht-
> Von: Paul McCullagh
Now that all of the latest distros of OSX use bash by default, I thought I
would amend this with bash instructions.
When you instantiate a shell in OSX, the ~/.bash_login file is parsed.
Because this isn't a global file you can edit it just like the .tshrc below.
The entry you need to make is:
ex
Hi Charlie,
The performance problem may be due to using UTF-8 instead of unicode.
Try declaring your text column as:
my_text VARCHAR(...) UNICODE
I am guessing, but it may be that the search is slow because MySQL
has to convert UTF-8 to UNICODE before doing the comparison.
BTW, don't use
Pardon me if my meager German caused me to misunderstand your question.
We have a French website in UTF-8, and in my experimentation it appeared
that UTF-8 (not binary) fields can be searched without using accents. For
example, doing a full-text search for "etudes" found "études". I do not know
ho
Aloa,
ich muß in einer Webanwendung jetzt auch noch Daten von verschiedenen
Ost-Ländern wie zB Bulgarien, Polen, Tschechien usw. integrieren.
Das hätte ich mir eigentlich alles recht einfach vorgestellt, aber leider
ist meine DB nach einer Umstellung von latin1 auf utf8 sehr langsam und die
Suche
Hej Jörn,
the problem lies in that you added your
b.verified=1 condition in the WHERE part,
what happens then is that you more or less transform
your left join into an inner join as you add on a condtion
for existing rows. If you do your query as:
SELECT a.name,COUNT(b.id) FROM x_type AS a LEFT JO
Assume the following tables:
CREATE TABLE x_type (
idmediumint unsigned not null auto_increment,
name char(20),
primary key (id)
)
INSERT INTO x_type (id,name) VALUES (1,'aa'),(2,'bb'),(3,'cc');
CREATE TABLE x_ref (
idmediumint unsigned not null auto_increment,
type mediumint
Dear ladies and gentlemen,
Upscene Productions is happy to announce a new version of
the database developer tool:
"Advanced Data Generator" (version 1.7.0)
A fast test-data generator tool that comes with a library
of real-life data, can generate data to your database,
SQL script or CSV files, man
21 matches
Mail list logo
