Hi,
On 21-9-2010 5:25, Tim Thorburn wrote:
Ignore that ... it's amazing how you can solve problems with enough
caffeine and enough time away from a computer screen >.>
It's also amazing how frustrating it is for those who are searching for
the problem you mentioned to only find threads with '
Ignore that ... it's amazing how you can solve problems with enough
caffeine and enough time away from a computer screen >.>
On 9/20/2010 10:58 PM, Tim Thorburn wrote:
Hello,
A few days ago I ran into Error 1045 when attempting to add a new
database user to my development machine. The erro
Hello,
A few days ago I ran into Error 1045 when attempting to add a new
database user to my development machine. The error only occurred when
trying to connect to the database as a new user which I found a little
odd. After searching Google I discovered that this error is caused by a
time
On Sep 17, 2010, at 7:08 AM, Tompkins Neil wrote:
> Hi
>
> Why when I run the command (MySQL 5.1) SELECT SHA1('abc'); is it returned as
> a binary value and not a string value ?
If you mean, why is it a binary rather than a nonbinary (character) string,
that's true of most of the encryption or
Hi,
On Mon, Sep 20, 2010 at 4:59 AM, Tompkins Neil
wrote:
> Any ideas why my statement like SELECT SHA1('abc') AS my_sha is being
> returned as binary value, I thought it should be returning HEX in anycase ?
Maybe because that's what it's intended to do.
http://dev.mysql.com/doc/refman/5.1/en/en
On Mon, Sep 20, 2010 at 7:36 AM, Shawn Green (MySQL)
wrote:
> Hello Hank,
>
> On 9/18/2010 9:35 PM, Hank wrote:
>>
>> I have the following pseudo code running on mysql 4.x:
>>
>> set @cnt:=0;
>> insert ignore into dest_table
>> select t1.field1, t1.field2, t1.field3, t2.field1,
>> t1.fiel
Hello Hank,
On 9/18/2010 9:35 PM, Hank wrote:
I have the following pseudo code running on mysql 4.x:
set @cnt:=0;
insert ignore into dest_table
select t1.field1, t1.field2, t1.field3, t2.field1,
t1.field3, t2.ts, @cnt:=...@cnt+1
from table1 as t1 left join table2 as t2 using (f
Hello,
Basically you need to do it manually, no auto import tool will get things
100%
1. create tables, substituting datatypes from source database to compatible
mysql (especially the integer types)
2. create keys that will give same result
3. pump the data, you might have to write scripts to do
That entirely depends on your requirement, if you need it to be
accessible with the same username and password, then configure it with
the same username and password.
thanks Andy.
Quoting Uwe Brauer :
On Mon, 20 Sep 2010 12:14:06 +0200, Johan De Meersman
wrote:
> He did suggest doin
On Mon, Sep 20, 2010 at 12:48 PM, Uwe Brauer wrote:
> > On Mon, 20 Sep 2010 12:14:06 +0200, Johan De Meersman <
> vegiv...@tuxera.be> wrote:
>
> > He did suggest doing mysqladmin create :-p
>
> The only thing which is not clear to me is whether
> db_org and db_clone
> should have the same u
> On Mon, 20 Sep 2010 12:14:06 +0200, Johan De Meersman
> wrote:
> He did suggest doing mysqladmin create :-p
The only thing which is not clear to me is whether
db_org and db_clone
should have the same user (and maybe the same password.)
Uwe Brauer
--
MySQL General Mailing Li
oopss...sorry...i did not see that line
On Mon, Sep 20, 2010 at 3:44 PM, Johan De Meersman wrote:
> He did suggest doing mysqladmin create :-p
>
>
> On Mon, Sep 20, 2010 at 11:58 AM, Ananda Kumar wrote:
>
>> With the method you mentioned, you need to have the new db name already
>> present.
He did suggest doing mysqladmin create :-p
On Mon, Sep 20, 2010 at 11:58 AM, Ananda Kumar wrote:
> With the method you mentioned, you need to have the new db name already
> present.
> You can do it this way or the edit dump file way.
>
> regards
> anandkl
>
> On Mon, Sep 20, 2010 at 3:19 PM, Joh
With the method you mentioned, you need to have the new db name already
present.
You can do it this way or the edit dump file way.
regards
anandkl
On Mon, Sep 20, 2010 at 3:19 PM, Johan De Meersman wrote:
> Not the way he does it :-)
>
> If you use "--databases", mysqldump will add "create datab
Not the way he does it :-)
If you use "--databases", mysqldump will add "create database" and "use
database" statements. if you specify the db without that parameter, it
won't.
On Mon, Sep 20, 2010 at 11:34 AM, Ananda Kumar wrote:
> The dump file has to be edited to replace old db name to the n
The dump file has to be edited to replace old db name to the new db name.
regards
anandkl
On Mon, Sep 20, 2010 at 3:00 PM, Uwe Brauer wrote:
> Hello
>
> I would like to clone a database db_org to db_clone on the same machine.
> Could
> I use the dump command for this? Should the user of both db
Hello
I would like to clone a database db_org to db_clone on the same machine. Could
I use the dump command for this? Should the user of both db
be the same?
Something like
# mysqladmin create db_clone -u DB_user
mysqldump -p db_org > clone.sql
mysql -p -D db_clone < clone.sql
thanks
Uwe Brau
Any ideas why my statement like SELECT SHA1('abc') AS my_sha is being
returned as binary value, I thought it should be returning HEX in anycase ?
I'm using MySQL community server 5.1.43, with Innodb tables.
Cheers
Neil
On Sat, Sep 18, 2010 at 10:43 AM, Johan De Meersman wrote:
> hex() and unhex
18 matches
Mail list logo