ect your consumers to deal with it... Also the OP never
mentioned the OS, version of MySQL, etc, and that makes it VERY
difficult to get an answer.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N
ave to give them different TCP
ports to listen...
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
--END GEEK CODE
olutions, but its just not advisable on a real system with some
valuable data.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
an easy way.
You'll have to test and choose from multiple options in this matter.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+
ate any insight.
Could it be that the "problems" you mentioned generate warnings and
not errors? If so, then you won't see anything in the error log, only
if you use the "log-warnings" variable. Check the manual...
--
Daniel da Veiga
Computer Operator - RS - Brazil
-
bit of research (AFAIK).
Plus you'll have to create some sort of consistency (replication?)
between the servers. Oh, combine high load services with M$ and NTFS
and you'll get problems (my personal experience, no flames intended).
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BE
else thinks the same:
http://dannyman.toldme.com/2006/08/22/mysql-backup-grant-privileges/
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+
d to tell. Anyway, if you don't have a backup,
its hard to get the data easily. You can always install the old
version you had and try copying the file direcly to get the data back,
but I guess the corruption is in the file, so, there's really not much
to do...
Check your filesystem integri
hink there is no way to do this so I have to use old-passwords
option in the new servers :)
Thanks
On 12/11/06, Daniel da Veiga <[EMAIL PROTECTED]> wrote:
> On 12/11/06, Ahmad Al-Twaijiry <[EMAIL PROTECTED]> wrote:
> > Hi everyone
> >
> > I'm using mysqld wit
the one above, check:
http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html
And you may find all information about passwords there.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K-
allowed me to
catch a few idiots by logging their entrance... Many robots try to
break into MySQL servers by brute-force with user "root" and many
dictionary passwords.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a?
er trade security for speed, and
if I were you I would check for another option. What's the most
frequent operation (read/write) on your tables?
Anyway, glad you solved your problem.
Just out of curiosity, what is your filesystem?
--
Daniel da Veiga
Computer Operator - RS - Brazil
s/mysql-performance-tuning.php
Go for it.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
--END GEEK CODE BLOCK-
e can contribute.
Anyway, I'm not an expert, but a great friend is a DBA and he once
told me that if you have to CODE the creation of a database for any
purpose besides restoring a backup, something is wrong.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Vers
refman/5.0/en/password-hashing.html
So, there you go, time to change password format or start your server
with --old-passwords. I strongly suggest you to change your password
format.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:-
fan, but there are lots of ways... Choose your own :)
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
--END GEEK COD
) It is worth the time if you'll constantly add names to the database.
My 2 cents.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+
ting your config or using
it from somewhere else. Remove the filename, or give it a full path.
Try this and let us know.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+
status query and disconnect, and upon failure launch
MySQL, but this kind of workaround is in most cases something to
avoid.
My advice: first of ALL, upgrade. Then, try again, if it fails, change
your backup tool, if you have any other issue, come back and we may
help.
Good luck.
--
Daniel da Ve
doc/refman/4.1/en/innodb-foreign-key-constraints.html
Hope that helped.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
-
r something like STATSPACK of Oracle for MySQL.
Now I'm pretty sure there's no such thing for MySQL, but someone else
can point me wrong.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$
rces with
specific commands like "top" on *ix or CTRL+ALT+DEL on windows.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e
is in the mysql.user table?
Hacking the mysql tables is not a good practice. Use the GRANT command
instead. Also, check this:
http://hackmysql.com/dns
Hope that helped.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P
ou can write a simple application to monitor the error log file for
changes and check it to see if mysql was shutdown and/or started.
Accourding to the manual:
"The error log file contains information indicating when mysqld was
started and stopped "
--
Daniel da Veiga
Computer Operat
On 8/4/06, Chris White <[EMAIL PROTECTED]> wrote:
On Friday 04 August 2006 10:35 am, Daniel da Veiga wrote:
> What if each .sql contains a "DROP TABLE IF EXISTS" statement at the
> start? Something to be carefull if its the program that generated the
> backup likes to a
sequence, first a-l, then m-s. The only time I'd really
see this as an issue is if you were trying to run both at once, which in my
opinion is a Bad Idea(tm).
What if each .sql contains a "DROP TABLE IF EXISTS" statement at the
start? Something to be carefull if its the program t
v.mysql.com/downloads/mysql/5.0.html
It wasnt that hard...
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
--END GEEK
inted out
(or maybe not... someone from [EMAIL PROTECTED]), be wary of transactions,
which I can overwrite using an import switch.
I was able to actually convert to 5.0.22 directly from 3.23.58, and I'm
having my devs mow through the data to see if it all works as designed.
They are havi
quite get your question. PHP must connect, then
issue a query of some sort, then deal with the resultset, else it will
connect, and that's all. Maybe if you post the entire PHP code, along
with any error messages...
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK
hree times the data needed, don't
bother holding it at all". One with such a big scheme should have a
mirror, plus backups, just in case.
Personally I have daily backups, a slave mirror and another backup of
the backup files (network server with TSM backups).
--
Daniel da Veiga
Computer
). You can also use the binlogs (if you have them).
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
--END GEEK CODE
failure rate is on IDE vs SCSI vs SATA.
That is something only an ISP or corporation would give (and no one
will EVER sign it, *lol*). SCSI has one more advantage I forgot to add
to my previous message, they can be arranged better in RAID with hot
swap. I can only tell about my company, where server
from a
bridge.
Nobody will do that, but you can jump for yourself for not googling
for "ide scsi sata pata performance". ;) I'm just kidding.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W
much more easy to insert them
into a web page or application too, because the database do not serve
the data, only the info about it. Anyway, its MHO.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+
g fine (alongside a version 4 server on the same machine). How
do I manually enable root access from remote machines as adding "%" into
the list of hosts for root does not seem to do anything in
Administrator?
grant all privileges on *.* to root@'%' identified by PASSWORD('pas
java.lang.reflect.Method.invoke(Unknown Source)
com.mysql.grt.Grt.callModuleFunction(Unknown Source)
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
/var/mail nfs - yes
actimeo=0,bg,soft,retry=10
swap- /tmptmpfs - yes -
As I thought, your filesystem seems OK, I keep my bet on kernel issue.
Anyone else?
-Message d'origine-
De : Daniel da Veiga [mailto:[EMAIL PROTECTED]
Envoyé : Friday, 07
I'd be
very surprised in this case--see above for reasoning.
Greg
--
Greg Lehey, Senior Software Engineer, Online Backup MySQL AB,
http://www.mysql.com/ Echunga, South Australia
Phone: +61-8-8388-8286 Mobile: +61-418-838-708
VoIP: sip:[EMAIL PROTECTED], sip:[EMAIL PROTECTED]
Diary http://www
ministrator and Query Browser?
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
--END GEEK CODE BLOCK--
--
MySQL Gen
tacks would ruin a LOT of sites. Table names are
supposed to be static, so, most apps hard code their names. (but that
IMHO). If someone point that out (I couldn't find it googling, nor
searching manuals) it would be pretty intersting.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEG
ld edited files
6) Remember the position where you left editing the file
7) Line numbering, jump to, copy paste visual or command, delete lines
by number, delete multiple and much more editing features.
8) Much more stuff I don't use/know
OK, I'll stop VIM stuff here, I just love it, but I
t is default for --opt) and will
> get a single INSERT for each row.
I thought this may be the way I needed to go, but wasn't sure. I will give
this a try and see if it works.
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
ult for --opt) and will
get a single INSERT for each row.
Any ideas?
Yes!
Windows: Mysql Manual - Mysqldump section
Linux: man mysqldump
It's all there...
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++
port and populate
it with one of the table separated backups, retrieving the data.
It was efficient at that time, nowadays you have heartbeat and other
tools, allied to a DNS, it can do a LOT more (even non-assisted crash
recovery). But if you have a small dataset you can try this approach.
--
Da
-p | bzip2 -c >
path/to/backup/$date-.sql.bz2
I guess it will work on a FreeBSD, its my own cron job here...
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X++
nyone have any suggestions?
Upgrade to 4, then 4.1, then 5. Follow the above links, its quite fast
as you'll only be careful with things your particular system is
affected.
PS: BACKUP EVERYTHING!!! 2 copies are never too good
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEG
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Versio
sql.user
Comments?
Isn't the "hosts" table needed too?!
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
--
a command for this end? (I could copy & paste the part
from 'mysqldump' but it's not what I want to do.)
Read the reference manual for the mysqldump program, you can check the
syntax to do that:
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
Specially for the --no-data a
love Gentoo. "rc-update add mysql default" and voilá, its done.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
.
Try closing your connections after you've used them in a proper way
(that depends on the language you're using for your frontend) and that
number should not increase anymore.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-?
ve you a config set that may
crash/overload/put in risk your server. Simply grab a set of features
and play in a test database. There are some "stress tests" for mysql
over the web...
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P
and you (and you'll look like an idiot)
2) The person will infer what you mean even you saying it wrong (and
you'll look even more like an idiot)
I personally will avoid these situations.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT
Has everything you need to know.
And also, consider using an updated version, the one you're using is too old.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5
On 6/8/06, Frances <[EMAIL PROTECTED]> wrote:
Daniel da Veiga wrote:
> On 6/8/06, Frances <[EMAIL PROTECTED]> wrote:
>
>> what's event viewer? (searched google for error 1067, so opened .err
>> file, this is what is says (at the bottom, long file):
>>
&
ur server to the
latest 4.1, I believe its 4.1.20, and report back... I`ve seen various
issues with versions below 4.1.12...
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE
passwords" as an option and see if it
works.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
--END GEEK CODE BLOCK---
D]> wrote:
> >
> > !!
> >
> > I apologize..
> >
> > I should have mentioned that I am using a Mac in OSX 10.4.5
> >
> > My main concern is should I begin logging into mSQL using the terminal
> > or is this done from a br
he Web
Interface. You can also take a look at the MySQL Manual for a way to
reset your password in case you can't login using console.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O
d_cache_size = 8
query_cache_size = 32M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 4
...
Check http://bugs.mysql.com/bug.php?id=12915
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++
data, sort stuff and simply offer links to the ftp
site...
Just a suggestion...
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+
my databases?
If you're not changing versions, move the whole dir (/var/lib/mysql)
to the new location, simple as that, but you must do it yourself,
cause MySQL won't.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C+
L from www.mysql.com
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
--END GEEK CODE BLOCK--
--
MySQL General Mailing List
Fo
p://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+
replication.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
--END GEEK CODE BLOCK--
--
MySQL General Mailing Li
using your email/password) and that only you
were easily able to do with little or no research at all.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv
d yourself, your server is pretty much in order, the only
thing I can think off is a bug, and a good one :) so, upgrade to the
latest 4.1.x and see if it continue to happen, maybe its an issue
fixed by now.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Ver
builds glibc by default twice (read the einfo of
the ebuild?) one with linuxthreads and the other with NPTL, you can
set USE flags to avoid that (I guess its a matter of compatibility).
so, you may be running MySQL with linuxthreads instead. Check it.
More RAM, that's my advice, since your sy
ated a config file, copied the needed files to a location and
run the appropriate actions accourding to the OS of the user (windows
xp, create service, win98, startup item). Its not really difficul if
you know how to deal with MySQL.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEE
On 5/9/06, Edward Vermillion <[EMAIL PROTECTED]> wrote:
On May 9, 2006, at 1:50 PM, Daniel da Veiga wrote:
> On 5/9/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>> hi again,
>> I have to restart as soon as possible mysql and apache on our web
>> server
&g
On 5/9/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
found this:
/etc/rc.d/init.d/mysqld restart
/etc/rc.d/init.d/httpd2 restart
I think it should work?
Yeah, different systems, different locations, but the same purpose...
--
Daniel da Veiga
Computer Operator - RS - Brazil
Thanks for any help.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--
many tools, mysqldump scripted in bash (linux) or even in .bat
(windows) was always better than any other tools.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+
ion.
In simple terms, if you have no backups, your binlogs are outdated or
rotated to an extend (old changes lost) and you can't recover the
files from the filesystem. You're pretty much f up (don't get me
wrong, It happened to me once, and now I have daily backups, a
replicate
as a backup would be cool),
manage binlogs (date and purge) and be compatible with version 4.1 and
above (I don't plan on using the 5 version any time soon).
--
David Hillman
LiveText, Inc
1.866.LiveText x235
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
directory for every database, getting the size of the directory you
see how much disk space the database has taken.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP
the server with different options (more features) at
compile time. Joerg, accourding to the page above, he used the correct
terminology, a version has different meanings, one for apps (as you
stated) and another for executables (builds), that is the way Ashwini
mentioned it.
--
Daniel da Veiga
Compu
rect response from the base. What is the correct communication for
> the tables, or where am I going wrong with the two above attempts?
>
> Thank you,
> -Patrick
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:ht
lients don't
have a "crash recovery" system that reconnect and resend the query on
a server error, but the console has, so you'll see exactly what is
happening.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C+
out WHY the "????" appears and the causes for it.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
--END GEEK CODE BL
ySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+
ou'll have to keep it
running and as Dan said check the value constantly. Kinda weird if you
ask me.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+*
On 4/19/06, Ed Pauley II <[EMAIL PROTECTED]> wrote:
> out of curiosity, how do you do that?
>
> Daniel da Veiga wrote:
> >> If I am not mistaken deleting from the production server would delete
> >> the data on the slave in a replication environment.
> >>
> If I am not mistaken deleting from the production server would delete
> the data on the slave in a replication environment.
Not if you disable the binlog of the query that will delete data...
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
ss,
else it makes another connection, this time with an account with
read-write privileges so the user is logged into the app.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE
n in a free tool, in windows you could schedule a
task to see how things are running or simply parse the logs for
information with another program.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK---
est' ORDER BY fname $type";
> >
> >but what if nether is chosen, or only one? Is there an AND/OR operator or
> >similar in mysql?
> >
> >
> >Thanks,
> >
> >Ross
> >
> >
> >
> >
>
> --
> MySQL General Mailing List
; MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K-
;
> If this mailing list is not the right place to ask such
> questions please let me know.
>
> Bye
> Karl
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
mpressum/
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++
!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
Daniel da Veiga
Computer Ope
t, else, I doubt any ISP would allow
it...
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
--END GEEK CODE BLOCK--
ubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
I would stick with the VBA solution, heh, if you use it you can even
"call" Word and use "save as", in fact "converting" your document to
plain ol' windows text file... Then I guess you can go back
94 matches
Mail list logo
