Paul Nowosielski wrote:
On Thursday 25 May 2006 12:09, you wrote:
Paul Nowosielski wrote:
Dear all,
I've been testing our backup and recovery strategies here at work.
When dumping all the databases I'm using this command:
mysqldump --all-databases --force -u root -p -h 192.168.45.7
Paul Nowosielski wrote:
Dear all,
I've been testing our backup and recovery strategies here at work.
When dumping all the databases I'm using this command:
mysqldump --all-databases --force -u root -p -h 192.168.45.7 > all.sql
When this command is run I receive these error messages:
mysqldum
战芳 wrote:
>Hi! gerald_clark,
>But when I call mysql_pconnect("localhost:3306","root","root_password"),it
>return the same error. How can I get the permission to open
>/var/mysql/lib/mysql.sock?
> Fang
>
>
Jan Gomes wrote:
Hy Jay,
Thanks for you attention.
Show you my structure and EXPLAIN:
CREATE TABLE `table` (
`id_table1` int(10) unsigned NOT NULL default '0',
`id_table2` int(10) unsigned NOT NULL default '0',
`field1`smallint(5) unsigned NOT NULL default '0',
`field2`mediumint(8
Ben Clewett wrote:
Dear MySQL,
I've installed 5.1.9 from source on a SUSE 10 box. But I can't get
InnoDB tables respected.
I have used the correct compilation flag (--with-innodb).
SHOW VARIABLES; lists all the usual innodb variables.
The innodb table space has been created in ~/var/ibdata1
fool.ben wrote:
>Hi everybody!
>I've install a mysql server on my computer. The operating system is Redhat
>fedora core 4. The version of the mysql server is 4.1.3 Beta. I wanna connect
>to the server using the following statement:
>$db_connection=mysql_pconnect("localhost","root","");
>The serv
Jonathan Mangin wrote:
I'm creating a new MySQL database from an existing Filemaker db.
My problem is that some of the existing 'numbers' in one column (it
was a text field in FMP) have leading zeros. eg: 003, 0007, 012,
001234. I need to maintain these numbers 'as is' - complete with
zer
Chris Sansom wrote:
At 15:56 +0200 25/4/06, Barry wrote:
And you don't see any misdone queries when you echo them, right?
Hope you checked that.
Hi Barry
I was wrong about its being a PHP issue: it's definitely a MySQL
error. I realised I hadn't handled the error in such a way that I
cou
Ed Pauley II wrote:
I recently changed from SuSE ES 8 to RedHat ES 4 running MySQL 4.0.26
(I will be upgrading to at least 4.1 after busy season). I compiled my
own version this time and when I start the server I see only one
mysqld process. I am used to seeing hundreds as my max connect is se
I've checked the archives and found an explanation as to how the
check if a record is not in a many-to-many table. The answer to that
is somewhat simple and clear to me. But here's my problem: how do
you check if a record doesn't have a *particular* many-to-many
relationship? As in, let's
Duzenbury, Rich wrote:
Wow, I found the problem! I think this may be a bug.
In my case, I've got three instances running on ports 3306, 3307, and
3320. On the local machine, I connect to them via
mysql -p --port-3306 --host=localhost
mysql -p --port-3307 --host=localhost
mysql -p --port-3
George Law wrote:
This brings up a question I was asked...
Which is more efficient?
Select . where date between '-mm-dd hh:mm:ss' and '-mm-dd
hh:mm:ss'
This one.
Or
Select . where unix_timestamp(date) between
unix_timestamp('-mm-dd hh:mm:ss') and unix_timest
Bing Du wrote:
Hello everyone,
What I'm after is trying to figure out a way to centrally and remotely
managing (e.g. on server1) our MySQL servers (server2 is an example) on
different machines. Right now, these MySQL servers are all set up to only
accept logons from localhost. My questions:
Robert DiFalco wrote:
For me the argument is a little pedantic. The contract of the descriptor
table is that it must reference a name; there is code and constraints to
enforce this. I am happy to have the query return nulls to indicate a
programming error that can be quickly addressed. _If_ (aft
[EMAIL PROTECTED] wrote:
I'm moving a database to a new server. I'm using MySQL v5.0.16
on 'Windows. I used the MySQL Administrator to backup on the old
system and restore on the new one. Everything is fine _except_ on the
new server, some queries take 2-3 minutes with MySQL using 100% of t
Jon Miller wrote:
I'm still having a problem starting MySQL.
I get the following message:
Unable to initialise database connection: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
I've check the /etc/mysql/my.cnf and the sock file is supposed to load in '/var/ru
RedRed!com IT Department wrote:
So, for my peace of mind, I would need to follow these procedures to
ensure Martijn's issue doesn't happen:
1. lock the table
2. execute my select
3. insert if it does not already exist
4. unlock the table
On a high level, is this a correct list of procedure
fbsd_user wrote:
Thank you Gabriel, more background information may result in a
better concept, so here it is.
The web based application I am writing deals with people who have an
a home for rent. They can sign up for small fee and enter their
rental property into the application so its searcha
fbsd_user wrote:
Now I know what I am going to talk about is not directly related to
this mysql list, but I am in need of some concept ideas.
To set the background. It’s a very common practice in the
registration process of a new user to verify the users email address
is valid by sending a emai
Cory at SkyVantage wrote:
gerald_clark wrote:
How many possible values may res_status have? What percentage for
each value? It may not be possible to use an index on this field.
The res_status field may have up to 10 different values from 0-9. and
there will be a huge amounts of '0
Cory at SkyVantage wrote:
gerald_clark wrote:
Cory at SkyVantage wrote:
*** 1. row ***
id: 1
select_type: SIMPLE
table: status
type: ALL
possible_keys: NULL
key: NULL
key_len: NULL
ref: NULL
Cory at SkyVantage wrote:
I need help, I'm somewhat new to indexing, I am joining two tables and
need to optimize the speed of the query. I'm running the NDB storage
engine so the foreign key stuff is disabled. With that in mind,
here's the query and additional comments below:
SELECT COUNT(
Jeff wrote:
Currently I backup my MyISAM tables every night by running a shell
script that does the following:
Run:
Mysqlanalyze, mysqlrepair, mysqloptimize on all the tables
Then shutdown mysql
Then tar all the .MYI, .MYD and .frm files from the database's directory
to a backup director Star
rtroiana wrote:
Hi All,
I have recently noticed in the MySQL 5.0 documentation in section 11.3.1.
The DATETIME, DATE, and TIMESTAMP Types, it's mentioned that
"TIMESTAMP values cannot be earlier than 1970 or later than 2037. This means
that a date such as '1968-01-01', while legal as a D
bobgoodwin wrote:
I am running MySql 4.1.6 in FC-4 Linux amd it is a huge learning
exercise for me!
I am using O'Reilly's MYSQL Cookbook, have gone through numerous
pages of the "reference manual" and stuff on Google but still can get
the proper commands and syntax to alter the following
Yoed Anis wrote:
Hi all,
I'm trying to do the following.
I have three table:
Table a has address information:
address_id | City | State | Zip
1Austin TX 78758
2 Dallas TX 77000
3 Galveston TX 77550
Table b has information about the location:
address_id | Location_id | Location_na
Guillaume Boissiere wrote:
This must have been asked before but I could not find the answer searching
the list archives.
I have a simple table:
CREATE TABLE `license` (
`id` int(11) NOT NULL auto_increment,
`firstname` varchar(100) NOT NULL default '',
`lastname` varchar(100) NOT NULL default
[EMAIL PROTECTED] wrote:
"David Godsey" <[EMAIL PROTECTED]> wrote on 02/14/2006 03:28:41 PM:
Well, just thought I'd try one more time because I didn't get an answer
to
my question last time.
So what I have is a random data stream that is sent in raw form, and
based
on
Michael Joyner wrote:
(OT) (Windows ODBC/MySQL Debug) EMERGENCY HELP NEEDED
--
The Scenario:
~~
We out locked out of our door lock database.
The database is Sybase Sql Anywhere version 7.0
Th
Joseph E. Maxwell wrote:
FreeBSD / UNIX platform, MySQL ver.4.0.16
Prob. of growing /tmp file, solved by introducing a cron job to clean up
the folder intermittently. Prob.solve but new one created - mysql socket
wiped out. Could not restart the server with all the standard methods.
Complained
Ian Barnes wrote:
Hi,
This is my current query which works in mysql 4, but not in 5. Its from
mambo, but im trying to modify it because they don't officially support
mysql5 yet.
The original query:
SELECT c.*, g.name AS groupname, cc.name, u.name AS editor, f.content_id AS
frontpage, s.title A
Jon Miller wrote:
Having a problem connecting to a MySQL database from a mail server. In the
mail logs I'm getting:
mail MailScanner[4904]: Unable to initialise database connection: Can't connect
to MySQL server on '192.168.10.4' (110)
In the script that is running it has a mysql_connect sta
sheeri kritzer wrote:
Hi folks,
I'm attempting to optimize a query -- it's quite a simple one, actually.
SELECT uid from Bill_Sales WHERE startDate > '[some date]';
mysql> show create table Bill_Sales\G
*** 1. row ***
Table: Bill_Sales
Cre
Giandomenico Sica wrote:
Hi,
I've a little problem with mysqldump.
I'm using wordpress in localhost.
Now I'd like to put online my wordpress website, including the related
mysql database.
In order to make this operation, I've used the command:
"mysqldump database name"
This will dump to the
Russell Horn wrote:
I have a table containing a timestamp field, `insert_time`
The manual is clear when it comes to selecting records from the past
week or month, I can use:
SELECT COUNT(*) FROM statistics
WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= `insert_time`;
What I am less sure abo
Rhino wrote:
I have an automated backup script that has been running daily for a
couple of years now. It has never given me trouble until the last two
days. For the last two days, I have been getting this message when
backing up my newest database:
/usr/bin/mysqldump: Got error: 1064: You ha
Please do not hijack someone elses thread.
]Imran wrote:
Hello All:
I need to join three tables but I am not sure how to structure the query.
I need to join table1 to table2 and then join table3 to this result set.
So like (table1 join table2) join table3.
Table1 and Table2 will be joined o
Beau E. Cox wrote:
Hi -
I am trying to download the 5.1 development sources as per
the documentation; when I try this:
export PATH=/home/beau/src/bitkeeper/bk_client-1.1:$PATH
sfioball -r+ bk://mysql.bkbits.net/mysql-5.1 mysql-5.1
I get this:
ERROR-cannot cd to mysql-5.1 (illegal, nonexistan
wangxu wrote:
>Follow is my preform and result:
>-
>mysql> backup table ht_detail to '/';
>+++--+--+
>| Table | Op | Msg_type | Msg_text
age -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Aaron Morris" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, November 15, 2005 1:40 PM
Subject: Re: mysqldump
Aaron Morris wrote:
I have a very simple database I am trying to backup.
I run myslqdump and it
Aaron Morris wrote:
I have a very simple database I am trying to backup.
I run myslqdump and it gives me the code below.
That is not code. It is a file of sql statements.
Which does nothing but cause errors when I try to run it.
You can't run it.
It is input for the 'mysql' client p
Ben wrote:
hey,
Could you tell me someone please why this simple setup wont work!
I am using SuSE9.3 and trying to set this up:
$ mysql -uroot -e"insert into user(Host,User,Password)
values('localhost','guestbook',password('guestbook')" mysql -p
$ mysql -uroot -e"insert into user
Shaun wrote:
Hi,
When I create a table using my ISP's web control panel and I create a column
with a type of TINYINT it automatically creates a column with a value of
TINYINT(4).
After looking at the documentation on the MySQL site it is not exactly clear
what this means:
http://dev.mysq
Kristen G. Thorson wrote:
Hi all,
This may be a simple solution that I'm just not seeing. logrotate has
trouble with binlogs since the extension keeps changing, so instead of
actually rotating logs out, I just get a dir filled with
binlog.001.1
binlog.002.1
binlog.003.1
binlog.004.1
binlog
Barbara Deaton wrote:
Thank you for the link.
I understand that I need a mysql.sock file, what I don't understand is that I
used to get one when I installed MySQL. When I look through all my 4.0.x mysql
directories I see a socket directory that contains a mysql.sock file. With my
4.1 ins
bruce wrote:
hi...
i've got a question/problem that i can't seem to figure out. it should be
simple/straightforward.
i'm creating a test tbl
id int
t1 timestamp
when i do a 'select * from tbl' i get what looks like a default date/time
format in the timestamp column.
i do a, (from mysql)
'ins
bruce wrote:
hi...
i've been lloking over various open source apps to get a feel for how the
apps store and manipulate information as it's stored in the mysql db...
i see some apps that put "'"s around strings that get stored in the db, as
well as some apps that appear to put "'"s around numer
Perhaps you mean 'sed'.
Filipe Tomita wrote:
tks for reply but i dont have acces to original database... the dump file
not generated from me..
Someone tell me about "SAD" command to replace table name to correct name
but i dont find anything about it.
On 9/9/05, [EMAIL PROTECTED] <[EMAIL PR
Vladimir B. Tsarkov wrote:
Hello!
Be careful here Vladimir, the (\n) are not 'null' characters; but newline
characters.
Agree, I was wrong.
And i would highly recommend *not* replacing them with
tags as you write them into the database. This is asking for trouble on
so many
dEeZAcK SweETtY wrote:
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Jason Chan wrote:
I am using mysql 4.0.25 with no subquery support : (
"Jason Chan" <[EMAIL PROTECTED]> ¦b¶l¥ó news:[EMAIL PROTECTED]
¤¤¼¶¼g...
I have a student Table and a SubjectGrade table
Create Table Student(
StudentID INT NOT NULL,
StudentName VARCHAR(30)
)
Create Table SubjectGrade(
St
Tim Holmes wrote:
[Tim Holmes]
Gleb, et. al.
As you suggested, I have checked out the log files and this is what I
have found:
050713 11:00:09 mysqld started
050713 11:00:09 [Warning] Asked for 196608 thread stack, but got 126976
050713 11:00:09 [ERROR] Can't start server: Bind on TCP/IP p
Stephane Savage wrote:
Hi,
I'm quite new to mysql and I have a question regarding the server
configuration files. I have a server with 2 go of memory and I would
like to know the reason why when I run a query (select * from Mytable)
that returns 400k rows the my-medium configuration always run
David Ulevitch wrote:
On Jul 12, 2005, at 6:15 AM, gerald_clark wrote:
Nightly backup and binlogs can take you to any point in the day.
I failed to make my entire point clear then. That's true.
But when someone does the "oh fsck, I think I just ran a catastrophic
qu
David Ulevitch wrote:
[ Note to list admin, you are blocking messages from gmail.com ]
MySQL List,
I have a large MySQL database (around 20 gigs in total, some tables
>=3gigs. All tables are MyISAM. We have replication setup to a
number of slaves including one dedicated for backups.
All are
Tim Johnson wrote:
* Gleb Paharenko <[EMAIL PROTECTED]> [050711 07:17]:
Hello Gleb:
Check that you have correct permissions set on MySQL datadir.
See:
http://dev.mysql.com/doc/mysql/en/mysql-install-db.html
I will add to the comments above. I had to set the owner
and group to mysq
Alla-amin wrote:
Yes, 10.1.5 runs mysqk version 3, it was actually
running 3.23.51 and 10.3 runs 4.0.14 I think. Ok - the
database in question have been backedup with files
such as
table1.frm.gz
table1.MYD.gz
table1.MYI.gz
and so on.gz
When I create a new database on the new server and
copy the
Sajith A wrote:
Thank you Clark for your time
Try using straight joins to force MySQL to join from qb_test_result first.
The order chosen by the optimizer has no use for keys from this table.
I tried to force indexes.. but it didn't help
Thank you
Since the query you supplied cann
Sajith A wrote:
EXPLAIN SELECT qb_test_result.id resultId, qb_question.testId AS
testId, qb_test.title testName, qb_question.marks, qb_test.passrate,
qb_test_result.marks testMark, qb_test_result.percentage
testPercentage, qb_test_result.startTime, qb_test_result.endTime,
qb_test_result.status
mos wrote:
At 04:32 AM 6/15/2005, you wrote:
Hi,
I think of using AES Encryption for some time now, because it seems
to be
the most secure encryption method in MySQL at this moment
and table
encryption of some sort is not possible.
I really wish MySQL would support table wide encryptio
Yannick wrote:
Hey guys,
I am not able to install properly mysql. Please see below the technical
details or the bug report.
The installation goes well until I try to add the root user :
[EMAIL PROTECTED]:/usr/bin> mysqladmin -u root -h fujitsu password x
[EMAIL PROTECTED]:/usr/bin> my
Philip Lawatsch wrote:
Hi,
I'm trying hard to figure out how to perform a special query in mysql 4.0.
I have one table "widgets" which has a column "widget-id" (int) and one
column "number_of_parts" (int).
And then I have another table "part_mapping" which has one column
"widget-id" (int) and
Celona, Paul - AES wrote:
I am running mysql 4.0.18 on Windows 2003 server which also hosts my
apache tomcat server. My applet makes a connection to the mysql database
on the server as well as a socket connection to a service on the same
server. In the lab with only a hub between the client and
qin lei wrote:
> I have instal mysql in /usr/local/mysql. When I run the server. The
> message showed on the screen is as follows:
>
> [EMAIL PROTECTED] bin]# ./safe_mysqld &
> [1] 5122
> [EMAIL PROTECTED] bin]# Starting mysqld daemon with databases from
> /var/lib/mysql
> STOPPING server from pid
Matthew Simpson wrote:
I use Mysql to store call detail records from telephone calls. I have
around 20 voice switches that send the call detail records in real
time using INSERT statements.
I am having a problem where I need to delete "junk" call records that
get generated [old call records, c
Adam Lipscombe wrote:
I have MySql 4.1.12 installed on an XP box in C:\mysql.
I have the settings below in my C;\MySql\my.ini file:
I have the transaction-isolation set to READ-COMMITTED but the server seems
to ignore this.
When the server starts up the tx_isolation as reported by mysqladmin
extend
Tom wrote:
Thank you, Partha.
What I really meant was that the process of creating index was stopped and I
couldn't figure out and search out the log meaning 'Warning: Enabling keys got
errno 116, retrying'. So I am not sure I will run into such problem next time.
perror 116
Error code 116:
Rafael Diaz Valdes wrote:
Hi,
I 'm using mysqldump to backup my database, I wrote in my backup.sh the following string:
$MYSQL/bin/mysqldump --opt databasename -user=root --password=rootpassword >
backup/mysql/databasename.sql
I include backup.sh in my cron weekly (/etc/cron.weekly) but when it
Schalk Neethling wrote:
Greetings!
This might be a stupid question but here goes:
I have a table that contains a column entitled current_pos. I want to
search this table and then order the results by current_pos. Now I am
running the following SQL query on the table:
SELECT * FROM ab_leader_boar
[EMAIL PROTECTED] wrote:
Hi,
We're in the process of benchmarking/evaluating MySQL(4.1.9) on Linux for our data
warehouse. I have a group of tables (9/2004 through 2/2005) that average
about 95 million rows (215 byte rows). Using PERL and piping to mysql
LOAD DATA is the way we've been loading.
huanggaofeng wrote:
(B
(B>I have too many databases,when i select it by client ,but it has error .
(B>
(B>the error message is : java.lang.OutOfMemoryError
(B>
(B>how i can to resolve it.
(B>
(B>
(B>
(BYou might try a java list.
(B
(B
(B--
(BMySQL General Mailing List
(BFor list a
Eamon Daly wrote:
Easy enough. Get the numeric part via CONVERT, then get the
rest of the string from the length of the numeric part, plus
one:
SELECT
tag,
@num := CONVERT(tag, SIGNED) AS num_part,
SUBSTRING(tag, LENGTH(@num) + 1) AS rest_of_string from tags;
++--++
Rich Brant wrote:
I forgot the important part: what I want is to filter on a userID in the
person table such as -
SELECT u.Username, p.UserID
FROM Users u LEFT OUTER JOIN
Person p ON u.UserID = p.UserID
WHERE (p.UserID = 5) OR
(p.UserID IS
prathima rao wrote:
hai,
when ever the power goes or the system restarts when im entring data from my
vb application to mysql 4 database
it gets corrupted and i loose some data at the end please can any one help
me in this
regards
prathima rao
Get a backup powersupply with shutdown software.
Whe
StinkyPup wrote:
How do I auto-increment by a specific number. For example by 100:
You dont.
IDData
100 blah blah blah
200 blah blah foo
ALTER TABLE PRODUCT AUTO_INCREMENT = 100
doesn't do what I want to do.
TIA
--
MySQL General Mailing List
For list archives: http://lists.
C.F. Scheidecker Antunes wrote:
Hello all,
I now have disabled my SELinux and so it should work.
However it still does not work.
I have a bunch of errors now on my .err file that I am copying bellow.
I've tried to create the tables again by issuing mysql_install_db and
then
tried to run the daemon
Ludovic Coumétou wrote:
Hello,
I have been googling and asking on several forums with no luck, so I'm
coming here for the ultimate answer :) eheh
Is there a way to spell check a mysql column (or at least table)?
Thanks in advance
Ludovic
Several.
1. Dump - spell check - reload.
2. Write a progra
Dana Terrell wrote:
I am new to MySql and I am having troubles getting the primary keys to do
what I want. Here is the situation.
I am building a database where there are 2 types of users that can access
and change information. Because each type of user will be accessing a
different part of the d
Marco Neves wrote:
oix ppl,
Nobody have any sugestion that can me help with this issue?
thanks
mpneves
On Wednesday 16 March 2005 14:09, Marco Neves wrote:
Look under storage requirements in the manual.
You are MySQL core certified?
oix ppl,
sorry for the question, but I looked in the Manual on
Mister Jack wrote:
It returns :
select max(timestamp) as timestamp from news;
+-+
| timestamp |
+-+
| 2005-03-14 19:49:20 |
+-+
The string shown above converted into a number is 2005.
( Unless you think ist should be 1988 )
Ad
Mister Jack wrote:
Hi,
i'm using the 4.1.10 version of mysql.
If I do :
select max(timestamp + 0 ) as timestamp from news;
++
| timestamp |
++
| 20050314194920 |
++
so i got the full timestamp(14), but if I do :
select max(timestamp) + 0 as times
Chris Mason wrote:
I have two servers, server5.mydomain.com and server8.mydomain.com. I want to
replicate one database on server5 to server 8.
I did the whole proceedure as recommended in
http://dev.mysql.com/doc/mysql/en/replication-howto.html - 6.4. How to Set
Up Replication
I setup the GRANT sta
Xristos Karvouneas wrote:
Dear All,
I am faced with the following problem: I have got three tables -
book,author and authorbook - containing information about books and
authors (some books have multiple authors). I want to do a query that
would print information like:
Title 1 Author 1
Naveen C Joshi wrote:
Hi,
I have a InnoDB database with MySQL version 4.1.0-alpha installed on my RedHat Linux 9.0. The data files name is like *.frm, *.MYD, *.MYI".
These are MyIsam, not InnoDB.
Currently the table size is fixed 4GB and I want to extend it 10GB. Could you
please give me perfe
C.F. Scheidecker Antunes wrote:
Hello Mr Paharenko,
I have started it with mysqld_safe & and I also tried
/etc/rc.d/init.d/mysql start
Funny thing is that after install the the mysql and test databases are
empty so I've tried mysql_install_db which runs but the databases
remains empty as well.
Christopher Malton wrote:
When I use the statement:
EXPLAIN SELECT * FROM workunits WHERE Sent>0
It returns
+---+--+---++-++-++
| table | type | possible_keys | key| key_len | ref|
rows| Extra |
+---
[EMAIL PROTECTED] wrote:
All,
Can someone point me in the right direction ? I am trying to right sql
scripts for queries that will prompt for information.
Here is the gist of it, I have a sql script that will query a database
however I need the script to ask the user for IP address, and other
in
[EMAIL PROTECTED] wrote:
ALL,
I have an issue where MySQL has lost all of the table information for an
existing database, I do not know of anything that has changed and there
was no maintenance being done in MySQL. Below you will find the error
message as I receive it from MySQL.
ANY ideas or su
Ruben Edna wrote:
Here is create table def:
CREATE TABLE `tblmainupdateinfo` (
`MainID` int(11) unsigned NOT NULL default '0',
`ClientID` int(11) unsigned NOT NULL default '0',
`UpdateInfo` tinyint(4) unsigned NOT NULL default '0',
PRIMARY KEY (`MainID`,`ClientID`),
KEY `ClientID` (`ClientID
Alpesh Kothari wrote:
Hi,
I am facing problem while inserting more than 20,000 records using LOAD
DATA INFILE statement through comma seperated file.
Here is my statement:
LOAD DATA LOCAL INFILE '/home/mysql/isa_logs/a.txt' INTO TABLE
FirewallLog_1 FIELDS TERMINATED BY ',';
I have persistantly obs
sam wun wrote:
Hi,
I use MySQL 5.0 with perl (the latest version) in FreeBSD 5.3.
I found that if I assign a hard coded string (with double quote) to
the string variable which in turns become part of the SQL statement,
the SQL does return result.
If I assign a value which is return from an array
manasvini nandakumar wrote:
Hi all,
I have cross compiled mysql-4.1.7 (from the source distribution)for an IXP425
based board with Montavista Linux-3.0.When I run mysql_install_db --user=mysql
...It runs into several errors with the following log
[EMAIL PROTECTED]: /usr/local# ./bin/mysql_instal
John McCaskey wrote:
I'm currently doing a large number of REPLACE queries, I know that these
evaluate as if doing a DELETE/INSERT pair, and I'm wondering if this is
true on a disk io level as well with extra io occuring for the delete,
and then re-insertion, vs what would occur with an UPDATE.
Th
sharif islam wrote:
How mysql deals with spaces in table / column name? I am also using
mysqlcc. If I try the following in the doesn't work. Creating table
name with spaces from mysqlcc didn't give any error. But the following
does:
INSERT INTO 'tbl name with spaces' (col1, 'col name with spaces')
Patrick Marquetecken wrote:
Hi,
I have 3 snort sensors logging to a central mySQL database after two weeks the
size of the database is about 3.3GB and the machine is getting slow, as i'm not
used to be working with mySQL is my question how far can i go before the
machine stop responding ?
HP Pe
Ajay Kalambur wrote:
Hi
We have been having problems with a MySql database that runs on Linux.It
just occurred suddenly and was working fine before
Details:
MySql Version:# mysql Ver 14.7 Distrib 4.1.6-gamma
The filesystems which are accessed by MySql just hang.We cannot access any
of the tables.
Thomas McDonough wrote:
I'm trying to set all the values of column 'map' to the value of
column ML and '.png'. My intuition and an extensive reading of the
manual and mail archives tell me to do it like this:
mysql> update listings set map= concat (ML, '.png') where ML<>'';
mysql> update list
Eric Yeh wrote:
Hello,
I am a new user of MySQL and have a simple question I was hoping the list could
help me with.
I have been a long time Sybase user and am now looking at converting some of my
scripts to MySQL. I ordinarily run scripts as batch from the command line, and
parse the results
Joshua Beall wrote:
Hi All,
I have the following situation: I want to check a row in a database (list of
jobs that need to be run). So, my script checks the status field, and if it
is not started, then it marks it as locked and running, and when it
finishes, it marks it as completed.
Now, here is
Craig Cummings wrote:
Hi there,
I have a table with three columns, two varchar(12) identifiers and a
longtext column with very long (some > 50 MB) strings. The size of the
chromosomes.MYD table was about 2.8 GB. The table was used transiently
and I no longer needed to store the strings, so in th
1 - 100 of 615 matches
Mail list logo
