I am now thinking about using MySQL as my main office DB. Is it going to be
easy te retrieve dta if there is crash or worse case senario my OS dies? I
guess this is a back up question really?
Thank you all.
Andrew
PS although this is slow it is brilliant. Is there a PHP equivalent.
Hi,
Guddack Thorsten ICM MP SCM GO 21 wrote:
Hi List,
again some Questions to replication in mysql:
I test the replication with following setup:
1 Server in Europe as the master, 2 servers in Asia and south america as
slaves.
Both slaves does the replication very fine.
Every insert, update
-Original Message-
From: Paul Roskilly [mailto:[EMAIL PROTECTED]]
Sent: 01 February 2003 13:11
To: '[EMAIL PROTECTED]'
Subject: Re: host.frm
I have the same problem, the file does exist and the ownership is the
mysql user, but the entry in the log file still says it cant find this
file
Hi everyone.. I have a related problem with my mysql 3.23.54 on a
RH7.3... Assigning the root password is ok with
Mysqladmin -u root password 'newpassword'
but when trying to do
Mysqladmin -u root -h myhost.mydomain.tld password 'newpassword' i have
the following...
./mysqladmin: connect to
Hi all,
I've discovered that I cannot use the fork() function in a Perl program that
uses the DBI module under Windows 2000.
I've tried the following script:
#!/perl/bin/perl
use DBI;
print Content-type: text/html\n\n;
$| = 1;
my $pid;
if ($pid = fork()) {
}
elsif (defined $pid) {
}
else
I use MySQL-python (use freshmeat to find it).
I've written my own class to use around it which looks a lot like:
class MyDBClass:
def __init__(self):
self.db = None
self.dbname, self.user, self.passwd = None, None, None
def connect(self, user = ,
Hello.
On Fri 2003-01-31 at 13:45:26 -0600, [EMAIL PROTECTED] wrote:
Description:
One of our customers had a table named group, admitedly a bad design
but still not something that should cause mysqldump to fail hard!
Please be more specific. Did mysqldump error out or the
Okay, I've seen just about every question on last_insert_id(), except this
one:
I am running MySQL on Win XP and when I generate a test table (test) with an
AUTO_INCREMENT column (aid) and a second column (a) then use an insert
statement like: INSERT INTO test (a) values (1); then: SELECT
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Mufaddal wrote:
PROBLEM with your JDBC driver - mysql connector.
I am developing using jdk1.4.1 on Mac OS X. I am using the mysql
driver - mysql connector java 2.0.14. I am creating a table in mysql
thru java ... the code to do this
HI
Before I just go out and buy, I wanted to get some opinions / advice on
what you all think the best MySQL and PHP resource books are. I am not
web design illiterate (have HTML and Perl experience), but I havent the
first clue about PHP and using MySQL with it. In other words, I am NOT
On Fri, Jan 31, 2003 at 03:45:44PM -0500, Jianping Zhu wrote:
How to change mysql root password in redhat 7.3 ?
http://www.mysql.com/doc/en/Resetting_permissions.html
--
Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com
Using and Managing MySQL
MySQL
Hi,
I have a MySQL 2.23.36 running on a Linux RH 7.1. Its database directory
is /var/lib/mysql/. For some reason I want to change it to /home/mysql/. So
I did following things:
1. modify /etc/my.cnf: changed all /var/lib/mysql/ to /home/mysql/
2. modyfy /etc/init.d/mysqld: changed
Hi All
Running FreeBSD 4.7 MySQL 3.23. When trying to run or start MySQL I get
030201 16:32:59 Can't start server : Bind on unix socket: Permission
denied
030201 16:32:59 Do you already have another mysqld server running on
socket: /tmp/mysql.sock ?
030201 16:32:59 Aborting
030201 16:32:59
Folks
I have written a C# GUI for MySQL server which works
pretty nicely on my rather limited LAN at home. the
purpose of this project is to make the source code
available to other folks who are in the learning
process and might want to see some code examples.
Before uploading the code or the
Mustafa,
How i list connected users(active) to mysql server?
mysql SHOW PROCESSLIST;
++---+---+--+-+---+
| Id | User | Host | db | Command | Time |
++---+---+--+-+---+
| 2 | superuser | localhost | test |
Hi All
Running FreeBSD 4.7 MySQL 3.23. When trying to run or start MySQL I get
030201 16:32:59 Can't start server : Bind on unix socket: Permission
denied 030201 16:32:59 Do you already have another mysqld server
running on socket: /tmp/mysql.sock ? 030201 16:32:59 Aborting
030201
If it gives errors about creating/writing mysql.sock, check the
permissions/ownership of directory /var/lib/mysql.. Check the manual for
the right permissions...
Might depend on your distro, AFAIK mysql.sock would normally live in /tmp
B.
Why would the mysqlcc client need to use such a new and unstable version of the qt
libs.
For god sake, Suse is only using 3.03 and this 'requires' 3.05. This is like a
disease with
GNOME and KDE developers lately. Why does everyone push the libraries to the brink
all the
time. It just
At 21:12 -0600 1/31/03, Gary Reimer wrote:
I'm a new mysql user running on OS X. I have set up a test database and am
trying to use mysqldump to create a backup. However here is what happens:
[h24-85-217-157:/usr/local/bin] garydr% mysqldump -h localhost -u root
bpw_dbbpw_db_backup.sql
Hi,
I am a web developer and I wrote a script that cycles through a bunch
of regular expressions stored in a database.
Is there or will there be a way to precompile and store precompiled
regular expressions in mysql? I would then need to run them against a
string/(var)char field
Hi,
I don't know if this is all old news now, but I got the exact same error
that Jesse did when I ran a copy and paste from your example.
When I both switched to sh from csh, and made that big paragraph into a
single line, then it worked. So I got though the configure.
But on the make I got
HI
Before I just go out and buy, I wanted to get some opinions / advice on
what you all think the best MySQL and PHP resource books are. I am not
web design illiterate (have HTML and Perl experience), but I havent the
first clue about PHP and using MySQL with it. In other words, I am NOT
: I am now thinking about using MySQL as my main office DB. Is
: it going to be
: easy te retrieve dta if there is crash or worse case senario
: my OS dies? I
: guess this is a back up question really?
Try to backup your DB as often. mysqldump utility is mostly for that.
JD,
But..., wait..., I am now still in Linux and haven't gone to or tried
it
in Windows [kind of allergic..., you know :)]. But, assuming the core
datasource for Lin-Win is not different at all, I believe that in
Windows it wouldn't be a big deal at all.
In fact. As I understand, Windows can
Gary,
[h24-85-217-157:/usr/local/bin] garydr% mysqldump -h localhost -u root
bpw_dbbpw_db_backup.sql
bpw_db_backup.sql: Permission denied.
This means that MySQL is not allowed to write in this directory. Which
directory? ;-) Well, as you don't specify a path, bpw_db_backup.sql will
be created
Paul,
I have the same problem, the file does exist and the ownership is the
mysql user, but the entry in the log file still says it cant find this
file when starting mysql daemon.
And the manual said: If you don't set up the grant tables, the
following error will appear in the log file when
Hi,
I am just trying to get a handle on when tables are physically written to disk.
(ignoring whatever operating system level caching that may be going on)
IE If you do some updates/inserts to a MyIsam table and then have a power failure will
you ALWAYS loose those updates (Even if the power
Hi!
On Jan 31, harm wrote:
Moi,
every now and then my otherwise happely running mysqld has a thread or two
stuck in the state 'statistics'. If I kill it with `mysqladmin kill poor
threads id` it does get registered as 'killed' (According to `mytop`). But
the thread refuses to die. They
Not related at all:
If you would have done a quick search in the manual you would have found:
http://www.mysql.com/doc/en/Access_denied.html
To start with..
B.
-Oorspronkelijk bericht-
Van: stephane parenton [mailto:[EMAIL PROTECTED]]
Verzonden: zaterdag 1 februari 2003 18:09
Aan:
This is a FAQ. Please search this lists archive or the manual:
http://www.mysql.com/doc/en/Default_privileges.html
Ppl have spend time to create a manual so you'd better take a look there..
If it's not clear please come back to the lists and explain which part you
don't understand.
You will find
Hi,
I have installed Version 4.07 gamma on a windows 2000 server.
Install went like a dream and I was up and running within a few minutes. I have run
several tests of my own using Delphi and Zeos Data base controls - again all this
works perfectly. ( I get nervous when things work this well !)
Hello everyone!
This is my first time posting on this mailing list, a Mysql developer
referred me here in hopes that I can find some solutions to our fairly
unique situation. Im pretty new to FBSD and Mysql so please bare with me.
I am the part owner of a pretty large website
Description:
I can connect to mysqld and execute queries on the local system via the
Unix socket, /tmp/mysql.sock. However, when I attempt to connect via a
network connection, the connection fails, and the server restarts. I get
the following failure message:
mysqladmin: connect to server at
Hi Loren,
I recomend to take a look at these books:
-MySQL , Paul DuBois
-PHP 4, the bible 2nd edition, Converse, Park
Best regards,
Davy Obdam
mailto:[EMAIL PROTECTED]
Loren McDonald wrote:
HI
Before I just go out and buy, I wanted to get some opinions / advice on
what you all think the
Hi all !
I would like to insert a Blob ( a picture exactly ), here is a small
source code to test my insert.
You can find 2 sources code, the first is to insert a blob in a table of
a database ( this database exists in my MySQL server )
And the second code is to read this blob from the database.
We (Centers for Disease Control and Prevention) want to mount
relatively large read only tables that rarely change on
modest ($10K ??) hardware and get 10 second response time.
For instance, 10 years of detailed natality records for the United
States in which each record has some 200 fields and,
i have a windows ME box with .net framework v1.0 and odbcmysql driver
3.5.xxx will this work for your testing? if so i might be willing to try it
out and se how it works... let me know in mail off list...
tnx
- Original Message -
From: Nasser Ossareh [EMAIL PROTECTED]
To: [EMAIL
Hi all,
Is there a possibility, in MySql, to define a mirror to my database,
meaning that I define another database that will be a copy of my database
and every operation that I will make on my database, will be done
automatically in the second database?
Or if I define database that contain only
Does anyone have any hints on how to or where to look to find out how
to import a number of tab-delimited text files with some header info
that reside on a ftp server into a MySQL database using PHP?
the 'key' command is 'load data infile'. It is very flexible in
handling various delimited
Basically the problem is only the ownership and it has to be owned by
mysql. The problem is indeed there, how to chown or chmod those data so
it can be owned by mysql.
JD
Alex Shi wrote:
Hi,
I have a MySQL 2.23.36 running on a Linux RH 7.1. Its database directory
is /var/lib/mysql/. For
This question might be a little OT.
My question is, what is the smallest working install
of mySQL?
Can you install it in a PDA, like the Yopy, that uses
linux as OS?
http://www.yopy.com/english/products/specification.htm
// Michelle
__
Do you
Alex,
However, for local connections, say connections from a locally hosted
web site via PHP, or a command line connection issued from shell, it
Remote connections are made through TCP/IP. That's why you get the sock
error only for local connections.
will return following error message:
Hi
I have at last reached the point where I believe version 4 is stable enough
and better than version 3 to start upgrading.
Can people recommend the best process ..
Currently I have three pc's running
- Suse 8.1(Duron 256MB)
-Redhat 8.0(Celeron 256MB)
-Debian Woody(Celeron 512MB)
and all
Hi Loren,
THE book on MySQL is MySQL, by Paul DuBois. It's published by New Riders.
They just came out with an updated version.
The PHP book I have, which I would definitely recommend, is Professional
PHP Programming, with several authors, published by Wrox press. They don't
focus on IIS,
I am getting the below error:
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock'
So I did a touch /var/lib/mysql/mysql.sock and tried restarting mysql. I
still received the above error when I tried connecting to mysql. So I
checked to see if mysql.sock was
Thanks for your reply. but I did correctly set the mode and ownership.
Alex
Basically the problem is only the ownership and it has to be owned by
mysql. The problem is indeed there, how to chown or chmod those data so
it can be owned by mysql.
JD
Alex Shi wrote:
Hi,
I have a
Hi folks,
Where have the links to MySQL SRPM packages gone from
http://www.mysql.com/downloads/mysql-4.0.html ??
I found being able to build binary RPMs from your SRPMS to be
useful, please could you make these files available again?
(yes I am aware I could build them from a .spec file if that
In the last episode (Feb 01), Alan said:
Okay, I've seen just about every question on last_insert_id(), except
this one:
I am running MySQL on Win XP and when I generate a test table (test)
with an AUTO_INCREMENT column (aid) and a second column (a) then use
an insert statement like: INSERT
In the last episode (Feb 02), Clyde said:
Hi,
I am just trying to get a handle on when tables are physically
written to disk. (ignoring whatever operating system level caching
that may be going on)
IE If you do some updates/inserts to a MyIsam table and then have a
power failure will you
Clyde:
I don't know what percentage of MySQL users are running on Windows servers,
but I suspect it is higher than you might think. IMHO, you would also find a
number of situations where MySQL is being used on Win32 platforms for
development, while production databases are being served up on
Hi
I have at last reached the point where I believe version 4 is stable enough
and better than version 3 to start upgrading.
Can people recommend the best process ..
Currently I have three pc's running
- Suse 8.1(Duron 256MB)
-Redhat 8.0(Celeron 256MB)
-Debian Woody(Celeron 512MB)
and all
Hi,
One other problem came up, the configure script looks for LinuxThreads in
/usr/include where of course FreeBSD stores them in
/usr/local/include/linuxthreads so the flag that gets set for linuxthreads
doesn't, at least not in my version of mysql 4.09
Thanks,
Eric
(250) 655 - 9513 (PST
Bonjour,
Vous avez récemment demandé à vous inscrire au groupe
mysql-france. Comme vous êtes déjà membre de ce groupe,
votre demande ne sera pas prise en compte.
Pour toute question sur l'envoi de messages à ce groupe,
veuillez envoyer un e-mail à [EMAIL PROTECTED]
Cordialement,
L'équipe
Hi, Loren -
I'd first go with any book from O'Reilly (http://www.ora.com)
After that, I've found Welling and Thomson's PHP and MySQL Web Development
pretty good. http://www.sams.com
A couple of my students liked: Meloni's Teach Yourself PHP, MySQL and Apache
in 24 Hours, also at Sams (part of
I am getting the below error:
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock'
So I did a touch /var/lib/mysql/mysql.sock and tried restarting mysql. I
still received the above error when I tried connecting to mysql. So I
checked to see if mysql.sock was
Hi all:
I am building a database containing usage information for a wireless ISP
application. I am using a RADIUS server (Steel Belted Radius on Win 2K) to
handle RADIUS events from the network hardware and then write to a MySQL
database.
Everything works fine but I have a problem: the RADIUS
At 15:21 +0100 2/2/03, Stephane Wirtel wrote:
Hi all !
I would like to insert a Blob ( a picture exactly ), here is a small
source code to test my insert.
You can find 2 sources code, the first is to insert a blob in a table of
a database ( this database exists in my MySQL server )
And the
Create a symlink for mysqld.sock in /tmp.
ln -s /path/to/your/mysql.sock /tmp
This should resolve the problem in over 90% of the
cases.
once this is fixed it is likely that you have other
problems. but we'll discuss them when we get there ;-)
--- Mike [EMAIL PROTECTED] wrote:
Hi
Could it be that the table types are different?
the innodb table types seem to ignore auto_increment
while MyISAM are more accommodating... so it might be
that your table on Linux is MyISAM type while the
table on XP is Innodb type.
--- Alan [EMAIL PROTECTED] wrote:
Okay, I've seen just
Hello,
I use MySQL in a production environment where it is running a few
databases. I make hourly db backups using the perl hot copy script
distributed with MySQL. I would like to be able to restore my db down
to the minute with the binary log, but the options to the binary log
parser are
Inbal,
Is there a possibility, in MySql, to define a mirror to my database,
Yes. In MySQL, it's called replication, and it's quite easy to setup.
More info: http://www.mysql.com/doc/en/Replication.html
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH
Hi: I am new to mysql. I did an rpm install of
ver-3.23.55 on RH 7.1.
By default the data is stored in /var. Can I change
this option.
Thank you.
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
On Sat 2003-02-01 at 10:35:46 -, [EMAIL PROTECTED] wrote:
Hi Benjamin,
Wow, that sure sorted that problem out... I had to rejig it slightly to
get it to work,
Oops... too much copypaste by me :-)
but this is the final working version:
Glad it worked out.
Bye,
Benjamin.
Prasanth Krishna [EMAIL PROTECTED] wrote in message
news:b1eg64$2rqn$[EMAIL PROTECTED]...
Is there any way to partition MyISAM tables in mysql? i have a huge
table and want to partition it.
Do InnoDB tables support partitioning?
thanks.
The software RAID option for MyISAM sounds like what you
I have rehat 7.3 linux server with apache server running, when i try to
install mod_auth_mysql, i
got followine error msg,
[root@mango mysqlsrc]# rpm -i mod_auth_mysql-1.11-1.i386.rpm
err: failed dependencies:
libmysqlclient.so.10
65 matches
Mail list logo