Hi Brad,
I don't expect that you will specifically remember me, but we have had "tech
help" emails back and forth in the past regarding my sites at Zettai.net.
I'm unable to locate a "zettai" email for you (not even sure if you are
still affiliated with Zettai) so have found this address from Goo
Nikita,
Try somehting like this:
mysql -hHOST -uUSER -pPASS -s -e'show tables' DATABASE | \
tail +1 | \
while read TABLE
do
echo == $TABLE ==
mysql -s -pwmihp -e"describe $TABLE" articles | sort
Done
I used the "tail +1" to trim out the header row -- tho I think there is
an optio
Thanks for the information.
I want to make sure that I understand: Do you run ALTER TABLE command
on a live database(table) that is doing inserts;
Or, do you stop accepting Remote connections, flush the tables, run the
ALTER TABLE command,
start accepting connections?
Thank you,
Raymond
-O
Greetings,
Does anyone know how I can set up my shell so that the mysql command works
without navigating to the directory? I am using Mac OS 10.2.8 and 10.4
shell> mysql u name p
??
Thanks,
--
Steve Marquez
Thanks, Douglas!
That seems OK, but I'd prefer to avoid altering the schemas in any way.
In particular altering order of constraints seems error-prone, given
that one is essentially re-defining these, not simply rearranging the
order. Am I asking for impossible? ;-
-nikita
Douglas Sims wrot
One way you could solve this is to conform the column orders between
the two versions.
For example, if one table, t6, has columns id, name, and address and
the same table in the second database is id, address, name, you could
just ALTER the second database t6 table to be id, name, address:
Hi,
I'm diffing two versions of a schema produced using mysqldump and would
like to know if there's a way to make mysqldump sort entries inside
CREATE statements (say alphabetically or in some other way)? Currently
some of the column declarations are juxtaposed between the versions and
thus p
A couple questions since I'm not a Solaris person I really don't know how to
do the following and was hoping that someone could help me out (Google isn't
much help on this).
How does one start the MySQL daemon on Solaris 8? (it's running MySQL
3.23.49)
How does one tell Solaris 8 to start the MyS
Jerry Schwartz wrote:
An employee of a financial institution realized a similar vulnerability in
their systems. It was common to calculate batch totals, which were cross
checked to make sure that no transactions went astray, but he realized that
so long as the batch totals came out right you coul
Two famous (if apocryphal) stories and a more serious contribution:
A bank decided that it would truncate, rather than round, when doing
interest calculations. They decided that no one would ever miss the average
half-cent. They reckoned without all of the people who had certificates that
paid exa
Hi All,
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 configuration.
Machine used :
Sun netra 240 , dual processor mac
> > I've copied the data files in a flash memory and tried to
> see the tables
> [EMAIL PROTECTED] and then [EMAIL PROTECTED] wrote:
> > fields in another computer with the same server version and
> platform and
> > get the "db_name.tb_name table doesn't exist" error
> message. However when
>
On 9/8/06, Philippe Poelvoorde <[EMAIL PROTECTED]> wrote:
2006/9/8, Andrew W. Nosenko <[EMAIL PROTECTED]>:
> Sorry, but documentation on the MySQL C API say nothing about many
> interesting questions.
>
> The one of them: is it safe (or unsafe) to use non-MT client library
> (libmysqlclient.*, as
2006/9/8, Andrew W. Nosenko <[EMAIL PROTECTED]>:
Sorry, but documentation on the MySQL C API say nothing about many
interesting questions.
The one of them: is it safe (or unsafe) to use non-MT client library
(libmysqlclient.*, as opposite to the MT-aware libmysqlclient_r.*) for
the multithreadin
Sorry, but documentation on the MySQL C API say nothing about many
interesting questions.
The one of them: is it safe (or unsafe) to use non-MT client library
(libmysqlclient.*, as opposite to the MT-aware libmysqlclient_r.*) for
the multithreading programs in case when every parallel mysql
conne
Thanks. That works for me.
-Mensaje original-
De: Dan Nelson [mailto:[EMAIL PROTECTED]
Enviado el: jueves, 07 de septiembre de 2006 19:05
Para: [EMAIL PROTECTED]
CC: MySql Mail List
Asunto: Re: View hidden temporary files
In the last episode (Sep 07), [EMAIL PROTECTED] said:
> In http:/
Thanks. That works for me.
-Mensaje original-
De: Dan Nelson [mailto:[EMAIL PROTECTED]
Enviado el: jueves, 07 de septiembre de 2006 19:05
Para: [EMAIL PROTECTED]
CC: MySql Mail List
Asunto: Re: View hidden temporary files
In the last episode (Sep 07), [EMAIL PROTECTED] said:
> In http://
17 matches
Mail list logo