what I mean - very non-technical. Access is a very good tool
to give them, because they can produce ad-hoc reports to their heart's
content without having to ask the IT staff for assistance.
--
Ed Carp, [EMAIL PROTECTED] (850) 291-1563
Director, Software Development
Escapade Server-Si
On Thu, 16 Jan 2003 [EMAIL PROTECTED] wrote:
> sql,query,queries,smallint
--
Ed Carp, N7EKG http://www.pobox.com/~erc 214/986-5870
Licensed Texas Peace Officer
Computer Crime Investigation Consultant
Director, Software Development
Escapade Server-Side Scripting Eng
> How can i extract names of columns from table? I am doing select *
> from table, then i want to get name of columnsis it possible?
"show columns from XXX" where XXX is the name of the table.
sql, query
-
Before posting, pl
> is it a normal behaviour that a sql databases gets corrupted if
> the power of
> the whole system will be switched off while an application is
> writing to the
> database ?
Yes.
> what can i do that this problem does no more appear ?
Buy a UPS or shutdown the system normally. NEVER just turn
> corrupted. The most common error messages which I encountered are : "Can't
> open file: 'tablename.MYD'. (errno: 145)" and "Got error 127 from table
> handler".
> I rectified it by shutting down the MySQL Server and using "myisamchk"
> with the options -r and sometimes -o.
145 = Table was ma
> If one cannot avoid using PHP how can I secure it? I will
> initially have
> it on the same server as IIS.
There is a wrapper program that temporarily elevates PHP's permissions, so
that the PHP scripts don't have to be world-readable. Can't remember what
it is, offhand, though.
sql, query
> A quick question: Is phpmyadmin secure? Anyone have an negative
> experiences
> having it installed on their server?
PHP itself is not secure unless special steps are taken to secure it, and
even then it's no guarantee. There have been several exploits published
against PHP, and a few of them h
you can't use the C API function to retrieve the
value for LAST_INSERT_ID(expr) after executing other SQL statements like
SELECT or SET.
--
Ed Carp, N7EKG http://www.pobox.com/~erc
214/986-5870
Licensed Texas Peace Officer
Computer Crime Investigation Consultant
Director, Softwa
> does the mySQL always use the same port and which port
> would it be? Is it configured in a file?
Port 3306. I believe it can be changed via my.cnf and on the command line.
-
Before posting, please check:
http://www.mysql.c
> At 18:26 -0500 10/22/02, Ed Carp wrote:
> > > 021022 17:54:13 mysqld started
> >> 021022 17:54:13 bdb: PANIC: No such file or directory
> >> 021022 17:54:13 Can't init databases
> >> 021022 17:54:13 mysqld ended
> >
> >Have you
> 021022 17:54:13 mysqld started
> 021022 17:54:13 bdb: PANIC: No such file or directory
> 021022 17:54:13 Can't init databases
> 021022 17:54:13 mysqld ended
Have you tried all the obvious things before you posted?
> [mysqld]
> datadir=/var/lib/mysql
Is this directory exist - if so, what's
> > >If I type the following at the command prompt, in this
> example I'm using
> > >username for the user name, and 66.66.66.66 for the IP address
> > >(although I use real values)
> > >
> > >mysql -h 66.66.66.66 -u username -p
> > >
> > >it asks for my password then goes off and thinks for a whi
> is there a way to execute sql commands from a file?
> What would be the syntax to do it?
> I was trying mysql> @theFile, but it doesn't work.
mysql < thefile
-
Before posting, please check:
http://www.mysql.com/manual.php
> Marc Liyanage has been doing MacOS X binaries in Switzerland.
> When I lived there, they took month-long vacations, two-hour
> lunches, and frowned on weekend work. Maybe he has a life
> outside of MySQL? :-)
How do I get a job in Switzerland? ;)
sql, query
-
> Does anybody know how I can solve this problem?
> How can I improve the " opening " performance?
> Does MySQL cache something for each records?
It's not a MySQL problem, but a problem how you're opening the recordset.
In VB, you would set the DBSQLPassThru flag - I don't know what the
equivalent
> Thank you, but at this point I am pretty sure that my problem is not a
> matter of entries in the user table. When I attempt to telnet
> into port 3306
> the connection is immediately dropped. I don't really know if
> any connection
> is actually established at all, it may be established and imme
> It looks like you have a dynamic IP your end and the mysql
> server is looking
> for a fixed IP.
Nope, you read it wrong, both of you. MySQL is printing out YOUR IP
address, not the address of the server. It's complaining that you don't
have permission to access the data you want.
sql, query.
> I copied my.cnf to /etc and /var/db/mysql
> and made a file mysql.sock in tmp (/tmp/mysql.sock)
>
> What do I put in mysql.sock?
Nothing. The server creates it when it starts up. Read the docs.
sql, query
-
Before posting,
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: 'root@localhost' (Using password: NO)'
>
> Is there an way to get out of my way? Uninstalling mysql-server
> and installing again didn't do the trick
Look in the manual FIRST before porting, please - this is a
> what's nested SQL?
> can you tell me more about it?
Nested SQL allows you to do all kinds of interesting things in MySQL that
you can't do now - sub-selects, for example; or if you're a lazy programmer
(like me!) you want to do grouping and sorting in ways that would be
difficult (and complicate
ut:
OpenDatabase(host, database, user, pass);
OpenRecordset("select * from blah");
while(RecordsetEOF() != EOF)
{
printf("ID: %d Value: %s\n", GetField("ID"), GetField("Value"));
MoveNext();
}
CloseRecordset();
}
Look for MyC on mysql.com - if you c
> -Original Message-
> From: Nicolas MONNET (Tech) [mailto:[EMAIL PROTECTED]]
> Sent: Friday, October 11, 2002 5:53 AM
> To: Ed Carp
> Cc: [EMAIL PROTECTED]
> Subject: RE: MySQl db as filesystem.
>
> On Fri, 2002-10-11 at 10:06, Ed Carp wrote:
>
> > >
> I dont think that there is any SQL statement to do that.
No, just use mysqldump to do it.
sql, query.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 10, 2002 5:57 PM
> To: Alex Polite; [EMAIL PROTECTED]
> Subject: Re: MySQl db as filesystem.
>
> At 12:58 +0200 10/10/02, Alex Polite wrote:
> >Is there any way I could display a MySQL database as
> Don't forget that MySQL is the fastest thing on the planet for your (and mine)
> kind of simple query and insert/updates. We measured 12 times faster
> performance in MySQL than Oracle in one part of our application, and I
> strongly believe that in the MySQL case the Java program overhead becam
> On Monday 07 October 2002 12:04, Edwin Raj wrote:
> > When I type mysql in the command prompt it is giving the error "ERROR
> > 2002: Can't connect to local MySql server through socket
> > '/var/lib/mysql/mysql.sock' (111)"
> > There is no file mysql.sock at that location???
>
> Exactly.
>
> > W
> Thats a pretty nifty speed. PHP have a considerable overhead compared to new
> versions of Java. (I use both languages... I prefer PHP for webpage
> generation, but Java for serverside applications)
And both have a significantly larger overhead than C. Have you tried Escapade? It's
a simple,
> I am hesitant to dig into C++ just to solve this problem, so I am as far as
> possible trying to solve the performance issues within Java and MySQL. I
> will probably rewrite the code countless of times just to see if I can do
> it, and last resort would be C++.
Why dig into C++? MySQL has a p
> I am running php/mysql on 2x PIII 1 GHz / 512MB RAM / SCSI and can run
> queries on datasets of 220,000
>
> SELECT * FROM `Tablename` WHERE `Prod_code` LIKE 'A43611109%' in less time
> than I can count (0.1 sec at a guess)
>
> The insert/update bit is the bit which will dictate the speed - how
> -Original Message-
> From: Robert H.R. Restad [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, October 06, 2002 9:04 AM
> To: James Riordon; [EMAIL PROTECTED]
> Subject: RES: Re: Server comparison running Mysql
>
> Another thing... I noticed once when I moved a website from one server to
> ano
nked and dynamically-linked
versions of the product, and I would be interested in knowing MySQL's
position on this issue in regards to licensing.
- --
Ed Carp, N7EKG http://www.pobox.com/~erc
214/986-5870
Licensed Texas Peace Officer
Computer Crime Investigation Consulta
> I want to have manual startup/shutdown but still am not sure of the
> appropriate way to do this.
Change the startup type from "Automatic" to "Manual".
> The "Computer Management" utility allows me to stop the service and/or
> change the service startup type to manual or "disabled." Is "disabl
> Which version of WinXP (Pro or Home)?
>
> On WinXP Pro, you'd have to install MySQL as a service, in which case it
can
> either started manually or automatically. WinXP Home is more like WinME
> (yuck!) or Win98, where you can start MySLQ from a batch file.
WinXP Home is MUCH more stable than M
Might want to look at writing either a shell script or doing it in C, if it
has to be non-interactive. Escapade can also do thos sort of thing
interactively, and it's as simple as 4 lines of code.
- Original Message -
From: "Keith Burke [Experience IT]" <[EMAIL PROTECTED]>
To: "'Michael T
If you want it to be as fast as possible, you might want to consider doing
the following:
1. Arrange your data so that the records are fixed length.
2. If possible, switch to something other than a relational database. A
binary search on fixed-length, sorted records is probably going to be your
returns.
>
> i searched my system for it and couldn't find it.
>
> can you tell me something about it, like maybe where it could be?
Yes, well, a quick 30 seconds worth of work:
(1) go to mysql.com
(2) click on "Search"
(3) Type in "--safe-show-database" in
> MySQL really wasn't designed for this sort of useage. Your selects are going
> to be brute force searches on unidexed data, which is exactly why they are so
> slow...
>
> I would advise you to look into using an XML or XML Enabled RDBMS. There are
> a lot of possible considerations here as to wh
You can also use Microsoft Query or Microsoft Access to construct queries if you're
running Windows.
> -Original Message-
> From: Dan Vande More [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 31, 2002 11:35 AM
> To: Mark Herzog; [EMAIL PROTECTED]
> Subject: RE: Cut Copy Paste
>
> My
ASCII SQL files to look at if
something happens, and compresses well. I'd
highly recommend using it as opposed to copying the actual disk files around.
--
Ed Carp, N7EKG http://www.pobox.com/~erc 214/986-5870
Director, Software Developm
www.mysql.com/doc/m/y/mysqldump.html
I hope you're shutting down MySQL before you do this. If yuo're not, your "backups"
are probably worthless.
sql, query
--
Ed Carp, N7EKG http://www.pobox.com/~erc 214/986-5870
Director, Software Development
Escap
lso, if u know right now.
insert into whatever_table (time_stamp) values (NOW());
update whatever_table set time_stamp=NOW();
--
Ed Carp, N7EKG http://www.pobox.com/~erc 214/986-5870
Director, Software Development
Escapade Server-Side Scripting Engine Development Team
Pen
> Over 45 MYSQL API (base) functions are now available for using in Microsoft
> VB,Excel,Word,Visio,Visual FoxPro...etc.Are over 20 examples to learning how
> you must use this API functions and how you can use multiple
> connection/query.
> Memory consumption is 2 kb.Performance guarantied (1700
tion on your queries and such, it will speed
things up tremendously. If you don't, VB will bring down the entire table or tables
to your desktop, then work on the data locally,
a HUGE waste of time and bandwidth.
You also don't have to use ADO if you don't want to - I use DAO and with
> Not sure there is much more metadata in an XML database than in a data
> database.
In a standard database, the data and metadata are stored separately, not so with XML.
When the next new "latest and greatest" thing
comes along, you'll have to strip all that metadata out of your data. It also
> On the other hand, proclaimed "native" XML databases (eg, Software AG's
> Tamino, Ixiasoft's TEXTML) store the "XML-wrapped" data in the database...no
> need to wrap and unwrap the metadata, document/data structure from the data.
Isn't that more than a bit stupid? Databases are for storing dat
> I am looking at a project using XML to import and export data into MySql
> directly or using php. The datasets are quite large (40-50 million records)
XML is a metadata technology - you wrap data in XML. You don't use XML to import or
export data. You don't store XML in a
database, you store
h other server-side scripting languages.
And while Escapade is a commercial product, Escapade is freeware, as opposed to ASP
which is not.
--
Ed Carp, N7EKG http://www.pobox.com/~erc 214/986-5870
Director, Software Development
Escapade Server-Side Scripting Engine Develo
you can get md5sum for other Unices as well.
It's either md5 or md5sum on most UNIX-like operating systems. I don't think the
MySQL MD5 function is designed for large amounts
of data. Escapade provides it's own MD5 function because of this, I'm not sure about
;
> Somebody know's other option ?
sql,db
Why not use MyODBC? you don't *have* to use ADO, you can use DAO, which is simpler.
--
Ed Carp, N7EKG http://www.pobox.com/~erc 214/986-5870
Director, Software Development
Escapade Server-Side Scripting Engine Develo
Ed Carp ([EMAIL PROTECTED]) writes:
> Hi! I'm having a problem with mysql hanging. I'm running mysql-3.23.36 on
> a Linux 2.2.17 kernel. It ran just fine last week, but when we rebooted the
> box, mysql will start, but connections to the database just hang.
> mysqldm
> >> I have not completely figured out what the problem is and I never got a
> >> response from any one else on the list. I can tell you it looks like a
> >> mutex problem between two threads. We have followed it down into
> >> pthreads
> >> where it seems to be stuck. The external symptom we s
it down to the pthread_mutex_lock call in mysqld.cc around line 1340.
It enters pthread_mutex_lock, but never returns.
--
Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc
Squished Mosquito, Inc.
Internet Applications Development
Escapade Server-Side Scripting La
aries, I will reinstall the thread libraries. If that doesn't resolve
the issue, I'm going to be forced to reinstall the OS.
It seems that MySQL --debug mode should provide a little more information,
but I suppose that's wishful thinking :) It's a very irritating problem,
beca
Egor Egorov ([EMAIL PROTECTED]) writes:
> Ed,
>
> Monday, January 28, 2002, 11:26:44 PM, you wrote:
>
> EC> Hi! I'm having a problem with mysql hanging. I'm running mysql-3.23.36 on
> EC> a Linux 2.2.17 kernel. It ran just fine last week, but when we rebooted the
> EC> box, mysql will start,
t;3.23.36" string that we would normally see. Any
> EC> hints?
>
> Yes, take the right-compiled MySQL binary distribution from
> http://www.mysql.com.
I've got the same problem, and it doesn't fix the problem.
--
Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420
> What seems to be happening is that the "open" of the db hangs. So, when
> you attempt to connect with a client, mysql tries to look at the grant
> tables and hangs waiting for access. This is just a guess though.
When you connect with a client, mysql_real_connect opens a socket to the
server,
Hi! I'm having a problem with mysql hanging. I'm running mysql-3.23.36 on
a Linux 2.2.17 kernel. It ran just fine last week, but when we rebooted the
box, mysql will start, but connections to the database just hang.
mysqldmin, etc. all hang also. /tmp/mysqld.sock is being created, but when
we
the same question twice.
Second, you can RTFM before posting - specifically,
http://www.mysql.com/doc/P/r/Problems_with_mysql.sock.html
You can also look at Carsten's *excellent* FAQ - specifically,
http://www.bitbybit.dk/mysqlfaq/faq.html#ch10_1_0
--
Ed Carp, N7EKG - [EMAIL PROTECTED] -
Stupid damned frigging spam filters...
database, sql
Forwarded Message:
Ed Carp ([EMAIL PROTECTED]) writes:
> Ed Carp ([EMAIL PROTECTED]) writes:
>
> > >Description:
> > ./configure;make produces core dump when conf_to_src runs.
> > >How-To-Repeat:
> >
1
>How-To-Repeat:
make
>Fix:
Unknown
>Submitter-Id: <[EMAIL PROTECTED]>
>Originator:Ed Carp
>Organization:
Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc
Squished Mosquito, Inc.
Internet Applications Development
Esc
>Description:
./configure;make produces core dump when conf_to_src runs.
>How-To-Repeat:
make distclean;./configure;make
>Fix:
Unknown.
>Submitter-Id:
>Originator:Ed Carp
>Organization:
Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - ht
ng the same error with "latin1".
It seems that some versions of gcc/egcs are generating incorrect instructions with
optimization turned on - when I turned off optimization, everything worked fine.
Alternately, you can try the compile flags listed for your platform in the
INSTALL-SOUR
that are in it.
>
> /cygdrive/d/DOCUME~1/ADMINI~1/LOCALS~1/Temp/cc5hhVhM.o(.text+0x8e):sampl
> e1.c: undefined reference to `mysql_connect'
> /cygdrive/d/DOCUME~1/ADMINI~1/LOCALS~1/Temp/cc5hhVhM.o(.text+0xa7):sampl
> e1.c: undefined reference to `mysql_error'
It's probably be
able.
-
Question - under heavy load, with 75% reads, 25% writes, what table
structure is fastest at retrieving data?
--
Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 -
http://www.pobox.com/~erc
Squished Mosquito, Inc.
Internet Applications Develop
would be used to code
> them.
SQL, obviously. Anything else would be insane.
--
Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 -
http://www.pobox.com/~erc
Squished Mosquito, Inc.
Internet Applications Development
Escapade Server-Side Scripting Language Developme
Pablo Fraga ([EMAIL PROTECTED]) writes:
> What´s the diference between The row storage format (Fixed, Dynamic, or
> Compressed) .
RTFM!
http://www.mysql.com/doc/C/R/CREATE_TABLE.html
http://www.mysql.com/doc/D/y/Dynamic_format.html
--
Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/34
does is blur the lines of that the database should do
> and what the middle tier should do.
BRAVO! At last, the voice of common sense is heard :)
--
Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc
Squished Mosquito, Inc.
Internet Applications Development
entation on
> the limitations of fulltext?
I've had no problems, but I also haven't seen any documentation on
limitations. The FULLTEXT page is at
http://www.mysql.com/doc/F/u/Fulltext_Search.html if you can see something
I've missed...
--
Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/3
t;directly.
These are all great reasons to implement stored procedures, not Oracle
PL/SQL. I think I'm missing your point here...
--
Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 -
http://www.pobox.com/~erc
Squished Mosquito, Inc.
Internet Applications Development
Escapade Serve
g? Isn't SQL good enough? I'm just trying to
figure out your reasoning here, besides the same argument used by the XML crowd of
"it's the latest/greatest do-all-be-all-end-all, so everyone should be using it" type
of nonsense.
--
Ed Carp, N7EKG - [EMAIL PROTECTED] - 214
e set of laws for the State of Texas online. My query time went
down from 120 seconds to less than a second. So, yes, it's really worth it.
--
Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc
Squished Mosquito, Inc.
Internet Applications Development
Escapade
ty = ty + 1900;
}
mo = now.getMonth();
mo = mo + 1;
return(ty+'-'+ShowZeroFilled(mo)+'-'+ShowZeroFilled(now.getD
ate())+'
'+ShowZeroFilled(now.getHours())+':'+ShowZeroFilled
sename origtable|sed -e "s/CREATE TABLE origtable/CREATE TABLE
$i/g"|mysql databasename
done
Tada!
--
Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc
Squished Mosquito, Inc.
Internet Applications Development
Escapade Server-Side Scri
Sinisa Milivojevic ([EMAIL PROTECTED]) writes:
> Ed Carp writes:
> > Sinisa Milivojevic ([EMAIL PROTECTED]) writes:
> >
> >
> > ODBC, or MyODBC?
>
> ODBC as an API.
>
> Then you install ODBC driver for RDBMS of your choice and configure
> ODBC l
Sinisa Milivojevic ([EMAIL PROTECTED]) writes:
> If you wish to make your application transparent, you should use ODBC.
ODBC, or MyODBC?
--
Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc
Squished Mosquito, Inc.
Internet Applications Development
Escap
> create a .my.cnf in the home directory of the user that will be running
> the clients, and enter a
> [client]
>
> paragraph that defines the socket.
A better solution would be to do it in /etc/my.cnf, so that it will be
system-wide for the database.
--
Ed Carp, N7EKG - [
onfig to tell the run-time library
loaded where to look for the required libraries.
Try "man ldconfig". Good luck!
--
Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc
Squished Mosquito, Inc.
Internet Applications Development
Escapade Server-Side Scripti
> Does your message mean we'll see no more Escapade announcements on
> this list? That would be unfortunate, but by the same token, should
> the EMS client become available in a Linux version, an announcement on
> this list might be of interest to several of the readers.
No, simply because we don
m/purchase.phtml
Q. Why should I pay $95 for your product when I can download and use PHPMyAdmin (or
any number of other products) for free?
Q. Why should I pay a lot of attention to a company who spams a technical list in
order to sell product under the guise of "answering questions&quo
or - again, you didn't say.
I'm sorry I can't help you without you providing more specific information about your
problem.
--
Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc
Squished Mosquito, Inc.
Internet Applications
re the security concerns with
> doing this via the net? Thanks
Not a problem. Use secure shell's port forwarding feature (look in the VPN HOWTO at
http://www.linuxdoc.org/HOWTO/VPN-HOWTO.html for more info).
--
Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc
=?iso-8859-1?q?Cinzia=20Rubattino?= ([EMAIL PROTECTED]) writes:
> I have to insert a file wav into a blob field of a
> table. Is that possible?And how can I do it?
Bad, bad, BAD IDEA!
Read: http://www.bitbybit.dk/mysqlfaq/faq.html#storing_images
--
Ed Carp, N7EKG - [EMAIL PROTECTED]
I couldn't - I can't
understand why you would want to, anyway. As I recall, it also breaks the SQL-92
standard.
--
Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc
Squished Mosquito, Inc.
Internet Applications Development
Es
;s something to do with permissions.
If the server is creating mysql.sock in /var/lib/mysql and something else is looking
for it in /tmp, this is the easiest way to get it to work, besides checking to make
sure that the permissions are such that anyone who needs to can read and write to
mysql
..
> Using any crypto library or hardware to encrypt data in a database.
All of this stuff is easy. I've done a fair amount of compression/encryption of
databased data, but it's almost too trivial and straightforward to pass along.
--
Ed Carp, N7EKG - [EMAIL PROTECTED] - 2
start it?
safe_mysqld&
Where is mysql.sock? In /tmp? If so:
ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock
Should get you going.
--
Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc
Squished Mosquito, Inc.
Internet Applications Develop
Ed Carp ([EMAIL PROTECTED]) writes:
> The obvious solution is to force, in the client library, for my.cnf to exist,
>correctly configured, in a published place. Any other ideas on how to solve this
>problem? I've already mentioned why relinking as a dynamic binary isn't fe
muttaqin ([EMAIL PROTECTED]) writes:
> >Description:
> ERROR 2002: Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (111)
> >Fix:
> lines)>
"ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock"
are
language (PHP, Perl, Escapade, etc.) would be able to produce XML output easily from
data.
--
Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc
Squished Mosquito, Inc.
Internet Applications Development
Escapade Server-Side Scripting Language Development
n the client library, for my.cnf to exist,
correctly configured, in a published place. Any other ideas on how to solve this
problem? I've already mentioned why relinking as a dynamic binary isn't feasible.
Thanks in advance :)
--
Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 -
t;
> > Of course root can connect to mysql server with above command. That is
> > there was no problem.
Does /tmp/mysql.sock really exist? If not, the simplest solution is to
"ln -s /var/lib/mysql/mysql.sock /tmp" or wherever mysql.sock is living. You can find
this out b
er gets rebooted for one reason
or another (every 45-60 days), and either "isamchk -r -e -s -o -f" or "myisamchk -r"
gets run, followed by "optimize table" commands on some of the most updated tables.
--
Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://
y help:
http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_8_0
:)
--
Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc
Squished Mosquito, Inc.
Internet Applications Development
Escapade Server-Side Scripting Language Development Team
http://www.squishedm
ntax?
>
> I'm stuck here:
>
> % mysqldump dbname tablename > ???
Easier:
echo "select * into outfile 'tablename.tsv' from tablename"|mysql dbname
--
Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc
Squished Mosquito, Inc.
Internet
Mark kirkwood ([EMAIL PROTECTED]) writes:
> CREATE UNIQUE INDEX fact0_pk ON fact0(d0key,d1key,d2key) ;
>
> Whichunfortunatly takes about 20m ( which I think is a bit slow )
Have you tried building the table structure with the index already in place,
then importing the data?
--
Ed Ca
ested under worked just fine, in
networked and non-networked environments, but we didn't test under Windows 3.1, 3.11,
or earlier. Works fine under Win95/98/NT/2K/ME.
--
Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc
Squished Mosquito, Inc.
Internet Applicat
ries, or is there some recommended procedure for this?
RTFM, RTFM, RTFM!
That being said, most everyone I know uses mysqldump for hot backups.
Now, STOP what you're doing and go bookmark
http://www.bitbybit.dk/mysqlfaq/faq.html,
if you have time to do nothing else - this is Carsten Pederson
dmin: connect to server at "localhost" failed
> error 'access denied for user: 'root@localhost'(using password:YES)
If you did not specify a password when you installed MySQL, then there is no password.
Try typing "mysql mysql". If you get a prompt, then you ca
RTFM :) The searchable manual is online at
http://www.mysql.com/doc/ - it took me all of 30 seconds to return the
following URL (although I ought to know this one by heart!):
"Hot to Reset a Forgotten Password" -
http://www.mysql.com/doc/R/e/Resetting_permissions.html
OBList: database,sql,query,t
se, I like "mysqladmin processlist" and "mysqladmin status". YMMV :)
--
Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc
Squished Mosquito, Inc.
Internet Applications Development
Escapade Server-Side Scripting Language Development Team
http://www.squishe
1 - 100 of 160 matches
Mail list logo
