Thanks a lot.
On Fri, Jan 29, 2010 at 8:50 AM, Carlos Proal carlos.pr...@gmail.comwrote:
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)
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
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
-
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
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
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
muralikrishn...@gmail.comwrote:
i am working on my pc with mysql-5.0.27-community-nt
i have created users by using
Which OS your are using ?
Suresh Kuna
MySQL DBA
On Fri, Jan 29, 2010 at 2:25 PM, muralikrishna g
muralikrishn...@gmail.comwrote:
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
it should be windows.. .
On Fri, Jan 29, 2010 at 2:29 PM, Suresh Kuna sureshkumar...@gmail.comwrote:
Which OS your are using ?
Suresh Kuna
MySQL DBA
On Fri, Jan 29, 2010 at 2:25 PM, muralikrishna g
muralikrishn...@gmail.comwrote:
i am working on my pc with mysql-5.0.27-community-nt
*Make a backup of yours databases:*
shell mysqldump -u user -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
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
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
On 1/28/10 5:21 AM, changuno chang...@rediffmail.com 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
On Fri, Jan 29, 2010 at 9:52 AM, Cui Shijun rancp...@gmail.com 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
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
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
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
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
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 didn't
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
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]
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
-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 - This
-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:
snip
[JS] Sorry, my suggestion won't work either: I didn't notice
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
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.
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
... 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:
*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 will
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,
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-type
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
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/
32 matches
Mail list logo
