Connection Failed
2003 - Cannot Connect to MySQL server on 10.1.1.95 (10061)
Hi,
it seems that the MySQL Server is not running.
Try to start the server.
Best regards,
Roland
--
[EMAIL PROTECTED]
-
Before posting,
On Tue, Jul 16, 2002 at 07:49:27PM -0500, mos wrote:
With InnoDb you need to pre-allocate file space so all the tables get put
into one file. This is a good idea when you have a lot of people accessing
the database because it reduces the file handles (less work for the
operating system).
Hi list,
I would like to get any suggestion on how i can go about my
problem the most efficient way.
I have a program that reads the log file and displays it for
the user. At the moment, it retrieves all the data in mysql
database. I would want to add paging capabilities to it. I am
Hi,
Not sure which language you are using, but I hope this will give you some
ideas: http://www.phpbuilder.com/columns/rod20001214.php3
Hope this is useful,
Shashank
--
sql, query, select etc. all the jazz that will
make this message go through to the list.
Hi,
I just want to know if I can just copy a MySQL database from, say Windows 2000
to Linux. Will it still work? Does it has binary data compabilities?
Thank you
Yours Truly,
Hanxue
-
Before posting, please check:
Hi,
I've downloaded mysql-max-4.0.2-alpha-win.zip
(Anyway, the size of this file is the same as mysql-max-4.0.1-alpha-win.zip)
When I unzip this file and start to install it, I can see in the setup
window that it is MySQL-max-4.0.1
What is the problem. Guys at MySQL did a mistake, or I
Hi Ken
I have had a look on FreeBSD.org and can only find a ref to polling as a
subroutine that is used if the system crashing.
What douse this number?
And so how will it effect MySQL?
Thanks
Simon
-Original Message-
From: Ken Menzel [mailto:[EMAIL PROTECTED]]
Sent: 16 July 2002 16:07
Hi,
Has anyone tried building a MySQL server for Windows CE ?
I have found a really good client for CE called DALP
(http://www.kalpadrum.com/dalp/) but no server.
It would be really good to have a cut down MySQL server on PDAs. I have had
a go at compiling the server using Embedded Visual C++
Jon,
replication 4.0.1 - 4.0.2 does not work because the format in the 4.0
series has evolved. Currently, if your master of the 4.0 series, your slave
must be of the exact same release.
All 3.23 versions after 3.23.33 can be replicated from each other
4.0.0 can only replicate to/from 4.0.0.
Description:
I am testing the replication of one database from this host to a slave MySQL
server.
Some of the queries that ALTER a table structure are not replicated to the
slave,
causing a stop of the replication.
I said some because while I was troubleshooting
Daniel,
thank you for noticing this. Apparently the Win distribution of
MySQL-Max-4.0.2 is accidentally the same file as MySQL-Max-4.0.1.
Workaround if you do not need BDB tables: download the Win distribution of
MySQL-4.0.2 (without the 'Max').
Best regards,
Heikki Tuuri
Innobase Oy
---
Hi!
There is an error in the Windows download of MySQL-Max-4.0.2. It is a wrong
file, the same as MySQL-Max-4.0.1.
If you do not need BDB tables, please download the Windows version of
MySQL-4.0.2 (without the 'Max') instead.
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions,
I've this query that is too slow, how can I optimize this sintax ?
SELECT * FROM table_1
INNER JOIN table_2 ON ID_table_2=table_1_ID
INNER JOIN table_3 ON ID_table_3=table_2_ID
INNER JOIN table_4 ON ID_table_4=table_3_ID
INNER JOIN table_5 ON ID_table_5 = table_4_ID
INNER JOIN table_6 ON
Hello,
Here is my problem, I would like to use mysqlimport (which i
have compiled as a batch file to run) from a client side to load data onto
the database on a server side, meaning that I would normally access my
server through the pc and running the batch file. Problem is that there
Hello.
In mysql tables Db, User, Host I can use templates as host ,for example.
But can I use templates in tables_priv as table name?
For example I want to set INSERT permission to H_% tables.
How can I set it?
Best regards.
___
Andrey Kotrekhov
Don't use 'root' ... create a new user, and make sure you GRANT the proper
privs (i.e.:
USE mysql;
GRANT ALL PRIVILEGES ON *.* TO username@localhost IDENTIFIED BY
'password';
GRANT ALL PRIVILEGES ON *.* TO username@% IDENTIFIED BY 'password'
WITH GRANT OPTION;
- Original Message
MySQL doesn't have an internal clock. It uses the O/S's clock.
Each of our servers (both Linux and Win32) running MySQL logs into a time
server to set the system clock twice a day. Time references in the MySQL
databases are always dead-on.
- Original Message -
From: Paul Wallace [EMAIL
Well, by now i have found a way to work around the problem,
still the problem is not solved, you may want continue thinking about it:
start with this:
iSession iUser sSession
-- -- -
1 41 no
2 41 wanted
3
Have you tried explain?
Do all of your ID fields have indexes?
Have you tried breaking it into multiple statements? Each statement creating
a temp table except the last?
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Lorenzo De Vito
I can see where accessing the server from a handheld would be cool but I
question the concept of actually RUNNING the server on a handheld. Write a
cool lightweight client with the library and leave the server on beefier HW.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
Yes and no.
No, you can't (shouldn't) copy the file from one server to another. Bad
Mojo. It MAY work if you are only using MyISAM file types but no promises
there.
You would be much better off using mysqldump to dump the contents of your
databases to a text file and then re-importing them on
Hello All,
I m using mysql server and myodbc driver in linux.
I wud like to print the correct error message if any
error occur while we r communicating with server eg.
access denied, connection failure, no data is
available , table does not exits, duplicate data
etc.
How can i see
Depends on the language you are writing in and the acceptable latency of the
user.
If you are writing in PHP or another scripting language for a web based
application where the server will have to artificially preserve stat then I
would not attempt to cache the recordset, I would get a new one
From: Robo [EMAIL PROTECTED]
Well, by now i have found a way to work around the problem,
still the problem is not solved, you may want continue thinking about it:
start with this:
iSession iUser sSession
-- -- -
1 41 no
2
If mysql owns them, 0770 should be fine.
System Administrator a.k.a. The Root of the Problem wrote:
USually all the databases sets up fine BUT recently, I have
had to adjust databases to 0777 in order to get them to
work and change the ownership.
I prefer the more secure model of mysql.
How
Another option is to use a program like mysqlfront, open both server and
local versions of mysql and use export facility in mysqlfront. I've found
this particularly useful.
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 17, 2002 3:13 PM
To: Hanxue
Hi
i have a simple question. how can i change mysql root password? if i
change it using winmysqladmin.exe, and changing it in my.ini, nothing
happens. i can change passwords using phpmyadmin, but i would like to
change it without it.
thanx
M.
From MySQL manual:
http://www.mysql.com/doc/M/o/Moving.html
http://www.mysql.com/doc/U/p/Upgrading-to-arch.html
I have tried and it works in HP-Solaris and LINUX, but
I tend to agree with Cal, my recomendation is to use
an alternative procedure such as dumping and
importing.
Bye and Good
From: Jenny Christy [EMAIL PROTECTED]
I m using mysql server and myodbc driver in linux.
I wud like to print the correct error message if any
error occur while we r communicating with server eg.
access denied, connection failure, no data is
available , table does not exits, duplicate
I still need to get a version of mysql working on
AIX 4. I have been watching the mail list and
have seen nothing about a new release. I recently
looked at the web site and found that the current
download binary release is now 3.23.49 and it
previously was 3.23.51. Does this mean that .49
is now
See comments below...
-- Arul [EMAIL PROTECTED] wrote:
Hi
I Dont think this will work coz I need the company
which has serviceid = 1
AND serviceid = 2 and serviceid = 3
I think that you are mixing natural language with
logical expression, right? The expression above always
returns FALSE,
Daniel,
Wednesday, July 17, 2002, 8:20:30 AM, you wrote:
DK I've been trying to grant users the right to create temporary tables:
DK grant create temporary table on mydatabase.* to user;
DK flush privileges;
DK I've also tried:
DK grant create temporary table on mysql.* to user;
DK flush
Defryn,
Wednesday, July 17, 2002, 12:56:31 AM, you wrote:
D I have a build an ASP page to enter data in a mysql database.
D When I open the page I get the following error :
D Error Type:
D Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
D [TCX][MyODBC]Lost connection to MySQL server
Paul,
Wednesday, July 17, 2002, 5:07:44 AM, you wrote:
PW I just encountered a problem when entering a datetime field. Using
PW 'now()' in my SQL string input a time about 13 minutes before my other
PW method (a JSP System.currentTimeMillis() method - one that generates the
PW time from
Hanxue,
Wednesday, July 17, 2002, 8:39:03 AM, you wrote:
HL I just want to know if I can just copy a MySQL database from, say Windows 2000
HL to Linux. Will it still work? Does it has binary data compabilities?
Yes, you can just copy from Win to Linux, but I suggest you to use
mysqldump instead
J.M.Roth,
Tuesday, July 16, 2002, 11:46:29 PM, you wrote:
JMR will it work if I add some custom fields to the mysql user table?
In some code MySQL checks a number of columns, so you might have a
problems if you add some custom fields ...
As far as I remember my own experiments with MySQL I got
Aaron,
Tuesday, July 16, 2002, 11:05:09 PM, you wrote:
AA [root@Alpha mysql]# pwd
AA /usr/local/mysql
AA [root@Alpha mysql]# ls -al
AA total 48
AA drwxr-xr-x 12 root mysql4096 Jul 15 01:31 .
AA drwxr-xr-x 14 root root 4096 Jul 15 01:27 ..
AA drwxr-xr-x2 root
Andrey,
Wednesday, July 17, 2002, 1:54:12 PM, you wrote:
AK In mysql tables Db, User, Host I can use templates as host ,for example.
AK But can I use templates in tables_priv as table name?
AK For example I want to set INSERT permission to H_% tables.
AK How can I set it?
You can't.
--
For
luis,
Tuesday, July 16, 2002, 8:18:04 PM, you wrote:
l Do you have some information for install mysqlgui in Linux, i do not how do
l it?
Look into the README file ..
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net
Narcis,
Tuesday, July 16, 2002, 6:02:21 PM, you wrote:
NG Please tell me if the MySQL 4.0.2-alpha Windows 95/98/NT/2000/XP (17.2M)
NG supports the subselect command.
No, sub-selects will come in 4.1
How to re-write queries without sub-selects is described at:
Hi,
All of a sudden it seems that my MYSQL is incapable of being written to. I
can still read from it, but cannot write to it. When I looked at the
processes, all the processes that tried to write to the database are in a
state of 'Locked'. Any ideas what to do?
- Dan Relihan
From: [EMAIL PROTECTED]
i have a simple question. how can i change mysql root password? if i
change it using winmysqladmin.exe, and changing it in my.ini, nothing
happens. i can change passwords using phpmyadmin, but i would like to
change it without it.
Do you have access to the MySQL
Add the sSession field and put in the not wanteds and wanteds you will see that the 3
rows your query returns is the first ones in the list per iUser that are the not
wanteds. The query somehow needs to select the second ones. This is where the problem
comes in.
-- Original Message
From: Brian P. Millett
Technote for using mysql raq4:
ftp://ftp.cobalt.sun.com/pub/developer/TechNotes/DTN15-0-0.pdf
Thanks Brian! that is an excellent resource.
I just joined this list 2 days ago and that was my first post yesterday.
I was slapped on the wrist for posting multiple times
pornost4r,
Wednesday, July 17, 2002, 4:45:18 PM, you wrote:
p i have a simple question. how can i change mysql root password? if i
p change it using winmysqladmin.exe, and changing it in my.ini, nothing
p happens. i can change passwords using phpmyadmin, but i would like to
p change it without
On Wednesday 17 July 2002 09:09, Cal Evans wrote:
I can see where accessing the server from a handheld would be cool but I
question the concept of actually RUNNING the server on a handheld. Write a
cool lightweight client with the library and leave the server on beefier
HW.
There are
Dear all,
I'm trying to write some UDFs and it will help a lot if I can print
debugging information out directly to the screen so I can see what's going
on. But printf() etc does not print to the mysql client screen. Is there
an easy work around?
Thanks for any tips,
fei
Can mysql copy from table1 to table2?
Thanks.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL
I guess your harddisk ran out of space. Delete some stuffwithout
restarting the database.
Relihan, Daniel wrote:
Hi,
All of a sudden it seems that my MYSQL is incapable of being written to. I
can still read from it, but cannot write to it. When I looked at the
processes, all the processes
Tod,
This is exactly what I am looking for. The CE PocketPC platform is the one
I could make good use of. Just the MyISAM table type and no client/server
needed. The pocket access table functionality included in PocketPCs is very
limited and SQL Server CE is great but expensive and slightly
print them to a log file, and
tail -f logfile
from another window.
Fei Chen wrote:
Dear all,
I'm trying to write some UDFs and it will help a lot if I can print
debugging information out directly to the screen so I can see what's going
on. But printf() etc does not print to the mysql client
Yes,
CREATE TABLE tbl SELECT * FROM tbl;
Vivian Wang wrote:
Can mysql copy from table1 to table2?
Thanks.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
On Wednesday, 17. July 2002 18:07, Vivian Wang wrote:
Can mysql copy from table1 to table2?
Yes, if table t2 doesn't exist you have to create table2 first.
Then you can use INSERT .. SELECT STAMENT.
http://www.mysql.com/doc/I/N/INSERT_SELECT.html
Regards
Georg
mysql,query
Sir,
I am a PG student of Indian Institute Of Information techology And
Management Kerala.I had been using your product.I would like to get an
information.
I would like to know the maximum number of rows and columns which can be
inserted into a table in MYSQL.
I hope you will reply to
sql query
We have data stored as BIGINT in unix, and there are 32bit unsigned values
but nothing larger. I would assume if we convert this to integer in win98
it would seem that values over 31bits would be wrong. Are there workarounds
for this? Is this also an issue in later version of
Hi,
I've compiled mysql-4.0.2-alpha from source, and I cannot seem to
get it to bind to an interface and allow TCP connections.
When I do a SHOW VARIABLES I see skip_networking=ON yet I am not
starting mysql with --skip-networking. To reverse this situation I
tried putting:
set-variable =
I recently download mysql-3.23.51 and compiled it on a solaris 9 (sparc)
system using gcc-3.1. I ran into a couple of minor compile errors which
were easily fixed by a couple of type casts.. so far, it seems like the
casts are fine here are the diffs
--- sql/mysqld.cc.orig Wed Jul
From: [EMAIL PROTECTED]
Sir,
I am a PG student of Indian Institute Of Information techology
And Management Kerala.I had been using your product.I would like to
get an information.
I would like to know the maximum number of rows and columns which
can be inserted into a table in MYSQL.
Hello,
I have been asked to spec out a new computer that will act as a
dedicated MySQL server for a research cluster (running under RH
Linux). To do that, I am trying to find information on the
performance trade-offs between multiple processors (2 vs 4), the disk
system (IDE vs SCSI; single vs
Hi mysql list members,
Is it possible to reboot the linux server through a PHP page. Like a client
clicking on a button in a php page and that would result in rebooting the
linux server.
Can this be done?? Pls help,
Regards,
Harpreet Kaur
i recompiled/reinstalled 3.23.51. i copied mysql.server /etc/rc3.d/S99mysql.
i edited /usr/local/etc/my.cnf. i started mysql and it read the my.cnf file
from that location and everything worked great. i created a solaris package
and installed it on another system. the system the package was
Although this is the wrong forum for this question, you certainly can. PHP
has functions available to execute programs or command lines.
http://www.php.net/manual/en/ref.exec.php
Mike
-Original Message-
From: Harpreet Kaur [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 17, 2002 3:38
Yes, but this would be better addressed on a PHP list. This is MySQL.
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Harpreet Kaur [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 17, 2002 2:38 PM
To: [EMAIL PROTECTED]
Subject: using a php page to
Just playing around a little with this problem, I think I found something
that works. Here it is,
CREATE TABLE `o_sessions` (
`isession` int(11) NOT NULL auto_increment,
`iuser` int(11) NOT NULL default '0',
`ssession` varchar(50) NOT NULL default '',
PRIMARY KEY (`isession`)
)
On Wednesday, 17. July 2002 21:38, Harpreet Kaur wrote:
Hi mysql list members,
Is it possible to reboot the linux server through a PHP page. Like a client
clicking on a button in a php page and that would result in rebooting the
linux server.
Can this be done?? Pls help,
Yes, its
John,
Going off the top of my head and what you posted I would suggest a dual
processor machine with at least 1 GB of RAM. (Make sure you compile MySQL
with threads) SCSI is going to be much faster than IDE. If this is a
production machine I would highly recommend SCSI. Finally, I would
could it be a system permissions problem?
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Shon Stephens [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 17, 2002 2:38 PM
To: '[EMAIL PROTECTED]'
Subject: more weird my.cnf foo???
i
Are you sure you want to do that?
Since php can call local programs, you can call one to reboot your computer.
I think it's not a good idea to allow it.
Anderson Pereira Ataides
Em Quarta 17 Julho 2002 16:38, you wrote:
Hi mysql list members,
Is it possible to reboot the linux server
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:root
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Release:
On Wed, Jul 17, 2002 at 08:04:47PM +0100, Andy Smith wrote:
Hi,
I've compiled mysql-4.0.2-alpha from source, and I cannot seem to
get it to bind to an interface and allow TCP connections.
When I do a SHOW VARIABLES I see skip_networking=ON yet I am not
starting mysql with
Hi,
I would like to know the maximum number of rows and columns
which can be inserted into a table in MYSQL.
The maximum number of columns in a table is currently 3398. The maximum
number of rows is not limited - the only limit is your hard disk space.
By the way, you can see this and much
When I want to run two servers with different
configuration. Can I run in the same machine and two
running?
Alexander
sql, query
___
Yahoo! Encontros
O lugar certo para encontrar a sua alma gêmea.
On Wed, Jul 17, 2002 at 01:24:41PM -0700, Jeremy Zawodny wrote:
On Wed, Jul 17, 2002 at 08:04:47PM +0100, Andy Smith wrote:
Hi,
I've compiled mysql-4.0.2-alpha from source, and I cannot seem to
get it to bind to an interface and allow TCP connections.
When I do a SHOW VARIABLES I
The MySQL daemon does not run. I installed the binary RPM's from the RH cd,
MySQL 3.23.49. I run mysql_install_db, outputs some text and appears to
execute correctly. The I run safe_mysqld , and I get:
[root@thor rfox]# /usr/bin/safe_mysqld
[1] 2212
[root@thor rfox]# Starting mysqld daemon
Hi,
I'm having a problem dropping a foreign key constraint from an Innodb table. I am
using MySQL 3.23.51 for Win32. Any help would be greatly appreciated
I have a simple set up like the one below:
CREATE TABLE mastertable
(
masterkey INT NOT NULL PRIMARY KEY AUTO_INCREMENT
)
I'm working with MySQL and Delphi.
I created the following table:
Create table Ligacoes (
Lig_cod INTEGER NOT NULL,
Lig_codate INTEGER NOT NULL,
Lig_nomeat VARCHAR(20),
Lig_data DATE NOT NULL,
Lig_duv TEXT,
Lig_resp TEXT,
Lig_penden CHAR(1),
Lig_codcli INTEGER,
Lig_erro CHAR(1),
Lig_os
On Wed, Jul 17, 2002 at 09:33:37PM +0100, Andy Smith wrote:
Is there a rogue .my.cnf file or my.cnf lurking about elsewhere maybe?
Ah, you're absolutely right. In /etc/my.conf there appears
skip-networking
The problem is, I need to run multiple mysql servers on this
machine. Is
Dig around for a log file or an error file. Whenever it won't start it tells
you why (or gives you a hint) in the error file. tail it and post if you
still need help.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Richard Fox [mailto:[EMAIL
At 03:34 AM 7/17/2002, you wrote:
Hi,
Has anyone tried building a MySQL server for Windows CE ?
I have found a really good client for CE called DALP
(http://www.kalpadrum.com/dalp/) but no server.
It would be really good to have a cut down MySQL server on PDAs. I have had
a go at compiling
On Wed, Jul 17, 2002 at 04:40:50PM -0400, Richard Fox wrote:
:
: The MySQL daemon does not run. I installed the binary RPM's from the RH cd,
: MySQL 3.23.49. I run mysql_install_db, outputs some text and appears to
: execute correctly. The I run safe_mysqld , and I get:
:
: [root@thor rfox]#
On Wed, Jul 17, 2002 at 02:42:23PM -0700, Jeremy Zawodny wrote:
On Wed, Jul 17, 2002 at 09:33:37PM +0100, Andy Smith wrote:
Is there a rogue .my.cnf file or my.cnf lurking about elsewhere maybe?
Ah, you're absolutely right. In /etc/my.conf there appears
skip-networking
The
Hello,
I run the web site for a band, and I am currently working on the shows list
for the band. I have all of the shows listed in a database right now. I
don't want to remove the shows that occurred in the past, but instead I want
to have a query find only the shows that occur in the future. I
Hi,
Andy Smith wrote:
On Wed, Jul 17, 2002 at 01:24:41PM -0700, Jeremy Zawodny wrote:
On Wed, Jul 17, 2002 at 08:04:47PM +0100, Andy Smith wrote:
Hi,
I've compiled mysql-4.0.2-alpha from source, and I cannot seem to
get it to bind to an interface and allow TCP connections.
References: [EMAIL PROTECTED]
Mail-Copies-To: nobody
X-PGP-Fingerprint: E394 1C70 C7F9 B740 CD2E FAC2 18CD 25A5 22F3 8AF3
Organization: LinuxFr - http://linuxfr.org
Date: Thu, 18 Jul 2002 01:28:26 +0200
In-Reply-To: [EMAIL PROTECTED]
([EMAIL PROTECTED]'s message of Thu, 18 Jul 2002 00:48:13
That sir, it the coolest hint I've seen in a while.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 17, 2002 5:47 PM
To: [EMAIL PROTECTED]
Cc: Andy Smith
Subject: Re: Opposite of
From: Erick Hitter [EMAIL PROTECTED]
Hello,
I run the web site for a band, and I am currently working on the
shows list for the band. I have all of the shows listed in a database
right now. I don't want to remove the shows that occurred in the past,
but instead I want to have a query find
Hello!
I found a small thread from 2 years ago that said that replication was
restricted to MyISAM table types. Is this true? Can I not replicate InnoDB
table types?
The reason I ask is that I am getting a the 1189: Net Read Error when I run:
LOAD TABLE name FROM MASTER;
Is there a work around
On Wed, Jul 17, 2002 at 04:42:35PM -0700, James Kelty wrote:
Hello!
I found a small thread from 2 years ago that said that replication
was restricted to MyISAM table types. Is this true? Can I not
replicate InnoDB table types?
It is no longer true.
The reason I ask is that I am getting a
Hi..
I'm working on a proyect to implement a SQL server with PHP to allow acces
to a MySQL server on the web.
The Master server (the server everybody work with) is a Windows 2000 CENTURA
SQL server.
I want to know how i can manage to export a database from that server to
another server (The one
Yes, you can just copy from Win to Linux, but I suggest you to use
mysqldump instead and copy a dump file.
I know it is probably not necessary to point this out, but you probably
would have zero success directly copying the database files from MSWin
to, say, linux/ppc.
Definitely best to use
mysql:
how to rename column name exception that use alter table tablename column
newcolumn expression. I want get fast to rename the column name, but use front idea is
very slowly when my table has 1000 record. help me!
Hi fellows,
I have a MySQL privileges question and hope someone can provide some
input on it.
I have setup a user who can access only one db, say 'DB1'.
About the privileges, I set the account privilege like this:
1) In user table, this account has Host='%' User='user_name'
Hello Alexander,
You can easily have two or more instances (mysqld processes) of
MySQL running on the physically same server as long as they have different
data directories. You possibly could, in theory, have a system where
several mysqld processess share the same data directory (still having
I am not able to run the Mysql server on a NT server and the data in another
NT server on the network.
See my my.in
innodb_data_file_path=\InnoData\HymnOMT:10M:autoextend
innodb_data_home_dir=d:\applicaz\mysql\InnoDB
innodb_log_group_home_dir=d:\applicaz\mysql\InnoDB\InnoLog
Did you try:
FLUSH PRIVILEGES;
Also, to see what user can do with his permissions you can try this:
SHOW GRANTS FOR username;
Mihail
Quoting Yat-Shing Tam [EMAIL PROTECTED]:
Hi fellows,
I have a MySQL privileges question and hope someone can provide some
input on it.
I have
Hi all,
I have created a Database Designer for the MySQL databases on Windows.
I wanted to attach it to this mail, but it's more than 300K, so I wouldn't
be a good idea to send it to the mailing list, I think.
But I would like some of you to check it out.
So, if you would like to be a beta
96 matches
Mail list logo