mysqldump invoked with --xml/-X omits the backslash from closing tags for
columns of type: enum, varchar and date.
Martin Tsachev
Web developer
http://martin.f2o.org
>MySQL support: none
>Synopsis: mysqldump --xml generates opening tags instead of closing for data,
varchar and enu
Is there any standard method or benchmark to run localy or remotly to my
host to help me to setup MySQL better
or to check various computer/configurations?
I could find anything on http://www.mysql.com/information/benchmarks.html
links.
Only at third part software but it is in C++, not .sql. Wh
At 16:05 3/8/2002 -0500, Paul DuBois wrote:
Hi Paul,
>Thanks, Miguel. This sounds promising. I don't see anything about this
>in the 4.0.2 change notes,
Sorry Indeed it wasn't mentioned.
> and I have some questions about how this works:
>
>- What does the argument after the --install argum
how can i make MySQL show only what db are available to the user?
i.e., when a user logs in from a terminal application and types:
'show databases;'
they only are shown the db(s) they have access to.
?
Thanks
-
Before postin
how can i make MySQL show only what db are available to the user?
i.e., when a user logs in from a terminal application and types:
'show databases;'
they only are shown the db(s) they have access to.
?
Thanks
-
Before postin
At 3:03 -0300 7/26/02, miguel solorzano wrote:
>At 19:07 25/7/2002 -0700, Bhavin Vyas wrote:
>Hi,
>
>>From what little I know of MySql on Windows, it runs as a service and you
>>can't run multiple services on the same Win Server.
>
>
>
>From 4.0.2 release you are able to run several services. For
Here is the dump of those tables being used:
allusa:
+--++--+-+--+---
+
| Field| Type | Null | Key | Default |
Extra |
+--++--+-+--+---
> Hello everybody!
>
> I am new to mysql and am totally confused as how to proceed? Is it installed
> automatically like perl or do I have to install and configure? in the docs
> its often referred as "shell> mysql" but when I type it on c: prompt it says
> access denied. can anybody help?
>
> T
Hi Flash:
This is a shot in the dark, but when I set up some tables using
phpMyAdmin, I set a field to auto_increment and a default value of 0,
phpMyAdmin created the table, but without the default value. When I add
records from a form, it increments correctly. Perhaps the default value
sho
Are you sure that you are running the server at all?
Nikodim
Here's my bug report
Version: MySql 3.23.51.
OS: Linux linux 2.4.18 #4 Fri May 31 01:25:31 PDT 2002 i586 unknown
Memory: 64MB + 256MB(Swap)
Distibution Name: mysql-3.23.51-pc-linux-gnu-i686
I runned MySQL with the command: bin/sa
Are you sure that you are running the server at all?
Nikodim
Here's my bug report
Version: MySql 3.23.51.
OS: Linux linux 2.4.18 #4 Fri May 31 01:25:31 PDT 2002 i586 unknown
Memory: 64MB + 256MB(Swap)
Distibution Name: mysql-3.23.51-pc-linux-gnu-i686
I runned MySQL with the command: bin/sa
Hi,
I'm trying to get mySQL 4/myODBC working properly with CF5 on a Win2k
machine, but am having problems with auto_increment.
I've set up some tables using auto_increment for the ID field, and when I
insert a record using mySQLgui or the MSDOS mysql command line tool, it
increments correctly
>Description:
The following command is invoked by make:
g++ -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -rdynamic
-o .libs/mysqlbinlog mysqlbinlog.o ../libmysql/.libs/libmysqlclient.so -lz -lcrypt
-lnsl -lm -lz -lcrypt -lnsl -lm -Wl,--rpath -Wl,/usr/local/lib
Are you using InnoDB type tables? The default table type is MyIsam which
does not support foreign keys.
Regards,
Bhavin.
- Original Message -
From: "muad" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 03, 2002 5:52 AM
Subject: hey
> hope its okey for me too ask you
Sergey S. Kostyliov writes:
> >Description:
> Any grant at a tables level make 'CREATE TEMPORARY TABLE' privilege
> not working
> ERROR 1142
>
> >How-To-Repeat:
> 1) (under root)
> mysql> GRANT CREATE TEMPORARY TABLES ON *.* TO
> test_user@localhost IDENTIFIED BY 'test_p
First, make sure you purchase the necessary licenses and support contract.
Building your own installer is a piece of cake. We use InstallConstruct, but
InstallShield, Wise, etc. will do just fine. Create the database(s) the way
you want them, and include them in your installer package. Make sure
Here's my bug report
Version: MySql 3.23.51.
OS: Linux linux 2.4.18 #4 Fri May 31 01:25:31 PDT 2002 i586 unknown
Memory: 64MB + 256MB(Swap)
Distibution Name: mysql-3.23.51-pc-linux-gnu-i686
I runned MySQL with the command: bin/safe_mysqld --user=mysql &, and all was
done.
When I tried to access
Hi,
What I would like to do is use MySQL for a desktop application.
So not with a remote SQL Server.
I'm using VB.NET and Native MySQL support to connect to mysql servers, which
works just fine.
But I would like to distribute an application which runs only on the local
machine and uses
mySQL a
Hi
Installed Mysql (from mysql-3.23.51-win.zip) to c:\mysql on my pc
(running Windows XP Professional)
Started Apache (1.3.20) that I got with mod_perl . runs ok (can do perl
scripts on it ok)
Tried to execute c:\mysql\bin>mysqld
(as in the manual)
after about 5 seconds, comes back with nor
hope its okey for me too ask you an question regarding linking of tables...
i have been building the tables that are in the manual
http://www.mysql.com/doc/en/example-Foreign_keys.html
Still i cant understand why i can add and new shirt for an person that
isnt there,
i am using the mysql 3.23.49
At 23:19 2/8/2002 +, Tien Lim wrote:
Hi,
>To Whom It May Concern:
>
>Environment:
>Operating System Windows XP Home Edition
>Using MySQL 3.23
>Using Apache 1.3.12
>
>Initially it started working suddenly after trying all of the commands
>below... : )
>
>The next day I started the computer an
Pete,
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Friday, August 02, 2002 2:40 AM
Subject: Re: InnoDB: Looong pause when log file is full?
> On Thu, Aug 01, 2002 at 04:37:05PM -0500, Pete Harlan wrote:
> > Hi,
> >
> > I've rea
22 matches
Mail list logo
