I have the following update procedure that update mySQL DB over the
internet between source Linux Centos (local machine on my net behind a
DMZ with real IP A.B.C.D) and target Linux fedora (web server
www.myweb.com) every day on a specific time 18:00 through a crontab on
my source linux server
ser
As an auditor once told me,
"If you can do your job, then I'm not doing my job."
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
--
MySQL General Mailing List
For list ar
Exactly what Johan said.
I keep structure like so:
develo...@mypse /var/www/dart2/UPDATES $ ll
-rw-rw-rw- 1 developer developer 551097 2009-12-22 23:16
airports_city_country.sql
drwxrwxrwx 2 developer developer 4096 2010-01-21 04:51 CVS
-rw-rw-rw- 1 developer developer 3063 2009-07-15 01:40 f
On 1/21/10 10:27 AM, "John Campbell" wrote:
> I want to find rows that contain a word that matches a term, accent
> insensitive: I am using utf8-general collation everywhere.
>
> attempt 1:
> SELECT * FROM t WHERE txt LIKE '%que%'
> Matches que qué, but also matches 'queue'
>
> attempt 1.5:
>
On Jan 21, 2010, at 9:27 AM, John Campbell wrote:
> I want to find rows that contain a word that matches a term, accent
> insensitive: I am using utf8-general collation everywhere.
>
> attempt 1:
> SELECT * FROM t WHERE txt LIKE '%que%'
> Matches que qué, but also matches 'queue'
>
> attempt 1
The best way is to keep track of all individual changes to your
staging environment, including fire-and-forget style scripts; and
apply those to your production environment as needed. This is part of
the process of change management, and generally a very good idea :-)
Lacking that, there are sever
I have a two databases, one in a production environment (let's call it db_prod)
and the other in a testing environments (Let's call it db_test).
What is the best way to synchronize the database schemas? db_test has had a
few indexes and constraints added to several tables and I need to generate
At 06:15 AM 1/21/2010, Krishna Chandra Prajapati wrote:
Hi Abhishek.
insert, select and delete are in the same proportion.
1. Inserted data into a table A by user.
2. Selecting data from table A inserting data to table B after applying some
rules(update).
3. Deleting data from table A.
4. Selec
I want to find rows that contain a word that matches a term, accent
insensitive: I am using utf8-general collation everywhere.
attempt 1:
SELECT * FROM t WHERE txt LIKE '%que%'
Matches que qué, but also matches 'queue'
attempt 1.5:
SELECT * FROM t WHERE txt LIKE '% que %' OR LIKE 'que %' OR LIKE
that's exactly how i do it.
On 1/19/10 3:57 PM, "Intell! Soft" wrote:
> Thanks! - I found a Insert Into on your tip:
>
> Insert Into Lieferanten (Lieferant)
> select distinct
> a.lieferant
> from artikelstamm a
> left join lieferanten b on
> a.lieferant = b.lieferant
> where
> b.lief
On 1/19/2010 7:49 AM, Mark Goodge wrote:
On 19/01/2010 14:44, Tompkins Neil wrote:
Hi All,
Following on from my earlier email - I've the following question now :
I can enforce that the user can't use the same password as the
previous four
- when they change their password. However, the user ca
Krishna Chandra Prajapati wrote:
Hi list,
I want to insert 1 records/sec into table. There can be n number of
tables with unique data in each. What are the possible ways to do ?
Thanks,
Krishna
The manual is your friend. It doesn't hurt to consult it.
INSERT ...
http://dev.mysql.com/doc
Krishna Chandra Prajapati wrote:
Hi List,
I am working for a messaging company, sending sms to enterprise customers.
In a mysql table data is being continuously inserted by user. Most of the
time we have 5 to 10 millions of data in this table.
Table name : alt_send_sms engine myisam
From this
Hi list,
Out of the below load balancer which is the best one. Is there any other
load balancer available.
1 mysql proxy (Still alpha)
2 ultramonkey.
3 haproxy
Thanks,
Krishna
On Thu, Jan 21, 2010 at 7:15 AM, Krishna Chandra Prajapati
wrote:
> 1. Inserted data into a table A by user.
> 2. Selecting data from table A inserting data to table B after applying some
> rules(update).
> 3. Deleting data from table A.
> 4. Selecting data from table B using some conditions (SELE
Hi list,
I want to insert 1 records/sec into table. There can be n number of
tables with unique data in each. What are the possible ways to do ?
Thanks,
Krishna
Hi Abhishek.
insert, select and delete are in the same proportion.
1. Inserted data into a table A by user.
2. Selecting data from table A inserting data to table B after applying some
rules(update).
3. Deleting data from table A.
4. Selecting data from table B using some conditions (SELECT sql_i
On Thu, Jan 21, 2010 at 5:18 PM, Suresh Kuna wrote:
> Innodb contains multi-version property, so it can handle more concurrent
> queries from user connections.
>
>
> On Thu, Jan 21, 2010 at 5:07 PM, Krishna Chandra Prajapati <
> prajapat...@gmail.com> wrote:
>
> > Hi Suresh,
> >
> > my question is
Innodb contains multi-version property, so it can handle more concurrent
queries from user connections.
On Thu, Jan 21, 2010 at 5:07 PM, Krishna Chandra Prajapati <
prajapat...@gmail.com> wrote:
> Hi Suresh,
>
> my question is how i can run concurrent connection with the above work
> load.
>
> T
On 21/01/2010 11:07, Lucio Chiappetti wrote:
On Tue, 19 Jan 2010, Tompkins Neil wrote:
I can enforce that the user can't use the same password as the
previous four
- when they change their password. However, the user can manipulate
this by
changing the password four times and then resetting bac
Hi Suresh,
my question is how i can run concurrent connection with the above work load.
Thanks,
Krishna
On Thu, Jan 21, 2010 at 4:46 PM, Suresh Kuna wrote:
> Hi Krishna,
> As table is using MyISAM engine and it acquires a table level lock, the
> queries will be executed one after one .
> By con
Hi Krishna,
As table is using MyISAM engine and it acquires a table level lock, the
queries will be executed one after one .
By converting it into Innodb as it acquires a row level lock, doing a select
and delete based on primary key will be faster and the concurrency
increases.
--
Thanks
Suresh
On Tue, 19 Jan 2010, Tompkins Neil wrote:
I can enforce that the user can't use the same password as the previous four
- when they change their password. However, the user can manipulate this by
changing the password four times and then resetting back to there original
password. How would I ov
Hi List,
I am working for a messaging company, sending sms to enterprise customers.
In a mysql table data is being continuously inserted by user. Most of the
time we have 5 to 10 millions of data in this table.
Table name : alt_send_sms engine myisam
>From this table, i need to select data base
Jerome Macaranas schrieb:
> im trying to setup mysql slave but the things is it wont start because of
> this errror:
>
> --> ERROR 1200 (HY000): The server is not configured as slave; fix in config
> file or with CHANGE MASTER TO
>
> after some testing.. i saw the server-id = 0
> through > show
25 matches
Mail list logo