solaris server now return sql errors
>Description:
MySQL server crashes every minute and restarts. Also, php scripts
that worked on our former server (solaris) now return errors, except for
one.
>How-To-Repeat:
This line is where the error
occurs in the script: "$number=MYSQL_NUM
I've not had much experience with ASP, in fact, I've had none, so if someone could
give me a hand here I'd be very appreciative.
What kind of errors am I likely to get with the ADO control? I'm only likely to be
running basic queries anyway, most of the data processing and the like will be done
You COULD use the ADO data control, but I wouldn't recommend it. There are
still some ADO methods and objects that are not fully supported and you will
most likely generate some strange errors. It may be a pain to do it, but
you'll be better off doing it the "old-fashioned" way with your own
conne
At 11:07 PM -0500 7/23/01, Kit Kerbel wrote:
>Is the foreign key functional is the newest version of Mysql? If so, how does
Not according to the MySQL manual:
http://www.mysql.com/doc/M/i/Missing_Foreign_Keys.html
>it work. Also, how would I go about synchronizing an auto_increment
>field fr
I've been told that it's possible to connect directly to a mySQL DataBase with Visual
Basic, by using the {mySQL} provider within the ADO Data Control, however, none of the
providers on the list include mySQL at all, and I was wondering if anyone could shed
some light on this.
I want to connec
At 4:20 PM -0700 7/23/01, Dan Huston wrote:
>Hello All,
>
>I am getting this error:
>
>DBD::mysql::st execute failed: You have an error in your SQL syntax
>near ''user_id', 'sem1_acad_id', 'sem1_course_id', 'sem1_ver',
>'Sem_1_Final') VALUES (' at line 1 at flatten_er5.pl line 132,
> line 13634
Is the foreign key functional is the newest version of Mysql? If so, how
does it work. Also, how would I go about synchronizing an auto_increment
field from one table with another table which need to correspond to the
first. One table is for example the User table used for logging in...the
At 1:31 PM +1000 7/24/01, Geoff Martin wrote:
>Using the following Syntax I tried to create a table in mySQL. However each
>time it returned a mySQL error which I eventually worked out it was because
>I'd defined a field as text. I am able to define fields as varchar, char,
>int or float (I've tes
hello there,
did any body used mysql with j2ee.
is there any problem with transcation locking
etc .bcs mysql only has table level locking...how
container maintaince this
Any suggestions and comments welcome..
Regards,
Manu
-
Using the following Syntax I tried to create a table in mySQL. However each
time it returned a mySQL error which I eventually worked out it was because
I'd defined a field as text. I am able to define fields as varchar, char,
int or float (I've tested for theses so far) but not text or blob.
The
Dear,
I decided to collect data into MySQL for realtime display usage. How
could I know there are new records add to table and retrieve them to
display? Is there different to do this with VB (Client/Server style) and
PHP (Web Bases Style)?
Thanks
Sommai Fongnamthip
Title: EMPRESAS - Base de datos de las 500Empresas más grandes, (por
ventas),
del país con los siguientes campos: razón social, sigla
EMPRESAS - Base de datos con las
1.000 Empresas más grandes de Colombia (ventas superiores a $20.000 millones
anuales), con los siguientes campos: razón soc
Try running safe_mysqld, this should generate the sock file.
I came across the same issue when I installed mysql. Check and see if mysql
(as a user) has access to the mysql directory. You might want to do a
chown -R mysql:mysql {mysql dir}
to change the permissions for the mysql dir and
Hi Benjamin...
> > database almost 2 years ago... But the orderid I can convert without
> > a problem to an INT because all data only are numbers... :-(
> It's not so important, that orderid is not of type VARCHAR (although
> better), but more important, as I said, that co.id and cpo.orderid are
PS : I forgot to add that as a further optimization I cache the list of IDs from the
first query in the 2 part approach& I reuse that list as users advance through it.
-
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
Hello All,
I am getting this error:
DBD::mysql::st execute failed: You have an error in your SQL syntax near
''user_id', 'sem1_acad_id', 'sem1_course_id', 'sem1_ver', 'Sem_1_Final')
VALUES (' at line 1 at flatten_er5.pl line 132, line 136342.
in the trace log I see this:
Setting mysql_use_
I have standard search functionality on my site where a user can see NN items per
screen of a much longer list of search results. I've found that MySQL returns small
result sets out of a list of hits faster when queried in 2 parts than queried once. Am
I doing something wrong ?
I have a fairl
Hi,
Can any of you query experts tell me if this is possible in a query?
I have 3 tables, categories, products, groups.
Groups table consists of categoryid and productid, it just keeps track of which
categories have which products.
I need a query(if possible) that would basically say:
Select al
sorry
[]´s
Gustavo Pessin
Gerente de Informática - Bigfer
Linux Registered User 154424
"Um passo a frente e já não estamos mais no mesmo lugar." (Che Guevara)
- Original Message -
From: "Jeremy Morano" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 23, 2001 12:57 PM
Su
Hi,
Thx for the reply.
On Mon, Jul 23, 2001 at 09:51:47PM +0200, Werner Stuerenburg wrote:
> Databases for MySQL are just subdirectories, as you may already
> know, so you may very easily restrict disc usage on those subdirs
> for each student.
I'm not sure how relevant this will be - but I s
Regarding the upgrading posting I posted, I must install the upgrade in the same
data dir as the current version or else our customer WebHosting Manager browser
interface will not work properly when access their database's . The current data
dir install is /var/lib/mysql.
Now when you install th
On 23-Jul-2001 Mike Mike wrote:
> Hi Folks,
> I'm trying to create a counter for my website. I'm
> trying to pull the last 7 days worth of data out of
> mysql. My sql statement is as follows.
>
> SELECT TheDate, Count(TheDate) AS CountOfdate
> FROM Counter
> WHERE (((TheDate)=Now()-7))
> GROUP
I just found that I can make phpMyAdmin display the processlist
very conveniently. There I see
dbCommandTime State Info
pferdezeitung Delayed_insert 27Waiting on cond staticStrings
Well, I know I experimented with INSERT DELAYED on table
staticStrings, but what
> I have download "manual-split.tar.gz" and couldn't open it (from www.mysql.com).
> tried with winzip but had the following error:
> Invalid Compressed Data - unable to inflate
Looks like a download error. Did you try to repeat the download?
> which program should I use?
> why not Zipping t
http://mysql.com/downloads/index.html
says:
MySQL database
MySQL Max 3.23 -- Beta Release
MySQL 3.23 -- Stable Release (Recommended)
MySQL 3.22 -- Previous Stable Release
MySQL 3.21 -- Elder Release
MySQL 3.20 -- Elder (no longer supported) Release
So why don't you pick Stable Release
I think this is a problem similar to that of ISPs. I don't know
about this technique personally, as I am not fit on Linux/Unix,
but restricting disc space on those systems is standard, so you
will know how to do that.
Databases for MySQL are just subdirectories, as you may already
know, so you ma
Of course, 0 records are ok. Here is an example of mine :
mysql> select now(), now()-7;
+-++
| now() | now()-7|
+-++
| 2001-07-23 21:45:53 | 20010723214546 |
+-++
1 r
Your download seems to be broken. WInzip is able to decompress gnuzipped
tared files. Just do download again.
David
At 21:06 23.07.01 +0200, Guy A wrote:
>hi,
>I have download "manual-split.tar.gz" and couldn't open it (from
>www.mysql.com).
>tried with winzip but had the following error:
>
We had this discussion here a couple of days ago. There are
versions of MySQL who behave this way, but it is mostly not
considered the correct way. So you may as well get used to the
idea that an autoincremented field is doomed to increment no
matter what.
> That got me thinking...say you have a
Well David,
Using MyISAM tables, you would get 501 'cos the auto_increment pointer
continues adding and never subtracts, but with ISAM tables, you would
get 500. So take care of what type of table you are using and don't get
bored as I've got.
Best regards,
William N. Zanatta
Description:
I've installed mysql on my linux 7.1 server (via RPMS) and it self-configured. It is
now running however I can not connect to it. I keep getting the followingn error
message:
mysqladmin: connect to server 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using pas
here I hope this will get into your mailing list
query query query query query query query query query query query query
query query query query query query
I am having a small problem compiling V4.0 on RedHat 6.2.
At the end of the make process, it dumps out with undefined references to
some
>Description:
Whenever I compile mysql 3.23.40 with Berkeley DB support,
I get a signal 11 when attempting to start the mysql server.
If I omit Berkeley DB support, everything starts fine.
# /usr/local/mysql/bin/safe_mysqld &
in error file:
010723 12:13:16 mysqld started
hi,
I have download "manual-split.tar.gz" and couldn't open it (from www.mysql.com).
tried with winzip but had the following error:
Invalid Compressed Data - unable to inflate
which program should I use?
why not Zipping the files?
Guy.
No, it just hangs there.
Walter
On 7/23/01 1:25 PM, "Stefan Hinz" <[EMAIL PROTECTED]> wrote:
> Dear Walter,
>
> what about
>
> MYSQLADMIN SHUTDOWN ?
>
> This should tell *anything*, at least an error.
>
> Regards,
>
> --
> Stefan Hinz
> Geschäftsführer / CEO iConnect e-commerce solutions G
Hi Folks,
I'm trying to create a counter for my website. I'm
trying to pull the last 7 days worth of data out of
mysql. My sql statement is as follows.
SELECT TheDate, Count(TheDate) AS CountOfdate
FROM Counter
WHERE (((TheDate)=Now()-7))
GROUP BY TheDate;
When I do this Sql Commmand it returns
That got me thinking...say you have a list of 500 people, and you delete
the
person with id 500 (The Person with the very last ID). Now, your ID's go
up
to 499. Now say someone else is added. Would they have an id of 500 or
501? For me it would be 500, which would create a security problem
That got me thinking...say you have a list of 500 people, and you delete the
person with id 500 (The Person with the very last ID). Now, your ID's go up
to 499. Now say someone else is added. Would they have an id of 500 or
501? For me it would be 500, which would create a security problem, bu
Dear Walter,
what about
MYSQLADMIN SHUTDOWN ?
This should tell *anything*, at least an error.
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee 25, 13355 Berlin
# Tel: +49-30-46307-382 Fax:
Dear Nitesh,
if you run the MySQL server under root, that's not quite safe. Better
start it with "mysqld -u mysql".
Secondly, use GRANT ... to set rights for specific users. Check the
manual for GRANT.
Then, delete the (default) root user from mysql.user. Delete any other
user who can log in wi
Dear Mike,
first check if you have the mysql database installed. This holds the
tables of the so called privilege system which handles the access
rights.
Then, log in *somehow* to the MySQL server (usually, for the first time,
with Unix root account and *no* password), and enter
GRANT ALL ON *.
Dear Andrew,
>Can someone please recommend the easiest way to transfer a database
(with data) from >one server to another?
Best way is to dump all databases and then generate them new on the new
server. This will make MyISAM files by default, so old ISAM files (which
are slower and more likely t
Dear Nitesh,
forget about "my.conf" regarding the privilege system.
The correct syntax for granting access to all tables in "my_database"
(all rights, i. e. create, alter, drop, etc.) is
GRANT ALL ON my_database.* to some_user@localhost IDENTIFIED BY "secret"
[WITH GRANT OPTION]
For a superuser
-- Virus Warning Message (on tjintranet)
Found virus TROJ_SIRCAM.A in file unix1.zip.com
The file unix1.zip.com is moved to /var/tmp/virANB0.nrHt.
-
Hi! How are you?
I send you this file in order to have your advice
See
>Description:
The make of mysql fails with the following error:
make[2]: Entering directory `/auto/oieda2/oicad/mySQL/build/mysql-3.23.40/sql'
Making all in share
make[3]: Entering directory `/auto/oieda2/oicad/mySQL/build/mysql-3.23.40/sql/share'
make[3]: Nothing to be done for `all'.
ma
Developers,
As the size of a tarball source download is at 11MB presently and gemini
table source is about to be included I wonder wether the next package
should optionally be available as mysql-3.23.41.tar.bz2 to save lots of
bandwith.
I found that the current version 3.23.40 can be compressed
At 11:57 AM -0400 7/23/01, Jeremy Morano wrote:
>Hi,
>
>I would like to know how to create a field that comes from another table and
>how to insert values from a table into another one.
>
>kind of like this
>
>table_1
>uid1 ...(primary key)
>first_name ...
>last_name ...
>
>craete table table_2 (
> Who know how to dump a database for backup it.
mysqldump your_database [your_table] > your_dump_file.sql
Without your_table, the whole database is dumped.
If security setting (privilege system) is set up correctly, you will
have to log in, let's say as superuser:
mysqldump -u superuser -p your
Hello.
On Mon, Jul 23, 2001 at 09:34:17AM -0600, [EMAIL PROTECTED] wrote:
> Please Help!
>
> I can't find trigger functions in the documents. Does MySQL has triggers
> for preselect, preupdate, and predelete? If do, where can I find them?
Please have a look at the following chapter in the fine
Hi.
On Mon, Jul 23, 2001 at 05:24:45PM +0200, [EMAIL PROTECTED] wrote:
> Hi
>
> When thinking about security it is best to use ' around number input
> from a webuser in the WHERE part of my query. But does is this query
> run slower than a query without ' around numbers? How does this
> work?
J
Hi.
On Mon, Jul 23, 2001 at 04:32:54PM +0400, [EMAIL PROTECTED] wrote:
> Problem: INSERT fields AUTO_INCREMENT passes correctly, and call
> after that mysql_insert_id () all the same returns 0. Linux 2.2.14
> operating system. Mysql version - 2.23.38
Hm. You know that the return value is of type
Hi.
On Mon, Jul 23, 2001 at 01:52:50PM +0200, [EMAIL PROTECTED] wrote:
> In version 3.22.32 I can't get the "Invert all bits"-function to
> function. Is it implemented later or am I doing it all wrong?
According to
http://www.mysql.com/documentation/mysql/bychapter/manual_News.html#News-3.23.x
Hi,
I would like to know how to create a field that comes from another table and
how to insert values from a table into another one.
kind of like this
table_1
uid1 ...(primary key)
first_name ...
last_name ...
craete table table_2 (
uid2...(primary key)
phone...
fax...
table_1.uid1 ...);
inse
-- Virus Warning Message (on tjintranet)
Found virus TROJ_SIRCAM.A in file 01062001.xls.bat
The file 01062001.xls.bat is moved to /var/tmp/virPKB0HQl_p.
-
Hi! How are you?
I send you this file in order to have your advic
Dear William,
> The problem is...if I delete the third entry (Edicao = 3), the next
> entry inserted should be 3, right?! Well it is not! It is 4. So I get
a
> table like this...
> ++
> | Edicao |
> ++
> | 1 |
> | 2 |
> | 4 |
This is not a bug, it's a
Dear Michael,
try CHMOD /var/lib/mysql/ (777 for the beginning). Run the MySQL server
with a different user (mysqld -u mysql, so it will run as user mysql).
If the socket still cannot be created, check if install_db has been
executed. If you don't have the grant tables, MySQL will not work.
Reg
Please Help!
I can't find trigger functions in the documents. Does MySQL has triggers
for preselect, preupdate, and predelete? If do, where can I find them?
Thanks,
Weiwen
I have tried everything that I know to set the root password but I keep
getting denied. I finally got the daemon running so now I need to set the
root password. I have not yet set a pw so I can not understand why I am
getting denied. I looked at the manual online and it gave the following
suggesti
Hi
When thinking about security it is best to use ' around number input from a webuser in
the WHERE part of my query. But does is this query run slower than a query without '
around numbers? How does this work?
I want to protect my system from user input such as comment, AND operator, and OR
Hi,
I work in a university and need to give students access to a MySQL
database from their php enabled web server.
The apache/php stuff is all working but I was wondering on some advise
as to how best to deal with a large number of students.
Ideally waht I'd like to do is to setup MySQL so tha
I tried it, and mysqladmin just sits there and never returns the prompt.
Looking at it from another ssh session, I see that mysqladmin and
safe_mysqld and mysql are all still active. Perhaps admin is killing and
safe is restarting just as fast. Mysqladmin did not respond to Control-C,
nor did it l
On Saturday 21 July 2001 00:28, Jeremy Zawodny wrote:
> On Thu, Jul 19, 2001 at 03:15:02PM -0500, Tom Wheeler wrote:
> > Our two most important requirements for the database engine are
> > speed and scalability. We will be inserting probably 5,000,000
> > records per day into our database
>
> Sou
-- Virus Warning Message (on tjintranet)
Found virus TROJ_SIRCAM.A in file T_chamado06f.xls.lnk
The file T_chamado06f.xls.lnk can not be moved because /var/tmp/virSIA0zg7eo: No space
left on device.
-
Hi! How are you?
I
[EMAIL PROTECTED] writes:
> I have installed Redhat Linux 7.1 with the supplied MySQL distribution
> (3.23.36?). I've run the "mysql_install_db" script, but when I try to start
> MySQL using "./bin/safe_mysqld --user=mysql &", from the installation directory,
> MySQL starts then ends immedately (
Ok if you look at USERS you should find you have a user with no password or
privileges.
If you remove a user using grant you will leave there logon but with no
privileges.
So you will have to remove these manually.
As for my.cnf is only needed if you would like to change thing from a
standard set-
> -Ursprungligt meddelande-
> Fran: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
> Skickat: den 19 juli 2001 15:36
> Till: [EMAIL PROTECTED]
> Kopia: [EMAIL PROTECTED]
> Amne: Re: inheritance of privileges?
>
>
> Johan Nilsson writes:
> > Privileges question:
> >
> > I have a user in mysq
Simon Green wrote:
> When you set up the sever to start with it has no passwords or user's set.
> What you have to do now is use the Grant command. But of course set the
> super/root user password first.
> It is well worth reading all the doc's on security.
> If you use -p and there is no passwor
When you create user DSN, it's created in Windows Registry, so there is no
file. You can access that DSN from any application which use ODBC drivers.
--
Martin Jeremic
[EMAIL PROTECTED]
http://solair.eunet.yu/~martinj/
http://jsoft.webjump.com/
-Or
When you set up the sever to start with it has no passwords or user's set.
What you have to do now is use the Grant command. But of course set the
super/root user password first.
It is well worth reading all the doc's on security.
If you use -p and there is no password set it will look for a passw
Hi.
On Mon, Jul 23, 2001 at 02:33:21PM +0200, [EMAIL PROTECTED] wrote:
> Hi Benjamin...
>
> I am not sure, but it looks that I (sometimes) get an email back
> telling me that your email address isn't working..
> >recipient [EMAIL PROTECTED] does not exist, verify e-mail address, please
Hm. But
Hello,
I have just installed the MySQL RPMs , downloaded from
ur web site. I have installed it on my machine. But I am facing few
problems.
1. As u have specified in documentation that, if I am able to connect
to server without giving password that can be troublesome. While i am
Hi Benjamin...
I am not sure, but it looks that I (sometimes) get an email back telling me that your
email address isn't working..
>recipient [EMAIL PROTECTED] does not exist, verify e-mail address, please
I still want to reply on you other mail, but your email just showed me something
awful!
Panos Melas writes:
> Hello everyone,
>
> I try to install and configure mysql under win2000, initally it seems to
> work ok but whenever I try to create a table or modify any of the existing
> tables I get the following error: ERROR 1036: Table is read only
>
> e.g.
>
> mysql> insert into
Walter Lee Davis writes:
> Could this be related to the problems which cause mysql to be almost
> un-killable on MacOS X? I have tried to use mysqladmin to stop the server,
> but the only thing that will do it is 'kill -9', and if I had started it
> with safe_mysqld, then it comes bouncing right b
Using the 'GRANT' syntax is the recommended method for assigning
permissions.
-Original Message-
From: Panos Melas [mailto:[EMAIL PROTECTED]]
Sent: Mon, 23 July 2001 13:51
To: '[EMAIL PROTECTED]'
Subject: win2k ERROR 1036 (read only) problem
Hello everyone,
I try to install and configu
Problem: INSERT fields AUTO_INCREMENT passes correctly, and call after that
mysql_insert_id () all the same returns 0. Linux 2.2.14 operating system. Mysql
version - 2.23.38
-- Virus Warning Message (on tjintranet)
Found virus TROJ_SIRCAM.A in file mes0501.xls.pif
The file mes0501.xls.pif is moved to /var/tmp/virCOE0PgUxY.
-
Hi! How are you?
I send you this file in order to have your advice
Hi.
On Sun, Jul 22, 2001 at 03:38:10AM +0200, [EMAIL PROTECTED] wrote:
> Hi Benjamin,
>
> Just a quick gif picture of the explain of the other query I made..
> (It's quite late now and I will read your email tomorrow again..)
>
> > Could you post an EXPLAIN for it? I am curious to see it.
> >
I don't think it's a OpenBSD Problem ... I've got the same behavior
on several Unix - Machines ... running 3.23.33 - 3.23.39 ...
> -Ursprungliche Nachricht-
> Von: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
> Gesendet: Montag, 23. Juli 2001 12:43
> An: [EMAIL PROTECTED]
> Cc: [EMAIL P
Best Regards,
Mike
Michael Gilman, PhD
Data Mining Technologies Inc.
(516) 470-9011 ext 100
[EMAIL PROTECTED]
The information transmitted in this email is intended only for the person(s)
or entity to which it is addressed and may contain confidential and/or
privileged material. Any review, ret
shutdown the server, tarball your data (mine is in
/usr/local/mysql/var) and transfer, then put it all back.
Andrew Pasetti schrieb am Montag, 23. Juli 2001, 13:47:32:
> Can someone please recommend the easiest way to transfer a database (with data) from
>one server to another? Here's the serve
Hi,
I have charset_set = czech.
i need to know which charset file i'm using(eg.
sql/share/charsets/win1250.conf or sql/share/charsets/latin2.conf)
i think that are some errors in these tables
while using upper and lower functions a get some strange results for
czech language.
Michal Dvora
Hello everyone,
I try to install and configure mysql under win2000, initally it seems to
work ok but whenever I try to create a table or modify any of the existing
tables I get the following error: ERROR 1036: Table is read only
e.g.
mysql> insert into user values('localhost','mysql',passw
In version 3.22.32 I can't get the "Invert all bits"-function to function. Is it
implemented later or am I doing it all wrong?
I'm trying to do a "select ~bitmask from mytable"... I've tried with (~bitmask) and a
gazillion other tricks, but only get a syntax error out of it..
Anyone?
---
Can someone please recommend the easiest way to transfer a database (with data) from
one server to another? Here's the server info:
Existing server:
Linux 2.2.14-5.0 running mysql 3.23.10-alpha
New server:
Linux 2.2.14-5.0 running mysql 3.23.32
Thank you. Your feedback will be greatly app
Could this be related to the problems which cause mysql to be almost
un-killable on MacOS X? I have tried to use mysqladmin to stop the server,
but the only thing that will do it is 'kill -9', and if I had started it
with safe_mysqld, then it comes bouncing right back. I can't even find
safe_mysql
I had the same problems when executing queries with an HAVING clause and
TEXT fields SELECTed, at least using InnoDB tables.
If you are in the same position you can use substring(text_field, 128) to
solve your problem, at least partially.
Hope it helps
Nico
On Fri, 1
Hi
> Warning: Wrong parameter count for mysql_fetch_row() in
> /web/sites/94/ichmussweg/www.ichmussweg.f2s.com/gastebuch.php on line 54
>
> line 54 is the last one of the code extract starting with "while($row":
> $res=mysql_query("SELECT id as id, msg as msg,
> date_format(datum,'$datumsForma
[EMAIL PROTECTED] writes:
> >Description:
> mysql.server stop fails to stop the server even though
> mysql.server start was used to start it.
>
> The INSTALL-SOURCE text file recommends using the script
> support-files/mysql.server to start mySQL at boot-time.
>
Eldon Ziegler writes:
> Running ./configure fails check for MySQL include directory. The library
> directory is found and the include directory is there when I list it. What
> is it looking for?
>
> Eldon Ziegler
> ProAtion Systems
> [EMAIL PROTECTED]
> http://www.proation.com
>
There are op
For example I use
mysqldump -c -h localhost -u pferdezeitung -p pferdezeitung | gzip -9 > pz.sql.gz
my db is pferdezeitung, user is pferdezeitung, it will be written
to the dir i am in at the moment and zipped to pz.sql.gz - hence
I need create and write priviledges in that dir. Also,
mysqldump
hi to everyone
the following code is taken from a guestbook. it worked fine for years but this
morning I got the following error-msg:
Warning: Wrong parameter count for mysql_fetch_row() in
/web/sites/94/ichmussweg/www.ichmussweg.f2s.com/gastebuch.php on line 54
line 54 is the last one of
I have installed Redhat Linux 7.1 with the supplied MySQL distribution
(3.23.36?). I've run the "mysql_install_db" script, but when I try to start
MySQL using "./bin/safe_mysqld --user=mysql &", from the installation directory,
MySQL starts then ends immedately ("MySQL ends") without an error!!
Thanks you ,
But with mysqldump I don't know where the dump file will be store ?
I just made a ./mysqldump -A
- Original Message -
From: "Werner Stuerenburg" <[EMAIL PROTECTED]>
To: "Philippe Pham" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, July 23, 2001 11:51 AM
Subje
use mysqldump - look for it in manual
Philippe Pham schrieb am Montag, 23. Juli 2001, 11:16:08:
> Who know how to dump a database for backup it.
--
Herzlich
Werner Stuerenburg
_
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel
Is there a FAQ for users of mySQL? I can't find one on the web site. The
O'Reilly book (``MySQL and mSQL'', by R. J. Yarger, George Reese and Tim
King) has proved useful.
One question I'd like to know the answer to is whether I have to have
all the files which store my various user's databases in
Hi!
On Jul 22, William R. Mussatto wrote:
> >
> > Well, on my tests I was able to add ~4,000,000 rows in 17 hrs
> > with MySQL 3.23, and in 4 hrs in MySQL 4.0
> >
> > Table had 4 indexes. Removing those increased the speed by
> > several orders of magnitude (!!!).
> >
> > Hadware was moderate
Hi everybody,
Who know how to dump a database for backup it.
Thanks in advance...
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
I created a script to create a table.
The script is as follows:
===
use Contacts;
CREATE TABLE Lead (lastname varchar(50), firstname
varchar(50), title varchar(200), company
varchar(200),
telephone_work varchar(15), telephone_home
varchar(15),
fax varchar(15), email varchar(100), a
Hi,
> Quick question about the SHOW TABLE STATUS command and the
> Data_free info in
> particular.
>
> You say: "If it is high, then it's time to run OPTIMIZE TABLE..."
>
> What is considered high? As I'm looking at my output, I see that
> most of my
> tables show a value of 0, however, some have
1 - 100 of 105 matches
Mail list logo
