Hi
I need set up a backup strategy for a mysql database in a ubuntu server,
the database will grow up to a 5TB.
What would be the best option ?? Maybe a script that uses mysqldump?? There
is a better way to do this?
Thanks in advance to all
Pedro.
st me?
Dan Nelson escreveu:
In the last episode (Jul 23), Pedro Belmino said:
I do a system log of their log everything that is done(INSERTS, UPDADES
and DELETES). Okay, can be done with trigger. But I need to know who
performed the operation. How can I get get it inside the trigger?
Tr
Sorry, not specified what I wanted to get inside the trigger. I would
pick who is running the operation.
Pedro Belmino escreveu:
I do a system log of their log everything that is done(INSERTS, UPDADES
and DELETES). Okay, can be done with trigger. But I need to know who
performed the operation
iente'
____
Pedro Belmino
Desenvolvedor
ArgoHost.net
Hospedagem Web com Facilidade
http://www.argohost.net
Suporte Telefônico: (85) 3264 9944 / (11) 4063 4844
Contato direto: Ramal 107
E-mail: [EMAIL PROTECTED]
begin:vcard
fn:Pedro Belmino
n:;Pedro Belmino
org:Argohost.net;TI
adr:;;;Fo
, RAND() LIMIT 11
(the php vars have correct values)
Please apologise my bad English.
Thanks in advance.
Pedro.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
logies for my bad English.
Pedro.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ons like:
.bdd
.ind
.mor
.ped
Thanks in advance.
Apologies for my bad English.
Pedro.
MySQL version is 5.0.19. Runs in Win. XP pack 2. I put sql in command line and i
try using jdbc.
The code:
SELECT mfn,COALESCE (user_id,0)
FROM hits WHERE mfn =1;
Citando "Logan, David (SST - Adelaide)" <[EMAIL PROTECTED]>:
> Hi Pedro,
>
> What version
arset on all the tables is latin1, using Mysql 5.
Thanks in advance.
Pedro.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Greetings!
I am building a website using MySQL 5.0.18 and PHP 5.1.2.
When I try to insert in a table a timestamp value from php's mktime() I get
the following error:
1292: Incorrect datetime value: '1139776424' for column 'access_date' at row
1
The sql for the table is:
CREATE TABLE `members_acs`
> -Mensagem original-
> De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>
> "pedro mpa" <[EMAIL PROTECTED]> wrote on 01/31/2006 12:49:48 AM:
>
> > Greetings.
> >
> > I need help on the following query.
> > I get an error like
id_receipt=receipts.id) AS total_price
FROM receipts
WHERE
total_price >= ".$minprice." "
AND total_price <= ".$maxprice." "
ORDER BY receipts.date DESC
Thanks in advance.
Pedro.
--
MySQ
Solved.
Thanks.
-Mensagem original-
De: pedro mpa [mailto:[EMAIL PROTECTED]
Enviada: domingo, 29 de Janeiro de 2006 18:25
Para: mysql@lists.mysql.com
Assunto: Help on query joining a 3rd table
Hello!
I am building a query to get a monthly total for receipts and receipts plus
TAX.
My
r."
Thanks in advance.
Pedro.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I think this is what you want to do:
SELECT t1.Division,t1.year, t1.units this_year_units, t2.units
last_year_units, case when t2.units is null then t1.units else
(t1.units-t2.units) end as Difference_Units
FROM `narra_table` t1 left join narra_table t2
on (t1.Division=t2.Division) and (t1.Ye
2
35 item3
(Running Mysql 4.1.9 and PHP 5.0.4).
Thanks in advance.
Apologies for my bad English.
Pedro.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
as far as I know a schema is a description of a database.
[EMAIL PROTECTED] wrote:
What is a schema? How is different from a database?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I had a similar problem while connecting to mysql 4.0.21 throuhg MyODBC
3.51.11.
If so you must upgrade mysql to 4.1 or downgrade MyOdbc to 3.51.06
Jason Williard wrote:
Hello,
Today, I started experiencing some issues on our website with max
connections exceeded errors. In looking into th
I have been able to create your table in my mysql 4.1.12
I think your remote server is in mysql 4.0 series
[EMAIL PROTECTED] wrote:
- Original Message -
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, July 19, 2005 10:08 PM
Subject: table export problem
Hi all,
I
search for "my-medium.ini"
[EMAIL PROTECTED] wrote:
Dear Sir or Madam:
After installing mysql, the template files, my-small.cnf, my-medium.cnf or
my-large.cnf, were not created. I uninstalled and then reinstalled mysql, but
they were still not created. I am using mysql-4.0.20a-win on Windo
You can use:
SELECT ..
order by case substring(Name,1,4) when 'The ' then
substring(Name,5,800) else Name end
Un saludo
Juan Pedro
Jack Lauman wrote:
I'm using a query similar to the following to get an ordered list.
SELECT ORDER BY Subscriber ASC, Name ASC;
You can use:
SELECT ..
order by case substring(Name,1,4) when 'The ' then
substring(Name,5,800) else Name end
Un saludo
Juan Pedro
Jack Lauman wrote:
I'm using a query similar to the following to get an ordered list.
SELECT ORDER BY Subscriber ASC, Name ASC;
How d
:
- Original Message - From: "Juan Pedro Reyes Molina"
<[EMAIL PROTECTED]>
To: "Hassan Schroeder" <[EMAIL PROTECTED]>
Cc: "mysql general list"
Sent: Saturday, June 25, 2005 2:08 PM
Subject: Re: starting mysql 4.1.12 on Ubuntu Linux
hello, Hassan
which
ks, Hassan
Hassan Schroeder wrote:
Juan Pedro Reyes Molina wrote:
which mysql gives me /usr/bin/mysql. echo $PATH shows me that
/usr/bin is the fourth try. I thougth this was windows like, where
PATH is only used if program is not found in active directory.
Executables in the 'curren
buntu distro.
I have tried cp /etc/init.d/mysql /etc/init.d/mysqltmp but issuing
/etc/init.d/mysqltmp gives me "bash: mysqltmp: command not found"
Hassan Schroeder wrote:
Juan Pedro Reyes Molina wrote:
With my sql stopped I go to console as root and write:
cd /etc/init.d
mysql s
I'm starting to play with linux. Till now I have over my shoulders three
days experience with it :-)
I have been able to install and successfully run mysql 4.1.12 but
something it's happening I cannot understand (no surprise)
With my sql stopped I go to console as root and write:
cd /etc/ini
chine traslations are far
from perfect but it can be understood.
Un saludo
Juan Pedro
[EMAIL PROTECTED] wrote:
Juan,
i found you a link explaining the access and sqlserver ansi inner joins in
update. it's in german, but can be read (i don't speak german :o)) :
http://www.sql-und-xml.
select in a sybquery using the same table "master".
use tempo table for the join and update after.
Mathias
Selon Juan Pedro Reyes Molina <[EMAIL PROTECTED]>:
I'm running mysql 4.1.7.
For the sake of this message I have created this tables:
CREATE TABLE `log` (
`ID` int(
I'm running mysql 4.1.7.
For the sake of this message I have created this tables:
CREATE TABLE `log` (
`ID` int(11) NOT NULL auto_increment,
`Cod_P` varchar(5) NOT NULL default '',
`Import` double NOT NULL default '0',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM;
CREATE TABLE `master` (
`Cod_P` varch
I installed mysql under RedHat 9 with
mysql-standard-4.1.1-alpha-pc-linux-i686.tar.gz but when I try to start the mysqld
with the sentence "./bin/mysqld_safe &" it gives me this message:
[EMAIL PROTECTED] mysql]# ./bin/mysqld_safe &
[1] 2341
[EMAIL PROTECTED] mysql]# Starting mysqld daemon wit
I found what was missing.
I put distinct into the 'count( )' tag then it resolve the problem.
Tkz for all
Joao Pedro
- Original Message -
From: "Joao Pedro" <[EMAIL PROTECTED]>
To: "Joao Pedro" <[EMAIL PROTECTED]>
Sent: Thursday, January 0
times that appear in tables
B, C and D. Therefore if it has 1 register in B, 2 in C and 3 in D. Then it
appears 6 as reply in each item, being that it would have to appear 1, 2 and
3 respectively.
I am thankful very if somebody will be able to help me?
Best Regards,
Joao Pedro
--
MySQL General Ma
Dear all,
I have the following problem,
I am trying to select records from two tables.
the tables are constructed like:
block
block_id
sequence_id
snp_required
first_polymorphism_index
last_polymorphism_index
first_reference_positio
last_reference_position
start_pos
end_pos
tiled_bp
polymorphis
Hi all,
Can I link two fields in two tables, in the way that if I add a new value
into a table in the other table the value is added automatically, or Do
I need to add the values one time for every table?
Thanks for helping me.
Pedro
--
MySQL General Mailing List
For list archives: http
2)
UNIQUE KEY idx2 (relation_id)
) type MyISAM;
And the query will be like:
SELECT location_name, location_name, distance
FROM locations AS l, relations AS r
WHERE l.location_id=r.location_id1
ANDl.location_id=r.location_id2;
Thanks for your help
Pedro
--
MySQL General Mailing Li
Hi,
I also tried that but the same result, mysql_ping doesn't return immediately.
Any other hint please?
Thank you very much.
Pedro
Gelu Gogancea wrote:
> Hi,
> In this case i guess is better to execute mysql_ping() before mysql_query().
>
>
Hi,
In this case I do have a DNS server. Any other hint please? I strongly need
mysql_query to return immediately if connection is lost with the server. Any
configuration parameter or similar on MySQL? Need to reconfigure something in
the OS?
Thanks.
Pedro
Gelu Gogancea wrote:
> Hi,
>
Thank you.
Pedro
--
|\
| \
| \
|___\
| |
ocelyn
> - Original Message -
> From: "Pedro Vasconcelos" <[EMAIL PROTECTED]>
> To: "Paul DuBois" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Saturday, February 15, 2003 6:20 PM
> Subject: Re: Report a bug
>
>
> > > It wo
> It works fine on Unix. Is "Aux" a special filename in Windows?
Not that i am aware of.
Maybe you should try this on Windows. I could be just a problem on
windows version.
Thanks.
On Sat, 15 Feb 2003, Paul DuBois wrote:
> At 18:10 +0000 2/15/03, Pedro Vasconcel
00),(100.22),(101.00),(102.00);
UNLOCK TABLES;
when i try this command:
mysql -u USER -p DATABASE At 17:44 + 2/15/03, Pedro Vasconcelos wrote:
> >if you have a file NameOfFile.sql where you have a table named Aux and you
> >try to create it using:
> > mysql -u USER -p DATABA
if you have a file NameOfFile.sql where you have a table named Aux and you
try to create it using:
mysql -u USER -p DATABASE http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e
Any help from good samaritans? I have no idea to solve this mess!
TIA
- Original Message -
From: "Pedro Leite" <[EMAIL PROTECTED]>
To: "TdA" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, January 27, 2003 10:23 AM
Subject: Re: mysql.sock i
Hi, I'm getting the same error message. mysql here is in /etc/rc.d/init.d,
don't ask me why, I'm new to this things.
Any more help would be much appreciated.
TIA
- Original Message -
From: "TdA" <[EMAIL PROTECTED]>
To: "Pedro Leite" <[EMAIL P
o to
recover/reinstall/run the mysql server again? I didn't find mysql.server,
but I do have mysql.server* on dir /usr/share/mysql. I'm running Mandrake 9
and Mysql-323.54a (rpm).
Thank you in advance
Pedro
---
art, server.stop and
mysql.sock anywhere, anymore!! It seems to me that MySQL simply vanished
from the box after the reboot!! Why? Any ideas? What can I do now?
I'm running Mandrake 9.0, MySql 3.23.54a (RPM)
I appreciate any help from you. I have no idea what
)). Anyway, I read more carefully the manual of
Innodb and I found the answers in the chapter 6. Seems
that Hot Backup it's a nice tool and we have the
option of recover from the logfiles too. Best regards.
>
> Pedro Rocadas wrote:
>
> >Greetings.
> >
> >Two days ago
Greetings.
Two days ago, during our first sql tests using mysql
in Innodb, we suffer an energy fault during a storm.
Even the UPS couldn't help :-). After energy back, we
realise that our database crashed and suffer
corruption damages. I read some chapters from the
manual but they are not so clear
Mysql
Greetings. I'm doing some tests using innodb for the
first time and last night, during a storm, our
energy system fall, the ups couldn't help. This
happened when we have a substancial number of
connections to the database. When the energy came
back, we realised that the database was corrupt
le to prepare statements for execution in an application built
with the C API?
Any help/comments would be appreciated. TIA.
Pedro
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
The machine has no special devices and has 1GB of ram.
Thanks for any help.
Pedro Furlanetto
ocarteiro.com team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hello all,
I'm moving from ASP to PHP & MSSQL to Mysql, but I have some
doubt.
It is possible in MySQL Bi-Directional Replications? If it's,
then I need to find some documentation about it. Where can I find i
++
| MATCH (phrase_data) AGAINST ('understand') |
++
| 0 |
| 0 |
|
max_connect_errors. Locking the server after only 10
connections seens to be paranoidy precaution.
Pedro Furlanetto
database,sql,query,table <- bypassing the filter
-
Before posting, please check:
http://www.mysql.
Hi all,
Is there any graphic tool for controling a Mysql database?. This tool is for
a end user that doesn't know anything about sql.
Thank you.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hello people,
mysqldump not dumps MERGEd tables structure
it writes TYPE=MERGE and then UNION() with empty parenthesis
so this """dump""" can not be used.
--
Best regards,
Pedro
use my MySQL tables
I receive an error that some files with the extension *.ISM are not being
found.
Does somebody knows how can I try to fix this?
I`ll wait for you!
Pedro
-
Before posting, please check:
http://www.mysql.com
Hello people,
Anyone know how can I _useful_ (without data loss) link
database with tables contains unsigned short columns
thru MyODBC for ugly systems like M$ Access ???
I send this message to MyODBS list, but have no answer...
--
Best regards,
Pedro mailto
p?
Best regards.
__
Pedro Fonseca ([EMAIL PROTECTED])
Mob.: (+351)964598357
http://www.pedrofonseca.com
ADETTI/ISCTE (Instituto Superior de Ciências do Trabalho e da Empresa)
-
Hi,
U can check out this page to see what an alteon is:
http://www.alteonwebsystems.com/products/testing/
Regards
Pedro
- Original Message -
From: "Jeremy D. Zawodny" <[EMAIL PROTECTED]>
To: "Pedro" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: T
Hi,
I have 2 servers and 1 alteon in HA. But the problem is that the alteon ,
when trying, to see if the servers are up or down , makes mysql to fork ,
till it dies..
The connection port we are using is 3306 .
Does anyone have any idea?
Thanks in advance
Best Regards
Pedro
Jazztel
Hi,
I have 2 servers and 1 alteon in HA. But the problem is that the alteon ,
when trying, to see if the servers are up or down , makes mysql to fork ,
till it dies..
The connection port we are using is 3306 .
Does anyone have any idea?
Thanks in advance
Best Regards
Pedro
Jazztel Portugal
>Description:
Database:
total: about 500Mb now
mostly used table: about 300Mb data, about 150Mb index, about 6,7 millions of records,
two indexes(primary key contains 3 fields, and other index contains 2 fields)
other tables is negligible (U see)
>How-To-Repeat:
we repeatin
Hi,
I'd installed MySQLGUI 1.7.4 sucessufuly. After I connect to a database and
when I try to execute a query, the program stops and I get the following error:
Segmentation fault
Can you help me with this?
Thank's
--
Luis Pedro
Physics Departement of Unoversity
64 matches
Mail list logo
