';
I'll bet it's some giant number so the slave just doesn't realize that
it's lost its connection.
...Todd
--
The total budget at all receivers for solving senders' problems is $0.
If you want them to accept your mail and manage it the way you want,
send it the way the
a cronjob that's
telling it to shut down. Please check that before deciding it's a
memory or file issue.
...Todd
--
Always code as if the guy who ends up maintaining your code will be a
violent psychopath who knows where you live. -- Martin Golding
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
> 1 row in set (0.00 sec)
And THAT was what I expected. Thank you so much for clearing that up.
...Todd
--
Always code as if the guy who ends up maintaining your code will be a
violent psychopath who knows where you live. -- Martin Golding
--
MySQL General Mailing List
For list archives:
to print the check mark and the first one to
have the problem because there is no heavy check mark in latin1. What
am I missing, why is it printing out the correct value "using latin1"
but not "using utf8" ?
...Todd
--
Always code as if the guy who ends up maintaining your cod
e data is important and have a budget for recovery, you can try
(whatever solution is local for you) hiring a consultant skilled in
mysql crash data recovery:
- Oracle
- Percona
- SkySQL
Regards...Todd
--
SOPA: Any attempt to [use legal means to] reverse technological
advance
On Wed, Jan 25, 2012 at 6:42 AM, Todd Lyons wrote:
> For example, I shut down my mysql daemon, I make a copy of my
> corrupted database at /var/lib/mysql/ into /var/lib/mysql_tmp/, and
> then manually start the mysql daemon in the foreground with this:
> su - mysql -c '/u
--datadir
/var/lib/mysql_tmp/'
It simply sounds like you need to find the appropriate value to use to
make your data accessible.
Regards... Todd
--
SOPA: Any attempt to [use legal means to] reverse technological
advances is doomed. --Leo Leporte
--
MySQL General Mailing List
F
.0086
> seconds' at the bottom). I have many ODBC clients accessing this server as
> well, they all have slowness problems too.
>
> I'm stumped. What could possibly be causing this issue?
Wild Guess: Does DNS resolution, especially reverse dns resolution,
still work o
able
slows things down tremendously, so it isn't the best fit in this case.
...Todd
--
If Americans could eliminate sugary beverages, potatoes, white bread,
pasta, white rice and sugary snacks, we would wipe out almost all the
problems we have with weight and diabetes and other metabolic
di
259 487727085
which of course confirmed the log position I determined in step #12.
To be honest, the biggest step in the sequence above is likely #8.
The ability to assess a situation without freaking out (for too long)
is a big part of a sysadmin job IMHO.
Regards... Todd
--
If Amer
fields in the
key (i.e. a covering index) does it still choose what you consider to
be the wrong key?
--
Regards... Todd
I seek the truth...it is only persistence in self-delusion and
ignorance that does harm. -- Marcus Aurealius
--
MySQL General Mailing List
For list archives: http:
e
of the machines that you're ssh'ing to.
# my workstation has ForwardX11=yes in ~/.ssh/config
ssh host1
# then from there:
ssh -X host2
On host 2, running a gui app pops it up on my local desktop.
--
Regards... Todd
I seek the truth...it is only persistence in self-delusion and
igno
ter, the slave should
timeout after only 5 minutes and then resume replication.
--
Regards... Todd
I seek the truth...it is only persistence in self-delusion and
ignorance that does harm. -- Marcus Aurealius
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
s wanting to split the load onto 3 machines.
When you restarted the stress test, did it access new tables or the
same ones that the previous stress test did? What happens if you tell
innodb to use less memory and do your tests? Have you found any way
to make mysql not run out of memory?
--
Regards.
Simple - brilliant. I've modified to cat a temporary script...
1) cat the file as suggested:
cat > ~/payload/scripts/create_mysqldb.sql << EOF
###---
### Display the current user
###---
create database puppet;
###---
### Display all default accounts
###---
USE puppet;
###---
### Remove anonym
ASSWD_PRIV_ROOT') WHERE
User = 'root';
exit
---
It all works pretty well. Variable expansion is the problem. For now all
of my other scripts substitute $PASSWD_PRIV_ROOT (from my
1_GLOBAL_ENV.sh) for the actual password. The *.sql scripts do not.
If anyone can shed some light on
hlocalhost < file_with_allsql_you_need.sql
or
cat file_file_with_allsql_you_need.sql | mysql -u root -hlocalhost
and you are done.
On Tue, Jul 27, 2010 at 3:56 PM, Todd E Thomas
mailto:todd_...@ssiresults.com>> wrote:
I'm looking for automation direction...
I've found many packages that
7;admin'@'localhost' IDENTIFIED BY 'admin-password';
If there is a better way to do this than using expect I would greatly
appreciate any pointers in the right direction. Bash is comfortable for
me and perl is within reach. I'm not much versed in anything else rig
. At least in my testing so far, I've not
hit a timeout or received an incorrect OK or FAILED message in the
5.1.x series.
--
Regards... Todd
The best thing about pair programming is that you have the perfect
audience for your genius. -- Kent Beck
--
MySQL General Mailing List
For lis
sibly erroneous
assumption that if you were using foreign keys, when you switched to
MyISAM you wanted to continue to use foreign keys. Without the op
saying one way or the other, Michael's answer is more correct than
mine.
--
Regards... Todd
--
MySQL General Mailing List
For
databse, will I be avail to uploaded into
> a myisam
> database and will it work?
Depends. If you use foreign keys in innodb, then you cannot import
that into myisam because myisam does not support foreign keys. If you
do not use foreign keys, it should work.
--
Regards... Todd
--
MySQL
or because you have some issue
or problem with xtrabackup? I'm not aware of any show-stopper bugs.
I'm just curious, because it works well for us. The backup is online
with the only lock held occuring while it's copying over the *.frm and
*.MY* files, which is not very much for
some other machine on the same LAN, give it the bogus IP with
the same netmask.
3. No need to worry about routes, it's on the same LAN.
4. On the other machine, connect using 'mysql -h10.200.100.10 -uroot
-p'. When you enter the correct password, it should let you in.
* I don't
NGINE = MyISAM
Repeat for each table. Script it if it's more than a few tables.
Note that foreign keys will break if your InnoDB table uses them.
--
Regards... Todd
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
all sequentially in a row in short order. Look at your cron jobs that
start or end around the time that all those "empty" binlogs are being
created.
--
Regards... Todd
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
not being fair is someone expecting me to do their work for them just
so they can receive emails from a public list that they joined.
Regards... Todd
On Wed, Jul 15, 2009 at 10:20 AM, wrote:
> Hello Todd Lyons,
>
> I use Boxbe to protect my email address. While I did receive your e
a, not just the
ibdata and iblog files. Just make sure that your innodb settings in
my.cnf match.
--
Regards... Todd
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
or buffer setting that will explain the sudden drop
in speed.
--
Regards... Todd
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hi All,
I want to create a table that defaults to current_date and current_time.
I have:
CREATE TABLE `personalevent`(
`pevent` mediumint(10) NOT NULL,
`eventid` mediumint(10) NOT NULL,
`userid` mediumint(10) NOT NULL,
`username` varchar(10) NOT NULL,
`pa
!
-Jason
On Apr 29, 2009, at 1:20 PM, mark konetchy wrote:
Jason,
It looks like mysql is erroring out when you try to start it from
the command line. What does the error log say?
2009/4/29 Jason Todd Slack-Moehrle
OK, I have done this:
[r...@server1 ~]# mysqld_safe
A mysqld process
ysqld_safe --init-file=clouds.sql &
(or whatever the path to mysqld_safe is)
2009/4/29 Jason Todd Slack-Moehrle
Hi Guys,
i am still lost here:
GRANT ALL ON mysql.* TO 'root'@'localhost' IDENTIFIED BY 'XXX';
GRANT ALL ON mysql.* TO 'root'@'173.
Hi Guys,
i am still lost here:
GRANT ALL ON mysql.* TO 'root'@'localhost' IDENTIFIED BY 'XXX';
GRANT ALL ON mysql.* TO 'root'@'173.8.172.53' IDENTIFIED BY 'XXX';
FLUSH PRIVILEGES;
Here is the command that I am executing:
[r...@server1 ~]# /etc/init.d/mysqld restart --init-file=~/cloudsql.sql
at I am doing wrong...
-Jason
On Apr 28, 2009, at 5:34 PM, mark konetchy wrote:
hey jason,
you need to restart the *server* with the init-file option, have a
look at:
http://dev.mysql.com/doc/refman/5.0/en/server-options.html
2009/4/28 Jason Todd Slack-Moehrle
I am trying to st
I am trying to start MySQL with --init-file but i get that it is an
invalid option. the 'man' page and --help dont help me decide what is.
Here is what I am doing:
r...@server1 ~]# mysql start --init-file = cloudsql.txt
mysql: unknown option '--init-file'
Thoughts?
-Jason
--
MySQL General M
Hi All,
CentOS 5.3
I installed MySQL Server via yum and started it.
I tried entering:
mysqladmin -u root password yourrootsqlpassword
mysqladmin -h server1.example.com -u root password yourrootsqlpassword
But I get:
r...@server1 ~]# /usr/bin/mysqladmin -u root -h localhost password
mypassw
tern) /
> 14:00 BST / 15:00 CET / 17:00 MDT (Moscow) How to Use Charsets and
> Collations Properly Susanne Ebrecht
A quick reminder, in the U.S. we're in daylight savings time now, so
those times are 7AM PDT / 8AM MDT / 9AM CDT / 10AM EDT. Ultimately
though, you can't go
r/lib
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[mysqldump]
quick
--
Regards... Todd
All truth passes through three stages. First, it is ridiculed. Second,
it is violently opposed. Third, it is accepted as being self-evident.
--
MySQL General Mailing
Hi All,
On OS X, I have some Obj-C that creates NSTasks to execute some sql
statements.
What do I deploy on the client to make this work for them? I want to
make it park of my package installer, but I dont know what pieces.
Thoughts?
-Jason
--
MySQL General Mailing List
For list archiv
> -Original Message-
> From: Per Jessen [mailto:[EMAIL PROTECTED]
> Sent: Saturday, June 14, 2008 6:23 AM
> To: mysql@lists.mysql.com
> Subject: RE: what is the proper way to store timezone information?
>
> Boyd, Todd M. wrote:
>
> >>
> >> When
From: Jim Lyons [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2008 12:10 PM
To: Boyd, Todd M.
Subject: Re: natural sort via substrings
What I would do is form 2 additional fields from the first, an alphanumeric
field and a numeric field so:
jane-2 jane- 2
alex 3 alex 3
> -Original Message-
> From: Emily Heureux [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 13, 2008 11:12 AM
> To: Boyd, Todd M.; mysql@lists.mysql.com
> Subject: RE: natural sort via substrings
>
> Hi, I am sorry for being so vague. The values are not as simple as
&
the query should not assume the table list of the database.
>
> Thanks for any inputs
Is "SELECT COUNT(*) FROM *" too open-ended?
BTW... do you want the number of records per table, or number of tables
per database??
Todd Boyd
Web Programmer
--
MySQL General Mailing List
Fo
(an immediate "I'm probably a *nix package" flag) releases. I'll bet you
can compile it yourself on *nix. (The article I've linked to also talks
about using Sphinx in BSD distros.)
Hope that helps,
Todd Boyd
Web Programmer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> -Original Message-
> From: Boyd, Todd M. [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 13, 2008 10:33 AM
> To: Emily Heureux; mysql@lists.mysql.com
> Subject: RE: natural sort via substrings
---8<--- snip
> Forgive me if I am incorrect, but wouldn't "ja
#x27;s easier (or perhaps more efficient, if this is a concern) for
you to simply store the time_zone_id value, then do it that way. It's not as if
it won't store your data if you store the time_zone_name... it just might be
harder to use as a variable later, being text instead of an identifying number.
Again... totally a matter of your preference.
Todd Boyd
Web Programmer
ubstring_index() sort all "jane##" entries arbitrarily, since your
(theoretical) example returns everything to the left of the first match
(but not including the match)?
Todd Boyd
Web Programmer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
different collation (one
without case sensitivity, eh?) in the other table...
As I don't deal with letters/characters outside of the 'standard'
Latin-iso-asdfasdf collation, I'm afraid there's not much else I can
explain using my limited knowledge.
Hopefully, though, tha
From: Ananda Kumar [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2008 10:27 AM
To: Boyd, Todd M.
Cc: mysql
Subject: Re: enable and disable keys
/tmp has 16GB free space
On 6/12/08, Boyd, Todd M. <[EMAIL PROTECTED]> wrote:
> -Original Message-
> From: Ananda Kumar [m
ing"
> >>
> >> What could be the problem.
> >>
> >> System has 8 cpu and 16GB RAM
> >>
> >> I have set myisam_max_sort_file_size=98GB
> >> myisam_sort_buffer_size=750MB.
> >>
> >> /tmp folder has 16GB free sp
needs to be
specified as case sensitive (with BINARY).
Could this be a similar issue, perhaps? One table is specifically
case-insensitive with regard to the function, and the other is not?
Just spit-balling...
Todd Boyd
Web Programmer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
7;. Just confirming that your command does seem correct,
dunno why it's not working for you.
- --
Regards... Todd
when you shoot yourself in the foot, just because you are so neurally
broken that the signal takes years to register in your brain, it does
not mean that your foot does
Hi All,
I have a client that wants to insert data into a VarChar field that contains
commas. These are property addresses.
Example:
2966 Moorpark Ave, San Jose, CA, 95128
1 Infinite Loop, Cupertino, CA, 95
How can I allow this?
Thanks!
-Jason
n I want a daemon to read that relay-log and replicate
those commands into a local BDB database. The reason is for maximum
speed.)
- --
Regards... Todd
we're off on the usual strange tangents. next will be whether
it is ethical to walk in your neighbor&#
ould kickstart the replication
process) because it hits the timeout rather quickly.
Of course this doesn't address potential errors with the Slave SQL
Thread, but that is known.
- --
Regards... Todd
There are four boxes to be used in defense of liberty:
soap, ballot, jury, and
27;
Unknonwn whether other engines obey the same rules and methods.
- --
Regards... Todd
Chris: grep 500 sendmail.mc
undefine(`FAIL_MAIL_OVER_500_MILES')dnl
Chris: just in case ...
Linux kernel 2.6.22-14-generic 3 users, load average: 0.00, 0.00, 0.00
-BEGIN PGP SIGNATURE--
that the
innodb space is full. I know that the space isn't full because it is still
working. I am wondering how I can get a true size of the space used. I
would like to get back into the 2G segments. Any suggestions.
Todd
--
MySQL General Mailing List
For list archives:
SELECT * FROM user WHERE User = 'user1' I do get
results. Could the user have been added using an insert causing the SHOW
GRANTS to fail?
Any Ideas
Todd
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ay to parse binary logs and recover from them, but is
there a way to do the same for text logs? I think I can write a bash
script to reformat the file into a series of queries, but I was hoping
there was an easier way.
Thanks so much, anyone willing to help.
Todd Ellison
--
MySQL General Ma
todd hewett wrote:
>>>mysql> INSERT INTO BOARD_SERIAL_NUMBER (BOARD_SERIAL_NUMBER)
>>>mysql> VALUES(36534);
>>>
>>>ERROR 1216: Cannot add a child row: a foreign key constraint fails
>
>
>>Can you please post the output of:
>
>
--
----+
1 row in set (0.02 sec)
Thanks again for your help in get
as unknown
columns.
Any other ideas out there?
Thanks Todd
mysql> INSERT INTO VCS_PO_NUMBER (VCS_PO_NUMBER) VALUES(899234);
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO BOARD_SERIAL_NUMBER (BOARD_SERIAL_NUMBER)
mysql> VALUES(36534);
ERROR 1216: Cannot add a c
CB_MANUFACTURER (PCB_MANUFACTURER_COMPANY_NAME)
VALUES(A);
ERROR 1064: You have an error in your SQL syntax near 'INSERT INTO
BOARD_SERIAL_NUMBER (BOARD_SERIAL_NUMBER) VALUES(36534),
INSERT INTO' at line 2
Any help ideas recommendations are appreciated.
Thanks,
Todd
;sfyc" does show
in the table, "db".
Todd
Chris wrote:
Did you run the statement witht he mysql database as the current
database? If so , you're statement probably got converted to this:
grant all on mysql.* to todd identified by 'my_password' with grant
option;
I have created a table, "sfyc" and as root I issued the following:
grant all on * to todd identified by 'my_password' with grant option;
However, "todd" cannot access "sfyc" with
mysql -u todd -p sfyc
And the mysql db contains the following:
user table
thank you again!
Todd
Michael Stassen wrote:
Todd Cary wrote:
Unfortunately, I blew MySQL away by replacing the MySQL control
tables with others and not making a copy of the folder.
My data is backed up, so that is not a problem, but I cannot
reinstall MySQL and create the mysql directory
t;yum remove mysql" and "yum install mysql" and
"yum install mysql-server" and the control files are not recreated.
Any suggestions?
Todd
--
Ariste Software
200 D Street Ext
Petaluma, CA 94952
(707) 773-4523
--
MySQL General Mailing List
For list archives: http://lists.
Thanks Gleb,
That was educational.
Is there a way to log connections in such a way that is easy to tell how
many connections were happening at one time?
Thanks,
Todd
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 12, 2005 12:26 AM
To: mysql
ql and it has been ran fine.
After that I've increased max_connections limit in /etc/my.cnf and app runs
fine.
Is there a way to determin what connectiions to MySQL are being used by whom?
Thanks,
Todd
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
uch a beast exist?
---
Todd Gruben
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I've tested mysql in my high school lab running from an administrator
and from a student account, both from within the Cygwin terminal, and
at the Windows command prompt. From the administrator account, it runs
fine for hours. From the student account, it promptly (within 15
seconds or so) cras
x27;m going to try
running MySQL from the Windows command prompt today to see if that
makes a difference.
Thanks,
Todd
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
e GUI tool had no choice but to create "new"
foreign keys with the same name appended with the number 1. The end
result... total chaos. Fixed it though. I really appreciate your help.
Todd
On Aug 30, 2004, at 6:20 AM, [EMAIL PROTECTED] wrote:
Foreign keys are used to enforce foreig
ows XP Professional machines, and the students log
into a
domain hosted by a server in another teacher's lab.
Any ideas appreciated,
Todd
P.S. If you could cc me any replies, I'd appreciate it, since I read
the list on
digest.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
le set secretinfo="blah" where ID_Num=2;
So far as I've been testing this seems to work while preventing the user from
ever selecting what's in the other secrettable columns.
Thanks again!
Todd
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
Thinking about this some more, it might be possible to achieve what my last
email suggests by allowing select on the primary key column. Or would that
set us back again? Thoughts?
Todd
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
(encrypted or not) cannot be
retrieved via that account, only overwritten.
>
> UPDATE secrettable SET column = 'value';
>
> DELETE FROM secrettable;
>
That may be possible, but I can't really see anywhere where that would be
useful.
Thanks.
Todd
--
MySQL Gene
>
Thanks for all your help. This may be the best solution available. Would it
be possible to get it posted to a faq or mentioned in the docs? I imagine
it's a situation that may come up frequently for users.
Also, if you have any ideas on how one might perform updates on specific
en I update the record it
attempts to enter data (NULL) into these fields which are child rows.
Can someone explain what I should do? Should I just change these fields
of data into NULL? I'm literally just trying to populate the tables
with enough data to run some test queries.
Any suggest
This is just my guess, I am still too new to know for sure, but I would say
php can do what ever the user that is logging in can. phpMyAdmin will
create databases, and it is just a PHP Script.
Todd Hackathorn
-Original Message-
From: Elly Wisata [mailto:[EMAIL PROTECTED]
Sent
e.
The thing is you have to tell the client browser it is a type of file that
it recognizes.
Hope that helps, good luck.
Todd Hackathorn
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, March 15, 2004 2:33 PM
To: [EMAIL PROTECTED]
Subject: need t
, It is labeled Libraries and header files,
this put both the old version and the new version. When I found this error
I searched all the forums and everyone had very complex(at lease for me)
ways of recompiling mySQL. But, just installing this rpm fixed it for me.
Good Luck,
Todd Hackathorn
to use it
instead. Also I am still learning mySQL and RedHat so don't need anything
more complex that it has to be. I am used to just installing it and away I
go, now I have all these different options.
Thanks in advance.
Todd Hackathorn
Is there any way to iterate thru the keys in a fulltext index? This issue
does not come up for other indexes since ORDER BY can achieve this:
For example if table t is indexed on part_id
SELECT DISTINCT part_id FROM t ORDER by part_id;
will return all keys in index order
Is there a way to do
abase
server? To make two connections and pull data from one to the other?
Thanks,
Todd Hackathorn
-Original Message-
From: Rhino [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 04, 2004 8:30 AM
To: HACKATHORN, TODD (SWBT); [EMAIL PROTECTED]
Subject: Re: Scripting
Todd,
I'm also
get going with this. So far
the graphical packages for updates are the only thing I miss from SQL
Server.
Thanks in advance for any help.
Todd Hackathorn
fairly large
tables. I am new to both Linux, and mySQL, but do have a decent amount of
experience in other SQL system.
I am using RedHat 9, mySQL Ver 12.22 Distrib 4.0.18, for pc-linux (i686).
Thanks in advance,
Todd
Is there any way to disable replication of all temp tables using
replicate-ignore-table or some other means? The names of the temp tables
are generated randomly by a script. Thanks
Todd
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Dan -
Or from my place, "It pays for me to read the docs - thoroughly". Oh!
Docs! What are they? :-[
Todd
Dan Greene wrote:
The most guarenteed way to have a feature in a product pointed out is to make a public statement that it's not available :)
keyboard in mout
John -
Right under my nose! Thanks
Todd
John Griffin wrote:
Look at http://www.mysql.com/doc/en/mysql.html. The -X option may give you what you need.
-Original Message-
From: Dan Greene [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 01, 2003 9:57 AM
To: Todd Cary; Jay
Jay -
I am not an expert with XML, however I use it with Delphi and Delphi's
TClientDataset. In this usage, I use the builtin SaveTo and LoadFrom
methods.
Todd
Jay Blanchard wrote:
[snip]
Is there a way to export/import MySQL tables in XML format?
[/snip]
Well Todd, it is a little
Is there a way to export/import MySQL tables in XML format?
Todd
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I tried installing MySQL on Fedora and all seemed to go fine, but there
is no mysqladmin. Have I missed something here?
And I am not sure where the mysql executable resides. The version is
MySQL-3.23.58-1.i386.rpm
Todd
--
<>
rement
column.
See http://www.php.net/manual/en/function.mysql-insert-id.php
todd[1]
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.1 (GNU/Linux)
iD8DBQE/hd7v9xvMmfxCaFkRAsoZAJ9eL5aQf0dCHwY/nFdH5vQIny0BrgCgrcI3
V64M7/8+BnyHjJLlzYvG1C4=
=MFdB
-END PGP SIGNATURE-
--
MySQL General Mailing Lis
I cannot tell from the Reference Manual whether the table cache is used with
the InnoDB database engine or not? It sounds like it only applies to tables
that are stored in separate disk files. Is the table cache used by InnoDB?
Bill
--
MySQL General Mailing List
For list archives: http://lists
Using MySQL and InnoDB, are there system tables or other tools that I can
use to see which statements that are executing have consumed the most CPU
time and find out which user, transaction and/or connection those statements
belong to?
If I identify a user that is causing a problem is there a way
I know, I know, with database servers more is always better. However,
assume I need to deploy MySQL using InnoDB to multiple sites. Hardware cost
is a significant consideration. Is there any information available on
MySQL's memory requirements? Most database vendors give you something as a
starting
; From: Heikki Tuuri [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 08, 2003 10:44 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Do InnoDB rollback segments expand dynamically?
>
>
> Bill,
>
> - Original Message -
> From: ""Bill Todd"" <
Using InnoDB with an autoextend tablespace, if I start a transaction that
results in many record versions, will the rollback segments grow dynamically
and force the tablespace to grow dynamically to provide the required room
for record versions in the rollback segments?
Bill
--
MySQL General Ma
Since InnoDB does not allow phantom reads with Repeatable Read isolation
(which are allowed in the ANSI SQL definition of Repeatable Read) what is
the difference between these two isolation levels. Is it just serialization
and that is all?
Bill
--
MySQL General Mailing List
For list archives: h
What transaction isolation level(s) does BDB support? I can't find any
information on BDB transactions section 7.6 of the manual.
Thanks,
Bill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1 - 100 of 296 matches
Mail list logo
