Hi. Before asking my question I would like to state that I have looked
through the installation documentation, and have also successfully
performed MySQL installations on WindowsXP (along with Apache and
PHP), as well as on Linux machines that I have administrative (root)
access on. However, I am h
Sorry, I don't mean running MySQL as root, I mean I do not have root
access on the server I am trying to install MySQL on - for myself,
under my home directory. I run into permission problems (because I am
not root, I can't alter anything under /var). I am trying to edit the
necessary configs so th
I created and user, like below, using mysql on my
Linux machine (Linux-Mandrake 8.1) to access a
database called college:
GRANT ALL ON college.* TO someuser BY "somepassword";
But I'm denied access even from localhost. I tried the
following too:
GRANT ALL ON college.* TO someuser@% BY
"somepass
hi all,
I am using mysql on Win98 platoform. Am facing problems
using the Time field in SQL queries being executed from a VB
program. Would it be possible for someone to help me out with
this
At mysql> prompt
1. CREATE TABLE TEST(field Time) > success
2. INSERT INTO TEST(field)
i got an error msg. that this was not posted... hence i am doing
it once more
Praveen
On Mon, 06 May 2002 p j j wrote :
>hi all,
> I am using mysql on Win98 platoform. Am facing problems
>using the Time field in SQL queries being executed from a VB
>program. Would it be
I was asked to scope out the following features, and am not the person to be
implementing them.
Hence the manuals weren't particularly helpful.
I'm looking for definitive references one way or the other for the following
questions.
SOS!
Does MySQL support the following:
- Support for DDL comma
Thanks!
With regard to the ClOBs or Text fields, is that CLOB support? Or support
for Text columns that hold up to 60,000 bytes of TEXT data?
From: Peter Brawley <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: J A <[EMAIL PROTECTED]>
CC: mysql@lists.mysql.com
Subject: Re:
Does MySQL have the ability to send resultsets from stored procedures?
(similar to ref cursors in Oracle).
_
FREE pop-up blocking with the new MSN Toolbar get it now!
http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/
What is the rowsize limitation in MySQL?
_
Dont just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
Does MySQL have support for temporary tables inside stored procedures?
_
Express yourself instantly with MSN Messenger! Download today - it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
--
MySQL General
1. Support for N-types for the future. UNICODE support for NCHAR, NCLOB and
NVARCHAR datatypes
2. Support for UCS-2 or UTF-16 for future.
3. Support for N-types in Stored Procedures
4. Automatic translation of N-type to SPs Unicode
5. Embedded database server within a client
Hi Everyone
I am interested in how to get an XML request to query a database. I'm working
on generating the XML requests OK, I just need to know how XML meets database.
Are there any generalised pointers to begin with?
Thanks in advance
Jonathan Trahair
On Tue, 2009-03-17 at 17:10 +0100, Jon Stephens wrote:
> Please don't post off-topic mails to the MySQL Cluster list.
Jon hi, I couldn't see anything that read such posts were not permitted.
That said, I have tried to present the post as clearly and informative
as possible. Hope people agree.
I
On Wed, 2009-03-18 at 13:54 +0100, Claudio Nanni wrote:
> This is not a list for job posting, there are specific sites for that.
> If we consider useful a 'private' list for job postings we can ask a new
> one.
> I understand every thing about the need of a job but it can be done in a
> better way
A simple way to do this is to truncate the date and then GROUP BY it. So if
you have 2009-08-08, and you want a subset on month, then just truncate the
day-part: 2009-08-00 on the whole column, and SELECT DISTINCT so you have a
subset. You can use this subset then to join the dates, GROUP BY and
Hi,
I have this stats: I have tuned some of it but I was wondering if someone
can give inputs regarding it:
*
__ Key _
Buffer used54.63M of 384.00M %Used: 14.23
Current 123.21M%Usage: 32.09
Write hit
ase stats are useless without
> knowing the configuration and without knowing your hardware (memory!)
> nobody can say what buffers are making sense
>
> i would use "mysqltuner.pl" because it shows in the most cases good
> advises
>
> Am 05.05.2011 20:42, schrieb
Dear all,
I wish to create a new table from a table that has two columns
"country" and "person_name". Thus from the table below, I'd like to
select all the records of those countries that have person names 'Tom'
and 'Kevin'.
"country" "person name"
US Antony
US
Thanks, but I don't see how it will work. Am I missing something?
On Tue, Jun 7, 2011 at 5:24 PM, Willy Mularto wrote:
> Why not GROUP BY?
>
>
>
> On Jun 7, 2011, at 10:06 PM, joe j wrote:
>
>> Dear all,
>>
>> I wish to create a new table from a tabl
ok. here's what I am trying now. First create a table with the code
below with a list of countries that have the two person names I want.
CREATE TABLE `table_new` SELECT t1.country
FROM `table_old` as t1
JOIN
`table_old` as t2
USING(country)
JOIN
`table_old` as t3
USING(country)
WHERE (t2.`person_n
I was wondering if any one could point out potential problems with the
following query or if there was a better alternative
>From a list of users I want to return all who don't have all the specified
user_profile options or those who do not have at least one preference set to
1. The following quer
Thanks. I was looking for a loop--not to gain speed but to reduce the
length of my script file:) I'll try and hopefully it will work!
J
On Wed, Apr 4, 2012 at 12:16 PM, Johan De Meersman wrote:
> - Original Message -
>> From: "joe j"
>>
>> So what
Thanks to Rick I would go for a single table. I tried the following,
but hasn't been successful yet. First I created one 'master' table for
one country, with a country column (ctry) as Rick suggested, then I
tried to use the loop suggested by Johan to insert the records for
each of the remaining co
ange. Probably I could convert empty cells to NULL
and then use 'IS NOT NULL' condition as an alternative (this works
now).
Yes, I've now removed back ticks now, but it seems I need to use
single quotes for '${x}'-without the single quotes I get error
messages.
On Thu, Apr 5
>Jan Steinman wrote
>If not, how 'bout the best of both worlds: create a UNIX (or perl) script that
>loops
>through the country names and creates an SQL script? That would be fast
>entering AND fast
>performing!
Good suggestion. But I am a perl/unix illiterate. However I may learn
in them future
Hello,
I have been provided a muscular linux server to use as a Mysql server
in our organization. The server is located just beside the web server
and within the same network. This dedicated server has 8GB RAM, i5 processors
and running mysql as service. No apache, php . nothing. All re
On Mon, 09 Apr 2012 11:47:01 +0200
Reindl Harald wrote:
>
>
> Am 09.04.2012 10:57, schrieb J. Bakshi:
> >
> > Hello,
> >
> > I have been provided a muscular linux server to use as a Mysql server
> > in our organization. The server is located just be
On Mon, 09 Apr 2012 12:06:42 +0200
Reindl Harald wrote:
>
>
> Am 09.04.2012 11:56, schrieb J. Bakshi:
> > On Mon, 09 Apr 2012 11:47:01 +0200
> > Reindl Harald wrote:
> >
> >>
> >>
> >> Am 09.04.2012 10:57, schrieb J. Bakshi:
> >>
On Mon, 09 Apr 2012 13:17:55 +0200
Reindl Harald wrote:
>
>
> Am 09.04.2012 13:05, schrieb J. Bakshi:
> > I have reset these two now
> >
> > ` ` ` `
> > key_buffer_size=200M
> > innodb_buffer_pool_size=4G
>
> [!!] InnoDB data size / buffe
hi all,
i have an issue with our db which hangs and the only way to
recover from it is to restart mysql if you had console access or
restart the box itself ( only if i can't wait )
show processlist result can be found here: http://pastebin.com/BYvZ5ZFR
listed below are info about
Thank Baron,
i want to see if there is something i can do from the DB end.
and BTW, i've been using the plugin already.
On Thu, May 31, 2012 at 1:01 PM, Baron Schwartz wrote:
> In this case the solution is much easier outside of MySQL than inside.
> http://ocaoimh.ie/wp-super-cache/ i
hi all,
our DB crashed for some reason... any inputs would be greatly appreciated..
120711 8:12:21 - mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. Th
sorry.. im using 5.1
On Wed, Jul 11, 2012 at 10:09 AM, J M wrote:
> hi all,
>
> our DB crashed for some reason... any inputs would be greatly appreciated..
>
> 120711 8:12:21 - mysqld got signal 11 ;
> This could be because you hit a bug. It is also possible that this bina
Hi, All,
I am having trouble to transfer email user account which is saved in
MySQL to another server. Here is the detail:
I have an old email server which using MySQL to store user account
information. The password field uses MySQL ENCRYPT function to save the
users password. So if I want c
What about the MySQL Administration backup routine, which can be scheduled for
a convenient time? No-one has mentioned this one. We use it but perhaps there
is something I should know...?
Thanks
Jonathan Trahair
- Original Message -
From: B. Keith Murphy
To: Dan Buettner
Cc:
Hi Everyone
I have a database with an OrderItems table, containing (at least) 3 fields,
namely ExtendedPurchasePrice, CurrencyConversion and
ExtendedPurchasePriceSterling, all fields as doubles.
I want to update ExtendedPurchasePriceSterling for each row with the result of
the calculation
Ext
This is a question I want to know the answer to, as well! Is there any way of
avoiding looking up a specific record in a table to see if it exists, before
deciding whether to INSERT INTO or UPDATE, eg:
mstrSQL = "SELECT * FROM Shops WHERE ShopReference = '" &
grd1.TextMatrix(numRowNo, 1) &
In my experience, having a limit of a particular number of anythings per
something, eg. components per compound word is always a mistake, whether it's
the number of payments allowed to pay an invoice, the number of children per
parent, the number of cars per family, pets per owner, etc. There's
Hi Everyone
I am now familiar with connecting with MySQL using Visual Basic 6 and ADO. I am
about to start a new project which must connect to a customer's MS SQL Server
2005 installation.
How safe/unsafe is my assumption that as far as SQL strings and ADO connections
are concerned 'if it work
:
- SQL Server doesn't support LIMIT clause;
- Don't use quotes for numerical values as it works on MySQL only;
- In GROUP BY clause, list all not aggregated columns you are selecting;
- Use single quotes for strings;
Hope it helps.
On 1/23/08, J Trahair <[EMAIL PROTECTED]> wrote:
Hi Everyone
I had to re-install everything after Norton crashed my hard disk. I
re-formatted.
I am trying to install MySQL using the same installation files and method as
before.
MySQL installed OK (mysql-5.0.27-win32.zip). The mysql connector ODBC installed
OK.
However, I cannot complete t
Thanks Baron, that hit the spot.
Thanks again.
Jonathan
- Original Message -
From: J Trahair
To: MySQL General
Sent: Saturday, May 05, 2007 9:00 PM
Subject: Error message on trying to start service
Hi Everyone
I had to re-install everything after Norton crashed my hard disk. I
re
Hi Everyone
I have set up a scheduled backup using MySQL Administrator. Stored connection,
database, dates and time, even the Windows user password (in fact, blank). It
doesn't start at the correct time, or indeed any time.
Have I missed something?
Thanks for your help.
Jonathan Trahair
Hi Everyone
Is there a way of replicating or cloning the structure of an existing table and
giving it a different name? I have a table of items on sale in the shops, I
want to create a table of items not yet in the shops but due to be introduced
very soon.
MySQL 5.0.37 Windows XP.
Thanks in a
ith no problems. And
there is no error message - as far as the MySQL server is concerned,
everything went fine.
I've looked at different doc sites about MySQL to see if you have to
format set data differently from other field types during INSERT, but
have found nothing.
Any suggestions??
Thanks,
J. Wermont
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I need a bit of help with a mySQL query. I have a list of users in a text
file called 'users':
u655354
u687994
u696974
u728141
..
..
and I need to check the last date each user logged on to the proxy in the
last 3 months.
In my database, there is a table for the users:
mysql> desc user_tabl
J S wrote:
| Hi,
|
| I need a bit of help with a mySQL query. I have a list of users in a
| text file called 'users':
|
| u655354
| u687994
| u696974
| u728141
| ..
| ..
|
| and I need to check the last date each user logged on to the proxy in
| the last 3 months.
|
| In my database,
I wonder how somebody can approve such a query and tables.
1) There is no indexes, thats the main reason for the time and cpu consuming.
At least,
the fields used in the joins MUST be indexed.
2) varchar(255) on ALL fields? That's unlikely, in-cre-di-ble. Right type for
the right
data, int for
|
+-+--
PLEAS ADVICE, my site is down for 2 days now.
Thanks In Advance,
Derek J
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have enough disk space for indexes, the problem doesn't happen during
adding an index. it happens after the index is added.
On Sun, 2003-12-28 at 21:33, mos wrote:
> At 06:28 PM 12/28/2003, you wrote:
> >Hello Every Body ,
> >I have been facing a strange problem, that i assume its a mysql bug of
00 | 2003-12-27 21:40:36
|| |
++++--++-+-+--+---++-+-+-++-+
HTH,
Derek J
On Mon, 2003-12-29 at 11:00, Serg
We're using Forte Developer 7 C 5.4 running on Solaris 9 (Sparc) and ran
into a problem while compiling the mysql 4.0.17 source.
While I understand their is a pre-built package for my platform, that
package doesn't have built in support for SSL, which is the reason we
need to re-compile the sour
I am using snort with mysql and am noticing
significant increases in response time, I think this
is due to data growth but I am still reading the docs.
Are there a few commands to check the db, and possibly
improve performance response time? Any pointer to
admin commands section welcome.
with several hundred thousand rows. Does anyone have
a simpler (and less time consuming) way than writing ETL to export the
tables and compare every record field by field (as recommended by the
MySQL Doc) to determine what the problems are?
J
--
MySQL General Mailing List
For list archives: http
Hi,
I've run myisampack to compress a table and am now trying to recreate the
index using myisamchk (as root) but I get an error 27.
# myisamchk -rq --sort-index --analyze --tmpdir=/proxydb/mysql/tmp
internet_usage.MYI
- check record delete-chain
- recovering (with sort) MyISAM-table 'internet_u
Hi,
I've run myisampack to compress a table and am now trying to recreate the
index using myisamchk (as root) but I get an error 27.
# myisamchk -rq --sort-index --analyze --tmpdir=/proxydb/mysql/tmp
internet_usage.MYI
- check record delete-chain
- recovering (with sort) MyISAM-table 'internet_
Hi,
I've run myisampack to compress a table and am now trying to recreate the
index using myisamchk (as root) but I get an error 27.
# myisamchk -rq --sort-index --analyze --tmpdir=/proxydb/mysql/tmp
internet_usage.MYI
- check record delete-chain
- recovering (with sort) MyISAM-table 'internet_
-sort-index --analyze internet_usage
Sound OK?
JS.
Hi.
Usually myisamchk doesn't have the suid bit set, and it seems to be ran as
root.
See
http://dev.mysql.com/doc/mysql/en/Table_maintenance.html
Especially
http://dev.mysql.com/doc/mysql/en/myisamchk_memory.html
"J S" <[
Hi,
I have this query which used to work really fast but now it just seems to
lock up the tables. I tried running it with EXPLAIN but it just hangs at the
command prompt. I also tried adding the USE INDEX directives but still no
luck. I've run myisamchk -m on both tables involved and no errors w
After I ran some database updates last night, it seems to be working OK
again today. Not sure what happened! Thanks anyway.
JS.
Hi.
Uncommon situation.
Please tell me, what OS do you use, MySQL version and how was it compiled?
Is there any clues at the end of .err file?
"J S" <[EM
That failed with an err27 as well. How do I set the debug flag on myisamchk
?
--debug=/tmp/debug doesn't work.
JS.
Hi.
Sounds OK, but don't forget to make a backup.
"J S" <[EMAIL PROTECTED]> wrote:
> Thanks for your reply Gleb. I tried running with --safe-recov
What is 'binary' in column type stand for?
is it describe how the data is stored (in biner value)?
what do we want use it for?
- encryption ?
- space efficiency ?
- fast index ?
- or ?
I've searched the mysql manual but didn't find any clue about it
thanks for your help before.
can anyone tell me about what verbose mode mean?
is it Uppercase or Lower case matter
or something with backtick?
By the way what do backslash for in mysql query?
Thanx guys
__
Do you Yahoo!?
Yahoo! Mail - You care about security. So
I have a price table entered more than once every day,
In the report for spesific day, I must show also the last entered price for the
day before
The problem is that the day before sometimes varies not fixed
(if it is fixed I could just round down the required date substract the date
with 86400
i'm still using 3.23
can anyone show me how to activate update log
by modifying the my.cnf/ my.ini
And a question about update log,
does it only record update and delete (mysql documentation),
how about insert? do the log recorded those too?
thanks
_
one more question, how about when i'm using 'BEGIN'
and doesn't end it with 'COMMIT' neither 'ROLLBACK'
what will happen.
I've tried before and nothing happen but does anyone have an opinion?
--- Chenri J <[EMAIL PROTECTED]> wrote:
> i&#
gs in the database (such as #3859, #3594, #3147) that talk
about similar symptoms. Are these problems in any way related to any bug?
Could we have done anything wrong during the upgrade (I did not perform it
myself)? What could we do to prevent this from happening when upgrading the
other servers?
e frm files. This will give you a fresh 4.1
table space to import into.
-Eric
On Thu, 13 Jan 2005 16:37:39 +0100, Mattias J <[EMAIL PROTECTED]> wrote:
> Earlier today we tried upgrading one of our MySQL servers from 4.0.15 to
> 4.1.8 using RPMs. This resulted in corrupted InnoDB
/InnoDB_Monitor.html
Regards,
Heikki
- Original Message - From: "Mattias J" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday, January 13, 2005 6:57 PM
Subject: Re: Upgrade correpted InnoDB tables
There are mostly just 2 or 3 corrupted tables out of about 100
g the data and then upgrading from 4.0 to 4.1(.8 or .9).
At 2005-01-14 11:35, you wrote:
Mattias,
please use
innodb_table_monitor
to print the contents of the InnoDB internal data dictionary.
http://dev.mysql.com/doc/mysql/en/InnoDB_Monitor.html
Regards,
Heikki
- Original Message - From:
At 2005-01-15 14:48, you wrote:
Without using Select statement, how can I execute Insert SQL statement if
Update action is failed?
I may be asking for too much. If Select statemnet have to be used to
determine the existence of a recordset, what is an efficient way to
execute Insert if Update is
Please also note hat UPDATE returns the number of records updated. If your
UPDATE returns 0, you know that the record does not exist, and you might
want to INSERT instead.
At 2005-01-15 14:54, you wrote:
At 2005-01-15 14:48, you wrote:
Without using Select statement, how can I execute Insert SQL
Hi,
I've run a safe recover on a table after I had to recreate the index file:
# myisamchk --tmpdir=/proxydb/mysql/tmp --safe-recover internet_usage
- recovering (with keycache) MyISAM-table 'internet_usage'
Data records: 290804216
Data records: 519541696
#
After that I ran a query on the table, bu
At 2005-01-17 15:12, shaun thornburgh wrote:
I am attempting to create a database and have a query. Is it possible for
mysql to contain the possible field values in the database rather than
creating the options in the application?
For example Field_A can only be Yes or No, Field_B can be 50% or
Just reposting in case anyone missed it! Or have I asked a dumb question?!
Hi,
I've run a safe recover on a table after I had to recreate the index file:
# myisamchk --tmpdir=/proxydb/mysql/tmp --safe-recover internet_usage
- recovering (with keycache) MyISAM-table 'internet_usage'
Data records: 29
At 2005-01-18 04:53, Craig Hoffman wrote:
I upgrade to 4.1.9 last night and I keep getting this error in PhpMyAdmin
after I changed the root password (yes I changed both pw's). Does anyone
have a solution on how to fix this? I'm running a Mac 10.3.x
#1251 - Client does not support authenticati
According to phpMyAdmin I have:
user 'root' on 'localhost'
with no password
with Global privileges set to 'All privileges'.
If I do a SELECT user(), I get '[EMAIL PROTECTED]'. Yet
there is a database that doesn't now allow me to
Browse. How can that be? Don't I have sufficient
rights?
Thanks!
>What is the output of the following statement:
> show grants for 'root'@'localhost';
Grants for '[EMAIL PROTECTED]'
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH
GRANT OPTION
It turns out that the database that I was trying to
decipher, appears to have nothing but empty tables. I
ins
Shawn,
Thanks for your reply below. I found it extremely useful. I have followed
your instructions and got good results up to the url_visits table.
I have a perl script to parse the values out of the log. The log has
3,770,246 lines and is gzipped. I then applied your SQL statements with the
fo
Did you mean there to be duplicates in the url_visits? Do I need to use
IGNORE in the following SQL?
INSERT url_visit (url_server_ID, url_path_ID, querystring,
category)
SELECT us.ID, up.ID, if(bt.path_split >0, SUBSTRING(bt.url,path),
NULL),
bt.category
FROM bulk_table bt
INNER JOIN url_servers
I think I fixed it!
INSERT IGNORE url_visit (url_server_ID, url_path_ID, querystring,
category)
SELECT DISTINCT us.ID, up.ID, if(bt.path_split >0, SUBSTRING(bt.url,path),
NULL),
bt.category
FROM bulk_table bt
INNER JOIN url_servers us
ON us.server = bt.server
INNER JOIN url_paths up
on
ata require (including indices)?
Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"J S"
<[EMAIL PROTECTED]To: [EMAIL PROTECTED]
com>
uce Pine
"J S"
<[EMAIL PROTECTED]To: [EMAIL PROTECTED]
com> cc:
[EMAIL PROTECTED]
Fax to:
06/22/2004 07
2 | tcp|
| 3 | - |
| 4 | ftp|
| 5 | https |
+++
5 rows in set (0.00 sec)
J S,
Check to see if the url_scheme_ID part of a unique constraint/key or the
Primary Key? If it isn't, you will get dupes even if you use INSERT IGNORE
unless you pre-screen your INSERTs some other
anks!
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"J S"
<[EMAIL PROTECTED]To: [EMAIL PROTECTED]
com> cc:
[EMAIL PROTECTED]
Hi,
I got an error 27.
DBD::mysql::st execute failed: Got error 27 from table handler at
/home/u752359/logfile.pl line 144, line 3079464.
The FAQs say:
Check whether you have hit 2 Gb limit.
If that is not the case, shutdown MySQL server and repair a table with
(my)isamchk.
How do I check if I h
Could this problem be due to the size of my tables? Is there a limit on how
big the table can be?
I'm using mysql-standard-4.0.20.
-rw-rw 1 mysqlmysql2147483647 Jun 25 01:49 internet_usage.MYD
-rw-rw 1 mysqlmysql622724096 Jun 25 01:49 internet_usage.MYI
Hi,
I got an er
'uid' is a mix of chars and ints, e.g u752352.
Yes, if you are using a dynamic table which means it has varchar's, text,
or
blobs the limit is 2 gigs. If you are using a fixed table which uses chars
only, then there is no limit that I have seen.
Donny
> -Original Message--
which means it has varchar's,
text,
> >or
> >blobs the limit is 2 gigs. If you are using a fixed table which uses
> chars
> >only, then there is no limit that I have seen.
> >
> >Donny
> >
> > > -Original Message-
> > > From: J
Hi Shawn,
I wondered if you might be able to help me with an SQL query.
I want to list all the internet sites I've surfed in my database.
Here's a query that matches the url with a urlid:
SELECT concat(usc.scheme,"://",us.server,up.path)
FROM url_visit uv
INNER JOIN url_servers us
ON us.id=u
Figured it out! Took a gamble and run the below command!
SELECT iu.time, INET_NTOA(iu.ip), concat(usc.scheme,"://",us.server,up.path)
FROM url_visit uv
INNER JOIN internet_usage iu
ON iu.urlid=uv.urlid
INNER JOIN url_servers us
ON us.id=uv.url_server_ID
INNER JOIN url_paths up
Even the ALTER gave me an error!
mysql> alter table internet_usage change uid uid char(10);
ERROR 1030: Got error 127 from table handler
mysql>
J S wrote:
Thanks for your reply. I had to change the IP column to bigint because
mysql was inserting the wrong value when it was just int.
Are yo
e wait.
Also personally I would change the ip from a bigint to an int, if that is
really an IP address like it seems.
Just my opinion. No matter what I would make a backup of your data before
making any changes.
Donny
-----Original Message-
From: J S [mailto:[EMAIL PROTECTED]
Sent: Friday, J
Hi,
I would like to switch off the logging that creates the large files below
(in the mysql data directory)
Could someone tell me how to do this please?
Thanks,
js.
# ls -l
total 5418648
-rw-rw 1 mysqlmysql 25088 Jun 28 14:27 ib_arch_log_00
-rw-rw 1 mysqlmysql
On Wednesday 30 June 2004 12:10 pm, J S wrote:
> Hi,
>
> I would like to switch off the logging that creates the large files
below
> (in the mysql data directory)
> Could someone tell me how to do this please?
take out log-bin from my.cnf. But you better not have replication
Hi,
The code in my function below (insert_internet_usage) has suddenly
dramatically slowed down and I don't understand why. The logs I'm parsing
are the same size as before, but what used to take 15 minutes has shot up to
about 4 hours. It's almost as if the indexes had stopped working.
I wonder
Hi people
I'm facing a (not huge) problem with mysqlimport.
The mysql version I'm using is MySQL
4.0.11a-gamma'-Max'
For updating a #29000 records table from fixed-lenght
ASCII file, I'm using a php script that gets a record
and executes and UPDATE for each one: pretty SLOW.
SO I read carefully
Hi,
I have the following tables in my database for proxy logs. I have broken
down the URL for each line into the following 4 tables:
url_schemes e.g. http
url_serverse.g. www.google.com
url_paths e.g. /search
url_queriese.g q="searchstring"
To get a list of the websites a user has
Hi,
What SQL function do I need to convert timestamp 200406011403 into
"2004-06-01 14:03" ?
Thanks,
JS.
_
Stay in touch with absent friends - get MSN Messenger
http://www.msn.co.uk/messenger
--
MySQL General Mailing List
For list a
date_added'];
$date = date("M d, Y", strtotime($date_added));
echo $date;
H and i do work in PHP as well, I believe, if you want to add the hour and
seconds. Check out the 'date' function in PHP for info.
- Eve
In MySQL you can do that with: DATE_FORMAT
DATE
1 - 100 of 893 matches
Mail list logo
