Hi all,
Looking for a way to automate backup I was thinking of scheduling mysqldump on
a daily base. It want to use the read lock, but I am not really sure about the
consequences of this.
Does putting a read lock on the files can cause loss of data?
It is no problem pausing the flow of
Hi,
In my system my.cnf is in
/etc/ directory.
Bye.
On Fri, 10 Dec 2004 Hiu Yen Onn wrote :
hi,
i compiled mysql-4.1.7 from source. actually, i want to configure a mysql
cluster. from the documentation, i need to add some flag into a file called
my.cnf. i searched through the files. it
Hi everyone,
recently I encountered the following problem:
SELECT COUNT(id) FROM sometable WHERE somevarchar LIKE 'thistext ';
returned 0 (of course!) because trailing blanks can't exist in a column of
type VARCHAR.
But: Shouldn't the constant be truncated automatically in this context
before
hello,
i hv created a table with 11 fields. two of them where i m getting problem
are country name and the country code
all other fields work properly during selection except these two
fileds are : (country varchar(30),code char(2));
when i retrieve records using follwg query :
select * from
On Wednesday 08 December 2004 05:07, Patrick Sherrill wrote:
David,
Please provide the complete LOAD DATA INFILE command you used.
mysql -e LOAD DATA INFILE '/home/dlubowa/clients.csv' INTO TABLE bush -p
test
thats what i did ...
Pat...
[EMAIL PROTECTED]
CocoNet Corporation
SW
My spam filter got the mysql list in a fit and I want to know why. However,
since the emails were blocked, I can not look at the headers, which is what
I need to do.
There are two emails, subjects are
Where overload: Is there such a thing
http://lists.mysql.com/mysql/176634
-and-
handshake
hello,
i hv a database ONE with some 10 tables;
i want to have a backup so how can i copy these tales to another database
in the same server and also to any other server?
N. Kavithashree
===
Hello!
I have been struggling with this, and don´t know how to move on.
I have several databases they have the same stucture.
I want to gather all data från one type of table in the databases to
another table: merge-union operation.
I have done that operation and it looks okay, but aren´t.
On Thursday 09 December 2004 14:33, David Ziggy Lubowa wrote:
On Wednesday 08 December 2004 05:07, Patrick Sherrill wrote:
David,
Please provide the complete LOAD DATA INFILE command you used.
mysql -e LOAD DATA INFILE '/home/dlubowa/clients.csv' INTO TABLE bush
-p test
this is test
Table chat_online:
session (varchar)
activity (datetime)
Table persons
persons_region_int(int)
Table regions
region_id
region_name
On a page i list all persons which are in the chat_online dbase and
within a certain period:
$limit_time = time() - 130; // 2 Minutes time out. 60 * 2 = 120
Dear Sirs,
Our company is developing software
forSetTopBox STI 5528. We are interested in using your DBMS.
Our target platform is STI5528 (SH4 (Hitachi)
compliant) platform.
OS Linux: kernel 2.4.24Compiler: gcc
3.03
Our attempts to install 4th or 5th version of MySQL
on our platform
Looks like i have solved the issue, thanks guys for the help
this did the trick
mysql load data infile '/home/dlubowa/test' into table bush fields terminated
by ',' (clients,location,service,PhoneNo,contact,emails);
-Z
On Thursday 09 December 2004 15:54, David Ziggy Lubowa wrote:
On
David Ziggy Lubowa wrote:
On Thursday 09 December 2004 14:33, David Ziggy Lubowa wrote:
On Wednesday 08 December 2004 05:07, Patrick Sherrill wrote:
David,
Please provide the complete LOAD DATA INFILE command you used.
mysql -e LOAD DATA INFILE '/home/dlubowa/clients.csv' INTO TABLE
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 Pentium4 - 2.2mhz - 512 mb,
On Thursday 09 December 2004 09:49 am, Patrick Marquetecken wrote:
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
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
It can be a service that this running and you this saturating the yield of the
CPU. top in a terminal like root uses the command to be able to see that
service this consuming.
greetings
--
Ing.. Bismarck J. Rojas M.
El Jueves, 9 de Diciembre de 2004 09:49, Patrick Marquetecken escribió:
On Thu, 2004-12-09 at 10:08 -0600, gerald_clark wrote:
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
David,
Ian's response looks fine, I would just add 'OPTIONALLY' to the 'ENCLOSED '
parameter:
mysql -e LOAD DATA INFILE '/home/dlubowa/clients.csv' INTO TABLE bush
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' .
This may not work if your entire record is wrapped in quotes as indicated in
I searched the archives but couldn't fine much on the QueryBrowser. I
think it's still pretty new. Is anyone else experience frequent crashes
using this software?
After about 6 queries or so (mild use) it crashes randomly.
./mysql-query-browser: line 9: 19346 Segmentation fault
What you need to do is rename one of the .cnf files - such as my-small.cnf -
to my.cnf and copy it into your /etc/ directory (on Linux, Windows directory
in Windows).
- Eve
-Original Message-
From: Hiu Yen Onn [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 09, 2004 3:28 PM
To:
Hi all,
I am experiencing a fairly bizarre problem: in MySQL 4.1.7 (Windoze
version), when importing data from a file with semicolon-separated data, I
get random default values for the datetime fields. This turns the data
obviosly unusable.
The same import on the same machine but with the
At the end of your csv file, are you including ,\n ?
If you are using mysql on windows and LOAD DATA IN FILE you need to
include unix line breaks at the end of each line, else the data will
be loaded wacky...so if each line looks like this:
,value1,value2,value3,value4
change it to this: (on
I have a sql script that issues a bunch of truncate statements to purge
a database in development. The script looks like:
truncate table table_1;
truncate table tabel_2;
truncate table table_3;
and so on...
I can load this script as a single query in the old mysql_front (version
2.2) GUI and
Last week we upgraded from mysql 4.0 to 4.1.7. Since then some queries
on newly created tables (ie created since the upgrade) are failing with
the error:
#1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT)
and (utf8_general_ci,COERCIBLE) for operation '='
I have been doing a
On Thu, 09 Dec 2004 16:17:17 +
Darryl Waterhouse [EMAIL PROTECTED] wrote:
On Thu, 2004-12-09 at 10:08 -0600, gerald_clark wrote:
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
On Thursday 09 December 2004 01:06 pm, Patrick Marquetecken wrote:
and for ansewring Jeff Smelser i have installed mysql 4.x on linux and then
dit from the commandline create database and then run the create table
commands from snort.
No idea.. you can do a show create table db.table to find
Hello world,
I am passing a a string Joe's car as part of the SQL query to be inserted
to a String field.
$field=Joe's car;
$query=insert into mytable values('$field');
Do you generally change the quote to a double quote before inserting
or what is the recomended way, because otherwise the
backslash escape the quote:
$field=Joe\'s car;
or if you're using PHP you can turn this on automatically
HTH
Steve
Nestor Florez wrote:
Hello world,
I am passing a a string Joe's car as part of the SQL query to be inserted
to a String field.
$field=Joe's car;
$query=insert into mytable
This is a very broad question, I sometimes do this myself. But to answer
the question to the best of my ability I have to ask a few.
Are you using RAID? If so what RAID level?
What are you're my.cnf settings?
What type of Indexes are you using?
What does vmstat and iostat say?
What
Nestor,
You would do better to use prepared statements.
When a parameter is substituted into the prepared statement it is
automatically quoted -- and you are protected from SQL Injection
attacks. The reason your script is failing is that the single quote in
$field is being interpreted as the
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') VALUES(15,16);
--
Behind the scenes mysqlcc wraps the both the table name with spaces and
the column name with spaces with back-ticks (`) not single quotes(').
http://dev.mysql.com/doc/mysql/en/Legal_names.html
Try this statement instead:
INSERT INTO `tbl name with spaces` (col1, `col name with spaces`)
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
Thanks !
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 08, 2004 3:18 AM
To: [EMAIL PROTECTED]
Subject: Re: Load data question in cross database replication
Hello.
It seems to be a bug:
http://bugs.mysql.com/bug.php?id=6353
Sanjeev Sagar
Thomas Spahni wrote:
Hi everyone,
recently I encountered the following problem:
SELECT COUNT(id) FROM sometable WHERE somevarchar LIKE 'thistext ';
returned 0 (of course!) because trailing blanks can't exist in a column of
type VARCHAR.
But: Shouldn't the constant be truncated automatically in
N. Kavithashree wrote:
when i retrieve records using follwg query :
select * from table where country='United States' and code='US';
Is the value if the country field United States? Or is it United
States of America or similar?
But if i give :s
select * from table where country like 'United S%'
N. Kavithashree wrote:
hello,
i hv a database ONE with some 10 tables;
i want to have a backup so how can i copy these tales to another database
in the same server and also to any other server?
The mysqldump utility can be used for this kind of things:
URL:
hi all...
where can i see what these warnings are. i get them when i do load data
infile.
i was looking for some kind of log under /var/logs/ or mysql/var/log but
there isn't a log file for mysql at any of those locations. and the
mysql/var/ doesn't exist at all.
i created it and redid the load
Command is SHOW WARNINGS;
You can run this from either the command line or from the MySQL CC SQL viewer.
J.R.
-Original Message-
From: kalin mintchev [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 09, 2004 6:53 PM
To: [EMAIL PROTECTED]
Subject: Deleted: 0 Skipped: 0 Warnings: a
Command is SHOW WARNINGS;
You can run this from either the command line or from the MySQL CC SQL
viewer.
thanks.. but from the command line i get:
Check the manual that corresponds to your MySQL server version for the
right syntax to use near 'warnings' at line 1
is mysql-standard-4.0.13 to
I have never had a problem running that command, however you do have to run it
right after you run
your query (or LOAD DATA). That may be why you can't use it.
Also, try looking under HOSTNAME.ERR instead of a log file. That might help
out.
J.R.
-Original Message-
From: kalin
I have never had a problem running that command, however you do have to
run it right after you run
your query (or LOAD DATA). That may be why you can't use it.
that's what i did. here, this is straight from the cl of the mysql client:
Query OK, 415 rows affected (0.01 sec)
Records: 415
ok... i just saw this in the manual:
This command is implemented in MySQL 4.1.0
that's why it doesn't work... mine is 4.0.13.
so what do people that have earlier versions then 4.1 do to see the
warnings?!
I have never had a problem running that command, however you do have to
run it right
Hi ALL,
CONTEXT USE Example:
#include sqlca.h
#include ociextp.h
main()
{
sql_context ctx1;
char *usr1 = scott/tiger;
EXEC SQL CONTEXT ALLOCATE :ctx1; //Create Context
EXEC SQL CONTEXT USE :ctx1; // Use Context
EXEC SQL CONNECT :usr1;
EXEC SQL CONTEXT USE DEFAULT;
EXEC SQL INSERT INTO
In the last episode (Dec 09), kalin mintchev said:
From: kalin mintchev [mailto:[EMAIL PROTECTED]
Command is SHOW WARNINGS;
You can run this from either the command line or from the MySQL CC SQL
viewer.
thanks.. but from the command line i get:
Check the manual that corresponds to
Hi ALL,
CONTEXT USE Example:
#include sqlca.h
#include ociextp.h
main()
{
sql_context ctx1;
char *usr1 = scott/tiger;
EXEC SQL CONTEXT ALLOCATE :ctx1; //Create Context
EXEC SQL CONTEXT USE :ctx1; // Use Context
EXEC SQL CONNECT :usr1;
EXEC SQL CONTEXT USE DEFAULT;
EXEC SQL INSERT INTO emp
47 matches
Mail list logo