Dear Admin,
I would like to share and get inputs from experts on MYSQL Db.
I request you to grant access to me.
Thank you
Regards,
Vikki A
Your Mail works best with the New Yahoo Optimized IE8. Get it NOW!
http://downloads.yahoo.com/in/internetexplorer/
Rudy Lippan wrote:
On 01/29/2010 02:57 PM, Chris W wrote:
Hardcore stupid if you ask me. I suppose it is "possible" to have a
valid reason (can't imagine what it might be) for using more than 61
How about complex data requirements? Depending on the resolution of
your data set, I could see a
On 01/29/2010 02:57 PM, Chris W wrote:
> Hardcore stupid if you ask me. I suppose it is "possible" to have a
> valid reason (can't imagine what it might be) for using more than 61
How about complex data requirements? Depending on the resolution of
your data set, I could see a "simple" person-ty
Thanks for the suggestions but I couldn't find any that suited my needs, so I
made my own. Feel free to download if you can use them, I made files with up to
a million unique records.
Name, Company, Address, Phone, Email, etc., all are fake but are real addresses
with correct area codes, zips,
*Hi JS,*
I never see socket file on MS Windows...are you sure about it? But, the
other question is "*yes*", if you make a connection with the MySQL Server
(mysqld) using -h localhost, you will connect with the server using a socket
file (linux only), but, if you make using -h 127.0.0.1, TCP/IP wil
... or 50 ways to leave your Oracle...
... or 50 ways to save your money...
Choose mysql! :)
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arc
as a relatively unsophisticated dbms user (just dynamic web site back
end),
i thought it was very interesting to see the kinds of things oracle users
do
that i'd never have imagined.
more than 61 joins in a query?! man, those guys are hardcore.
Hardcore stupid if you ask me. I suppose it i
At 01:57 PM 1/29/2010, Chris W wrote:
fsb wrote:
as a relatively unsophisticated dbms user (just dynamic web site back end),
i thought it was very interesting to see the kinds of things oracle users do
that i'd never have imagined.
more than 61 joins in a query?! man, those guys are hardcore.
fsb wrote:
as a relatively unsophisticated dbms user (just dynamic web site back end),
i thought it was very interesting to see the kinds of things oracle users do
that i'd never have imagined.
more than 61 joins in a query?! man, those guys are hardcore.
Hardcore stupid if you ask me. I
>-Original Message-
>From: Mark Goodge [mailto:m...@good-stuff.co.uk]
>Sent: Friday, January 29, 2010 10:32 AM
>To: mysql@lists.mysql.com
>Subject: Re: Good source for sample data?
>
>On 29/01/2010 15:20, Jerry Schwartz wrote:
>> [JS] Sorry, my suggestion won't work either: I didn't noti
>-Original Message-
>From: Anand kumar [mailto:anand@gmail.com]
>Sent: Friday, January 29, 2010 4:36 AM
>To: Suresh Kuna
>Cc: muralikrishna g; mysql@lists.mysql.com
>Subject: Re: how to dump database or tables
>
>it should be windows.. .
>
[JS] This will get you backed up...
=
REM -
I need a few million sample contact records - name, company, address,
email, web, phone, fax. ZIP codes and area codes and street addresses
should be correct and properly formatted, but preferably not real people
or companies or email addresses. But they'd work if you did address
validation or
On 29/01/2010 15:20, Jerry Schwartz wrote:
That's brilliant. The only minor issue is that, at least for UK data, it
won't validate for mapping purposes - the postcodes are syntactically
correct, but non-existent. I don't know if it would have the same
problem for US or Canadian data.
[JS] Sorr
25. Each table can have a different storage backend (”storage engine”).
Yes, we absolutely allow this.
Each engine brings a certain strength to the storage and retrieval
solutions you can create with MySQL. We explicitly recognize that there is
no "one size fits all" approach that meets the ne
>
>That's brilliant. The only minor issue is that, at least for UK data, it
>won't validate for mapping purposes - the postcodes are syntactically
>correct, but non-existent. I don't know if it would have the same
>problem for US or Canadian data.
>
[JS] Sorry, my suggestion won't work either: I di
Hello Brian,
We have a tool that can generate these kind of data, if you want
real data (like the ZIP-codes), you can supply it yourself and
use non-existent company names and al.
Have a look at www.upscene.com and go to "Advanced Data
Generator".
With regards,
Martijn Tonies
Upscene Productio
If you need "verifiable" mailing addresses (actual street/city/state/zip
combinations), you should look at some of the databases the USPS (usps.com)
has available. They are mostly for tracking delivery statistics, and the like,
but as a side effect they list streets all over the USA. The only th
Hmmm... I find it suspicious that there are *exactly* 50 things you need to
know before migrating from oracle to mysql. Not 49. Not 51. Exactly 50.
Well, he did repeat that clustering is not what you think it is so I guess
it technically is 49. But I wonder what would happen if he thunk up a 5
From: Wagner Bianchi [mailto:wagnerbianch...@gmail.com]
Sent: Thursday, January 28, 2010 2:03 PM
To: Jerry Schwartz
Subject: Re: WAMP vs LAMP
[JS] The file paths were all the same, actually, and the address for MySQL is
just “localhost”.
[WB]Consider to use MySQL on Unix like environment bec
On Fri, Jan 29, 2010 at 9:52 AM, Cui Shijun wrote:
> I'm using innodb engine. There are more and more rows in my table
> recently, and
> I've planned to extend the structure.
>
Why do you want to split your table ? What problems are you trying to solve
?
--
Bier met grenadyn
Is als mosterd
On 1/28/10 5:21 AM, "changuno" wrote:
> Hi folks,
>
> Read a blog which states 50 things to know before migrating from Oracle to
> MySQL. Any comments on this?
as a relatively unsophisticated dbms user (just dynamic web site back end),
i thought it was very interesting to see the kinds of thing
Given that you're talking about "quite a few" folders, I think it'd be good
to check up on the theoretical and practical limits for your filesystem of
choice, though - ext2 for example starts getting noticeably slower when you
have a lot more than 10.000 entries in the same directory. One way of
ge
On other SGBDs you can issue:
sqlplus> conn other_user;
But, using MySQL you can't do it...start new connection.
--
Wagner Bianchi - Web System Developer and Database Administrator
Phone: (31) 8654-9510 / 3272-0226
E-mail: wagnerbianch...@gmail.com
Lattes: http://lattes.cnpq.br/2041067758113940
*Make a backup of yours databases:*
shell> mysqldump -u -p --all-databases -e > path/file.dmp
Implicit to this command quoted above, you will have the --opt option (
shorthand for --add-drop-table --add-locks --create-options --disable-keys
--extended-insert --lock-tables --quick --set-charset )
it should be windows.. .
On Fri, Jan 29, 2010 at 2:29 PM, Suresh Kuna wrote:
> Which OS your are using ?
>
> Suresh Kuna
> MySQL DBA
>
> On Fri, Jan 29, 2010 at 2:25 PM, muralikrishna g
> wrote:
>
> > i am working on my pc with mysql-5.0.27-community-nt
> >
> > i have created several data bases a
Which OS your are using ?
Suresh Kuna
MySQL DBA
On Fri, Jan 29, 2010 at 2:25 PM, muralikrishna g
wrote:
> i am working on my pc with mysql-5.0.27-community-nt
>
> i have created several data bases and tables in that.. to take backup, we
> have to use dump., i dont know the correct syntax how to
Hi Murali,
We can switch to another user only by a new connection and not possible in
mysql prompt.
Thanks
Suresh Kuna
MySQL DBA
On Fri, Jan 29, 2010 at 2:24 PM, muralikrishna g
wrote:
> i am working on my pc with mysql-5.0.27-community-nt
> i have created users by using create user and i given
i am working on my pc with mysql-5.0.27-community-nt
i have created several data bases and tables in that.. to take backup, we
have to use dump., i dont know the correct syntax how to use dump to take
backup to a specific location., after that how to resore. please help me
regarding this.
thanks i
i am working on my pc with mysql-5.0.27-community-nt
i have created users by using create user and i given some privileges, but i
dont know how to switch between users on mysql command line, please help me
regarding this..
thanks in advance
hi,
I'm using innodb engine. There are more and more rows in my table
recently, and
I've planned to extend the structure.
Assume I have testdb, the database, and testTab, the table, in ONE mysql.
There are two ways:
* extend via table, that is,
testTab -> testTab_1
->
On 29/01/2010 03:18, John Meyer wrote:
If I may recommend:
http://www.generatedata.com/#download
That's brilliant. The only minor issue is that, at least for UK data, it
won't validate for mapping purposes - the postcodes are syntactically
correct, but non-existent. I don't know if it would h
Thanks a lot.
On Fri, Jan 29, 2010 at 8:50 AM, Carlos Proal wrote:
>
> Krishna
> I dont have any benchmark but you can take a look on the Cafepress
> presentation that includes some data (or ask the authors for deep reference)
>
> http://assets.en.oreilly.com/1/event/2/Horizontal%20Scaling%20with
32 matches
Mail list logo
