thanx alan!
is there any C API available to detect MySql
restarts!
which file(s) do i have to monitor so that i can track
server restarts.
> The server does not know how many times it has been
> restarted. You can
> easily enough write a wrapper script that keeps
> count, though. As for
> t
>From the InnoDB manual:
Dropping a table or deleting all rows from it is guaranteed to release the space
to other users, but remember that deleted rows can be physically removed only in
a purge operation after they are no longer needed in transaction rollback or
consistent read.
Perhaps that help
I've distilled my problem down to this: I am trying to figure out how to
build some indices on a couple of different tables so as to speed up a
search that involves searching on multiple columns from each of the
tables. Let's pretend I have two tables as follows and that I need to
do a query that
Have you looked at using the MS DTS and MyODBC to perform your
replication/synchronizing from Microsoft?
-Original Message-
From: Paul [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2003 4:31 AM
To: [EMAIL PROTECTED]
Subject: Synchronising SQL Server and MySQL
I need to synchronise a
Hello all,
I'm pretty new to MySQL, but have managed to create a database that is
accessed via PHP which then creates tables from the MySQL data.
Currently, I am using the root user/password combo to grab the info (which
means the password is plaintext in the PHP). I wanted to use the my.cnf to
Pushpinder Singh Garcha wrote:
hello all,
i hve been getting the 'mysql ended' error for over a wek now.when i
look into the log file this is what I get
This is from the error logs
030619 17:09:04 mysqld ended
030620 13:14:06 mysqld started
030620 13:14:09 InnoDB: Started
030620 13:14:09 Fa
On Fri, 2003-06-20 at 12:16, Barbara Andrew wrote:
> I have three books on mySQL, they all talk about how to
> construct SQL statements and I'm fine with that. What I can't figure out is
> how to get those statements to the right place without having to do it
> manually.
This would be the domai
No route to host is a TCP/IP connection thing. Check your settings.
Curtis
TheMechE said:
>
> Here's the log. Retrying...
>
> Moving info for table LogOutputStats
> Setting fields and metadata.
> Using original table.
> Tracking field is ResRefID
> Starting transfer.
>
> As the Pharoh says..
True, I have a Windows PC, however to test this I'm doing something like
this:
In Notepad I create a file test.asp
Write some ASP code into the file
Save the File
Upload the file to my remote host that works in Linux
Run my ASP script
See my script working ok
/*So ASP can run in a Linux Server wi
Hi there,
I'm just getting started with mySQL and PHP. I've used phpMyAdmin to create
tables and insert data into them from a delimited text file. From there I'm
creating a web page to view the data. Ideally this table would be refreshed
every night as it is a data dump from our production server.
hello all,
i hve been getting the 'mysql ended' error for over a wek now.when i
look into the log file this is what I get
This is from the error logs
030619 17:09:04 mysqld ended
030620 13:14:06 mysqld started
030620 13:14:09 InnoDB: Started
030620 13:14:09 Fatal error: Can't open privilege ta
The bug is:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 257 to server version: 4.0.14-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use sqlreg3;
Database changed
mysql> LOAD DATA LOCAL INFILE 'C:\\ProjetosD6\\MySQLBackup\\bina
Rick,
Sorry your request was taken in the wrong way, I get this request for
various things all the time and they are serious about it. I also see on
a regular basis people get two T1 connections from the same loop
provider, to the same ISP and call it redundant. So the question
remains, how ma
Sorry about my last comment, I check the documentation and the ODBC
connector (also called MyODBC) is indeed the driver for ODBC in Windows.
E!
- Original Message -
From: "Ernesto Silva" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 20, 2003 1:27 PM
Subject: Re: Connecti
If I recall well MyODBC is used when you want to access ODBC compliant
databases on a Linux based computer, however if you want to acces mySQL from
ASP means that you are programming on a Windows based computer, and
therefore you have ODBC client access built-in. What you need to do is to
create a
I had MySQL 3.23.56 on my RedHat machine but developed some problems
(that were probably my own fault) so I decided to upgrade to 4.0. I
downloaded the source rpm and rebuilt it on my system (running a fully
updated RedHat 9.0). I removed the old mysql by doing rpm -e on the
components; the
On 20-Jun-2003 Craig Harding wrote:
> 'url' has about 20 rows starting with 'disciplines/someurl' and I want
> to replace 'disciplines' with 'programs'. Is there a way to do this in
> mysql? I know I can do it in php, but it would be cool to do it, (and
> probably faster) to do it in mysql.
>
>
You can access MySQL databases from ASP by using MyODBC (now
Connector/ODBC) just like you would any other ODBC datasource. I would
suggest doing google searches on MyODBC and ASP in the same search, or
adapt some code from my site www.vbmysql.com, and look in the MyODBC FAQ
for examples. Also subs
1. check if /usr/local/mysql/data has mysql user and r/w privileges
2. if /usr/local/mysql/data doesn't exist You have to launch mysql_install_db
3. See the .err file in /usr/local/mysql/data
I wrote a sample tutotial for MacOS 10.2 at
http://www.santinoc.com/mysql.html
Santino
Content-Transfer-E
On 19-Jun-2003 vernon wrote:
>
> OK, I've done this.
>
> Problem occurs when a user selects 1 and 9.
>
> The SQL statement I have reads like so:
>
> if (isset($HTTP_GET_VARS['check00'])) {
> $age00 = '00';
> $s_age00 = "penpals.agegroup = $age00 AND";
> }
>
> Problem is the AND s
Hello,
I am trying to compile MySQL 3.23.57 on NetBSD 1.6.1. I downloadded
pthreads-1_60_beta6-mysql.tar.gz from your site and extracted it to
mysql-3.23.57/ I ran ./configure --with-mit-threads in mysql-3.23.57 and
everything went fine. However, when I run make, I get the following
errors after
[snip]
insert into OrdenServicio set folioOrdenServicio='', idCanal='1',
idTienda='107', idPedido='306', idProducto='503578', fallaCliente='no
prende', idEntregaControl='1', numSerie='7349843',
estaComponenteBase='1',
observaciones='', idStatusOrden='7', idCanalLevantamiento='1',
idTiendaLevant
Hi:
The weird thing is that not always do the same, I mean I always introduce
that insert query, but not always inserts a wrong date, sometimes the date
is correct.
Mikel
From: "Roger Baklund" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
CC: "Miguel Perez" <[EMAIL PROTECTED]>
Subject: Re: odd
I am trying to install MySql++ (1.7.9) onto my Mandrake 9.1.
Initially is indicated that it couldn;t find the mysql libraries and I
assume is because I installed Mysql as one of the install options when
installing Mandrake 9.1 as I believe it dosen't include the needed
libraries for mysql++.
I th
* Miguel Perez
> I have the following problem:
>
> When I insert a date in my table, and after do the insert I select the
> column date to see if the date is right but it displays the date like
> follows:
>
> 2019-06-20
>
> When the original insert is:
>
> 2003-06-19
You would get this resul
azamka wrote:
I installed mysql manually on red hat 9. It worked fine couple days but from
yesterday i am getting a weird error when i tried to run the mysql. the
error
statement is " Error 2002: Can't connect to local MySql server through
socket
'/tmp/mysql.sock'(2).
I am new user of Linux and I a
Here's the log. Retrying...
Moving info for table LogOutputStats
Setting fields and metadata.
Using original table.
Tracking field is ResRefID
Starting transfer.
As the Pharoh says... Ye who can interpert my dreams will become second
greatest in the LAAANNND
All the rest of you will get
Here is the table description:
mysql> show create table OrdenServicio;
| OrdenServicio |CREATE TABLE `OrdenServicio` (
`folioOrdenServicio` int(11) NOT NULL auto_increment,
`idCanal` int(3) NOT NULL default '0',
`idTienda` int(8) NOT NULL default '0',
`idPedido` int(8) NOT NULL default '0',
[snip]
insert into OrdenServicio set folioOrdenServicio='', idCanal='1',
idTienda='107', idPedido='306', idProducto='503578', fallaCliente='no
prende', idEntregaControl='1', numSerie='7349843',
estaComponenteBase='1',
observaciones='', idStatusOrden='7', idCanalLevantamiento='1',
idTiendaLevant
Hmmm I was having that issue when I shut my server down... i.e. the
mysql daemon... did you turn off your machine, and not have mysql
automatically boot up?
-Original Message-
From: azamka [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2003 4:07 PM
To: [EMAIL PROTECTED]
Subject
Hi:
Here is the insert query:
insert into OrdenServicio set folioOrdenServicio='', idCanal='1',
idTienda='107', idPedido='306', idProducto='503578', fallaCliente='no
prende', idEntregaControl='1', numSerie='7349843', estaComponenteBase='1',
observaciones='', idStatusOrden='7', idCanalLevantami
[snip]
When I insert a date in my table, and after do the insert I select the
column date to see if the date is right but it displays the date like
follows:
2019-06-20
When the original insert is:
2003-06-19
[/snip]
Please show us your insert query.
Jay
--
MySQL General Mailing List
For lis
Rolf,
You need to separate your functions. You are adding complexity to your
world by storing irrelvant infromation in your database. Critical Data
Handling (in a proper world) is ALWAYS handled separately from display. So
in your example,
You are storing all the html display formatting in your
On Fri, Jun 20, 2003 at 09:09:50AM -0500, Ray wrote:
> select 8 ^ 5;
> ERROR 1064: You have an error in your SQL syntax near '^ 5' at line 1
>
> i'm guessing that this means mysql 3.23 doesn't have the xor.
>
It was added in 4.0.2 according to the docs.
Try this:
mysql> select version();
+
Hi:
I have the following problem:
When I insert a date in my table, and after do the insert I select the
column date to see if the date is right but it displays the date like
follows:
2019-06-20
When the original insert is:
2003-06-19
I looked into the manual to figure out how mysql works w
I try install MySQL 3.23.56 from sources on my FreeBSD 4.8-STABLE
configure (./configure --enable-assembler --with-innodb) works fine, but
when I say "make",
I get next error :
--
Making all in extra
/usr/local/bin/bash ../libtool --mode=link
c -O3 -DDBUG_OFF -DHAVE_
In the last episode (Jun 20), Prem Soman said:
> that was very useful for me. can these UDF's provide a better way to
> access the sever specific information such as the date and number of
> times the server was restarted
The server does not know how many times it has been restarted. You can
easi
select 8 ^ 5;
ERROR 1064: You have an error in your SQL syntax near '^ 5' at line 1
i'm guessing that this means mysql 3.23 doesn't have the xor.
On Thursday 19 June 2003 11:52, Nicholas Elliott wrote:
> Remember that this is a binary XOR, not a logical XOR. Mysql does have a
> binary XOR operat
Try something like this:
UPDATE tablename SET url = concat("programs", substring(url,12)) where url
like ("disciplines/%");
Andy
> -Original Message-
> From: Craig Harding [mailto:[EMAIL PROTECTED]
> Sent: 20 June 2003 17:31
> To: [EMAIL PROTECTED]
> Subject: search and replace.
>
>
> I
Is there is a way to do a search and replace on the mysql cmd prompt? I
want to replace text in about 20 rows that has the same pattern with a
replacement.
I have a table that has a column 'name' and a column 'url' which holds
menu items for a website. Both columns are type varchar.
'url' has abo
I have created tables in a MySQL Database for importing data from an XML
file. My aim is to have MySQL table structures that correspond accurately
with the XML structure. What are the available ways to validate the two
structures or create the first structure from the second?
Also: From a proper
Hi Marcos,
you can use simple string-functions to manage this.
For example:
dd/mm/ -> -mm-dd
CONCAT_WS('-',RIGHT('dd/mm/',4),SUBSTRING('dd/mm/',4,2),LEFT('dd/mm/',2))
CONCAT_WS(separator, string_1 ,string_2 ...)puts strings together with separato
RIGTH(string,N)
use DATE_FORMAT(date, format)
e.g:
DATE_FORMAT("1999-12-01", "%M %e, %Y") -> "December 1, 1999"
*taken from Paul Dubois MySQL book
BRgds,
--
Richard Bornay
Test Data Managment
ST Assembly Test Services
6824-1367
"Marcos Pomar" <[EMAIL PROTECTED]>20/06/2003 05:36 PM
To: [EMAIL PR
Hi everybody,
Is there any function like Oracle TO_DATE in order to insert a date into a
DATE type field according to a different format than -mm-dd? I wish to
insert a date into a date field but my date format is "dd/mm/". If not,
is there any workaround using mysql functions? AFAIK my
thank u nelson!
that was very useful for me. can these UDF's provide a
better way to access the sever specific information
such as the date and number of times the server was
restarted
Want to chat instantly with your
I am currently working on some experiments and have to deal with some millions of
tuples. As you can imagine indexing is essentiall. However My InnoDB file has grown to
over 3.6G and fragmentation is sometimes a big problem. Additionally the file keeps
its size even after dropping the 'big' tabl
Hi!
The following essential change was forgotten from the changelog of 3.23.57
below, though it is listed in the MySQL-3.23.57 changelog:
* Changed the default value of innodb_flush_log_at_trx_commit from 0 to 1.
If you have not specified it explicitly in your my.cnf, and your application
runs mu
Hi!
InnoDB is a MySQL table type which supports transactions, foreign keys, and
a non-free hot backup tool. InnoDB is included in MySQL-Max-3.23 and in all
downloads of MySQL-4.0 and MySQL-4.1. You can download all of these from
http://www.mysql.com.
3.23.57 is a bugfix release of the old stable
Hi, I’m hosting a website in a Linux server. By now I’m learning PHP and
it’s amazing. How ever I need to create a online system and meanwhile
I’ll to do it in ASP (which I already handle). My host gives me MySQL
and I use it ok. Now, what I’ll like to do is to know how to connect my
ASP page to a
In the last episode (Jun 20), Prem Soman said:
> hi!
>
> Dynamic shared objects could enable user written code
> to be integrated with the server at run time! .
>
> Does MySql support shared objects, since MySql is an
> open source database i believe it can support DSO.
Yes, they're called User
50 matches
Mail list logo