En réponse à Ilyas Keser <[EMAIL PROTECTED]>:
Hi
you can use mysqldump et a crontab to save all databases in a text file.
Regards
Julien Sobrier
> Hi all...
>
> I am a new Linux user. Does any one have a shell script to backup all
> Mysql databases?
>
> Thanks
> ilyas...
>
> -
Christian,
the patch below may fix the problem if it is in the initialization of the
raw device to zero.
InnoDB does all normal i/o to/from the data files to memory addresses
aligned by UNIV_PAGE_SIZE. This is because earlier versions used the Windows
native AIO and that requires aligned memory
[EMAIL PROTECTED] wrote:
>
> The port and socket information all appears to be correct on both sides. the daemon
>must be hearing the initial connection, as it builds a thread. Should I rebuild with
>MIT p-threads? Or without libwrap?
>
> The version string of
> mysqld is "mysqld Ver 3.23
Hi,
I just would like to ask that what are the following foreign key definition
extensions good for exactly?
I mean how does these SQL syntaxes work?
MATCH FULL | MATCH PARTIAL
ON DELETE/UPDATE RISTRICT/CASCADE/SET NULL/NO ACTION/SET DEFAULT
Thx,
Daniel
Is there any reason you are opting for static linking ?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 19, 2002 11:11 AM
To: [EMAIL PROTECTED]
Subject: OpenBSD source build, server & client not talking
>Description:
I have just built MySQL on an
Georg,
Here is the content of the config.log file..
config.log
This file contains any messages produced by compilers while
running configure, to aid debugging if configure makes a mistake.
It was created by configure, which was
generated by GNU Autoconf 2.52. Invocation command line was
$
.
On Friday, 19. July 2002 01:57, Bradley Plies wrote:
Hi Bradley,
> mysql> select * from pfpbaserequest;
> ++--++-+--+
>
> | id | trx_type | tender | req_date| amt |
>
> ++--++-+--+
>
> | 1 |
Hi jeremy Thanks for the quick response.
Appreciate it.
One more clarification though...
How about bringing the database from Unix/liux to
Windows. Still OK?
THANKS!!
:)
jimmy
>From: Jeremy Zawodny <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Jimmy Fernandez <[EMAIL PROTECTED]>
>CC: [E
On Friday, 19. July 2002 07:03, Dexter S. Tan wrote:
Hello Dexter,
would be interesting to know the content from your config.log file.
Regards
Georg
mysql,query
-
Before posting, please check:
http://www.mysql.com/manual
On Friday, 19. July 2002 02:40, [EMAIL PROTECTED] wrote:
> Hi we have a problem,
> I have table of 1,000,000 rows and i do query all, and after i can't do any
> more, because this process to blockade all mysql i can't do query of any
> table.
>
> What can i do ?
Hi,
hard to say, when we don't kn
Dear MR/Mrs/Ms,
I working on a web project using PHP and MySQL with
Berkeley DB support for database. It is my first time
when I use BDB database type and I need it for
transaction support.
All look to be fine but sometime after few operation
on database, not necessary transaction, I get message
>Description:
I have just built MySQL on an OpenBSD 3.1 platform. The server and
client don't seem to be fully communicating. mysqladmin and mysql will
just hang with no output. Running mysqld with the --debug string
described in the manual, I notice that each time a client attempts to
connect,
Hi,
I would like to ask how come the installation won't work on my system.
Here are the details.
Specifications:
Sun Sparc Ultra-5_10 Generic_108528-13
mysql-3.23.51
gcc version 2.95.2 19991024
What I did:
shell> groupadd mysql
shell> useradd -g mysql mysql
unzip the files using gtar with no er
Jeremy,
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Cc: "Jon Frisby" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, July 19, 2002 7:17 AM
Subject: Re: MySQL 4.0.2 replication going bonkers?
> On Wed, Jul 17, 2002 at 12:0
On Fri, Jul 19, 2002 at 03:24:34AM +, Jimmy Fernandez wrote:
> Hi ALL,
> I just wanted to clarify something:
> 1. Can I upgrade the MySQL version from one older version to a newer
> version? For example if I have data base in ver 3.0 can I import over to
> newly downloaded ver 4.0 ? Will it
On Thu, Jul 18, 2002 at 04:25:25PM -0700, Chuck Simmons wrote:
> sql query
>
> In addition to being able to specify an update lock or a shared mode
> lock, one should be able to specify no lock. This is the moral
> equivalent of the Sybase "noholdlock" option. This is useful if you
> normall
I think you need to install both the mysql-client and the mysql-server?
What does the output of "rpm -a" say? (this lists all the rpm installed)
What does "whereis mysqladmin" say?
- Original Message -
From: "Steve Dickey" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July
On Wed, Jul 17, 2002 at 12:02:08PM +0300, Heikki Tuuri wrote:
> 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.
How likely is that to happen again?
yes.
You will need to install a mysql client on your box though.
Then, look up how to grant access to yourself from that server, here:
http://www.mysql.com/doc/G/R/GRANT.html
finally, you will connect as such:
...path/mysql -h remotehostname -u user -ppassword
Bhavin.
- Original Message
Hello Heikki and all,
I've already asked about this a year ago, but didn't finish my
investigations then.
What's the status with innodb and *unbuffered raw* io on linux?
The manual describes the use of the "newraw" and "raw" options, and I
know these work on disk devices (like /dev/sda8), but
Hi ALL,
I just wanted to clarify something:
1. Can I upgrade the MySQL version from one older version to a newer
version? For example if I have data base in ver 3.0 can I import over to
newly downloaded ver 4.0 ? Will it still work ?
Can I then delete off ver 3..0 and run the old database from v
Yes,
use the ``mysql'' client.
Terence wrote:
>
> Hi List,
>
> Wondering if anyone knows whether it's possible from bash, to connect to a
> remote mysql database? And if so, where I can find some help.
> All I require is to connect to another mysql database and get a list of
> users. (I am t
create table abc as (select * from xyz1);
insert into abc values (select * from xyz2);
The above 2 commands should do it.
You might need to change them a bit, if so
www.mysql.com/doc should be very helpful.
Regards,
Bhavin.
- Original Message -
From: "Ollie Acheson" <[EMAIL PROTECTED]>
T
[Sorry about the early send on the previous one ...]
I just upgraded our web server from 3.23.47 to 4.02 -- and I must say that
4.02 performance rocks! :-)
I was planning to wait for the beta builds, but the thing that triggered my
decision was the discovery of the query cache. Our database se
I just upgraded our web server from 3.23.47 to 4.02 -- and I must say that
4.02 performance rocks! :-)
I was planning to wait for the beta builds, but the thing that triggered my
decision was the discovery of the query cache. Our database server (1.4 GHz
Athlon on FreeBSD) typically runs betwee
Hi,
I am a newcomer to mysql (and pretty much to sql in general). I have a
question that is probably pretty simple to answer, but it is escaping
me at present.
I want to select records from two separate tables and put the results
into a result table. Seems pretty simple, but I don't want to join
Hi List,
Wondering if anyone knows whether it's possible from bash, to connect to a
remote mysql database? And if so, where I can find some help.
All I require is to connect to another mysql database and get a list of
users. (I am trying to avoid running another mysql db for just one table)
If no
Thanks Dude,
I gotta same probz... but I got it now :)
Regards
Nitesh
>
> From: Bhavin Vyas <[EMAIL PROTECTED]>
> Date: 2002/07/18 Thu PM 08:15:26 GMT+03:00
> To: [EMAIL PROTECTED], [EMAIL PROTECTED]
> Subject: Re: Host IP is not allowed to connect this MySQL server
>
> http://www.mysql.com/d
It's not a file it's in the database.
telnet to the server and login to mysql using the mysql client util like
this
mysql -u root -p
then hit enter and enter the password.
now do these commands to create a remote super user
mysql> GRANT ALL PRIVILEGES ON *.* TO
monty@youripaddresshere_or_%_for
Hi we have a problem,
I have table of 1,000,000 rows and i do query all, and after i can't do any more,
because this process to blockade all mysql i can't do query of any table.
What can i do ?
Thanks and Regards
-
Before po
http://www.mysql.com/doc/G/R/GRANT.html
- Original Message -
From: "Matt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 18, 2002 4:42 PM
Subject: Host IP is not allowed to connect this MySQL server
> Hello, I am trying to connect to a remote MySQL server of mine and I
>MySQL version 3.23.43 for SCO 5.06 binary INTEL.
>The point is that it doesn't make the rigth selection of the index
>When it performs
>explain select nfactura, nauclfe from auxiliar where nfactura like '30%'
>order by nfactura;
>The result we have is:
>table type possible_keys key key_len ref ro
Hi,
I am retrieving the values of some positions of a table in MySQL
dynamically.The position has null(automatically database insert that null
value),1,2 values.I have to retrieve that values to a java prog and to
check whether the retrieved value is 1,2 or null.This I am doing like
this.
OS: Win2K
MySQL: 3.23.51
What: CREATE TABLE
Problem:Column specification not honoring NOT NULL specifier.
CREATE TABLE PFPBaseRequest
(
# Uniquely identify this record
id INTEGER NOT NULL AUTO_INCREMENT,
trx_type
Hi,
Does anyone know where to view mysqlimport logs? After running with
"--replace" and I can see a number of rows recorded as deleted and some as
warnings. I can't locate any history anywhere - not in the current
directory, not in mysql installation location, not in in syslog...
Thanks much
Hello, I am trying to connect to a remote MySQL server of mine and I get
this error " Host IP is not allowed to connect this MySQL server " If
someone could give me the shortcut to this file so I can edit it to
allow me in- It would be greatly appreciated.
Thank You
Matt
sql query
fyi... Section 6.4.1 of the manual says:
"
SELECT [STRAIGHT_JOIN]
[SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT]
[SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] [HIGH_PRIORITY]
[DISTINCT | DISTINCTROW | ALL]
select_expression,...
[INTO {OUTFILE
Hi!
Please provide more details. Does the problem happen also if you replicate
all tables, not just use the replicate-do-table directive?
What is the table definition like (print SHOW CREATE TABLE in the master as
well as slave)? Does it have foreign key constraints? Give an example of an
UPDATE
In the last episode (Jul 18), Andy Fields said:
> Folks,
>
> On my FreeBSD UNIX/Apache virtual private server (ISP is NTT/Verio), I
> have MySQL-3.23.49 installed with one empty database and password
> created to get me started.
>
> My desktop "box" is Windows XP Pro.
>
> I've already downloade
James,
I am sorry, the manual page at
http://www.mysql.com/doc/I/n/InnoDB_restrictions.html is not up-to-date.
Look at http://www.innodb.com/ibman.html#InnoDB_restrictions instead:
.
* In the MySQL replication load table from master does not work yet for
InnoDB tables. A workaround is to alt
I am a mysql newbie and in search of some pointers to get mysql 3.23.51
installed on my Redhat 7.3 system. I have the RPM downloaded and installed
but I am not able to find the programs listed such as mysqladmin. The
mysqld process is running and I can run the mysql_install_db script.
Any id
Jason,
- Original Message -
From: "Jason Baker" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, July 18, 2002 11:48 PM
Subject: HP-UX 11, mysql-max
> I tried the HP-UX mysql depot from the HP Software Porting Center, but
> it doesn't have innodb support.
>
> Th
Hi!
I read a message from venu to somebody called Woods, concerning fixing some
of the bugs in the OLEDB-provider for MySQL trough external people.
(http://www.geocrawler.com/archives/3/108/2002/4/0/8496671)
Are you still interested in some fixes? I would be happy to give them to you
for free.
Rick,
these code excerpts may explain the problem:
/***
Returns the local storage struct for a thread. */
static
thr_local_t*
thr_local_get(
/*==*/
/* out: local storage */
os_thre
Hi
I have a web DB proyect and I would like to make a VB6 client where I can
connect to a local X database and a Web MySQL on a UNIX server.
So far, locally everything works great with VB6 and MySQL, the grids,
textbox, ADO control, etc.(DNS-Less and with DNS).
But when I connect to the DB on th
[ MySQL ]
Here's some additional data now that I've rebuilt using "--enable-debug" or
whatever the configure option is.
Here's what GDB is claiming is happening after it ran for about 2 minutes
(after initial startup when NO files needed to be created)
(gdb) where
#0 thr_local_get (id=60) at
See http://www.mysql.com/doc/J/O/JOIN.html
What you basically want is a left join between TalkTopics and TalkReplies.
Then any rows in TalkReplies that don't have a row in TalkTopics will come
back with all nulls (but they'll still make it through the query), i.e:
SELECT *, COUNT(TalkReplies.To
Folks,
On my FreeBSD UNIX/Apache virtual private server (ISP is NTT/Verio), I
have MySQL-3.23.49 installed with one empty database and password
created to get me started.
My desktop "box" is Windows XP Pro.
I've already downloaded and installed MyODBC 3.51.03 (full package/docs)
and my MS MDAC
Hi.. I recently built MySQL 3.23.51 on two different AIX 4.3 boxes using
the VisualAge C/C++ compiler 5 only to find that that MySQL daemon is
unable to properly start itself.. Below is the excerpt from the "err"
file.. I waited until it was done with writing out the large InnoDB
log/data file
I tried the HP-UX mysql depot from the HP Software Porting Center, but
it doesn't have innodb support.
The mysql-max capability page says that innodb is supported on HP-UX,
though... so presumably somebody, somewhere, has done this already.
When I'm trying to compile with gcc 2.95.3 or with gc
On Thu, Jul 18, 2002 at 11:44:14AM -0400, Richard Fox wrote:
: The mysqld.log file says:
:
: 020717 13:05:05 mysqld started
: 020717 13:05:05 /usr/local/libexec/mysqld: Can't find file:
: './mysql/host.frm' (errno: 13)
: 020717 13:05:05 mysqld ended
:
: But I do see the host.frm file:
:
: -r
>Description:
If a 'slave stop' command is while a slave is blocked waiting
for a table, the slave thread must be manually killed in order for the
slave stop command to complete.
>How-To-Repeat:
mysql> show slave status\G
*** 1. row **
hello all,
i'm new to the list (and to mysql, for that matter) and am looking for some help with
what should be a fairly simple query.
what i'm doing is writing a very simple bulletin board with jsp using two tables in
mysql. the first table contains the title and body of the topic and the se
You can see them because you are root, and you own them.
Mysql can't see them because it is mysql.
chown -R mysql /var/lib/mysql
Richard Fox wrote:
>The mysqld.log file says:
>
>020717 13:05:05 mysqld started
>020717 13:05:05 /usr/local/libexec/mysqld: Can't find file:
>'./mysql/host.frm'
First, nice username :)
Anyhow, use the /etc/init.d/mysqld script as root to start/stop mysql,
not the safe_mysqld binary. The init.d script really calls the
safe_mysqld binary, but ti also makes a couple sanity checks like
ensuring that the initial database files exist and are owned by the
prop
At first blush it looks like it's a rights problem. Need to have the
/var/lib/mysql owned by mysql.mysql... If you're starting mysql as the user
mysql...
HTH
.mark
> -Original Message-
> From: Richard Fox [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 18, 2002 8:44 AM
> To: Noamn; [E
Philip,
- Original Message -
From: "Philip Molter" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, July 18, 2002 6:23 PM
Subject: Re: Deleting foreign keys with Innodb tables
> On Thu, Jul 18, 2002 at 03:41:01PM +0300, Victoria Reznichenko wrote:
> : Archbold,
> :
I am not sure, but are you sure that mysqld is running as a root? Or as a
mysql (user) and mysql (group).
Try to check rights of the mysqld user.
Jan
- Original Message -
From: "Richard Fox" <[EMAIL PROTECTED]>
To: "Noamn" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, July 1
When the scripts where originally written, I didn't have a clue about the
DBD::MySQL module. I've also got scripts running in VBScript via ODBC, so I
wanted to stick to a standard I/O method.
-Chris
- Original Message -
From: "William R. Mussatto" <[EMAIL PROTECTED]>
To: "Christopher A
Ok, ok, now that I know that I 'can' replicate InnoDB tables, it's time I
got it to ACTUALLY replicate InnoDB tables, eh?
This is my /etc/my.cnf file from the master server:
[mysqld]
log-bin=/storage/mysql/replication.log
server-id=1
default-table-type=innodb
innodb_data_home_dir=/storage/inno
hi,
I cant use some characters in my full text search (like * , "" , etc.)
I found out that it was due to the old version of the mysql i am using.
Now the problem is i want to switch from the older version(3.23.49) to 4.0.2
so that my full text search can be more efficient.
Can some one tell me w
>Description:
I am using MySQL v4.0.2 and I have set up a master database and 2 slave
databases, all on separate Solaris machines. The replication works fine
when I INSERT or DELETE but does not perform my UPDATE statements. I have
used 'mysqlbinlog' on the relay lo
hi,
I cant use some characters in my full text search (like * , "" , etc.)
I found out that it was due to the old version of the mysql i am using.
Now the problem is i want to switch from the older version(3.23.49) to 4.0.2
so that my full text search can be more efficient.
Can some one tell me w
On Thu, 18 Jul 2002 16:05:34 +0200, Massimo Petrini wrote:
>Also in may NT machine appear the same error. Which is the problem ?
DBI is a perl module for interfacing with databases
see
http://search.cpan.org/search?module=DBI
-z
sql mysql query
--
z, [EMAIL PROTECTED] on 07/18/2002
Try useing something like :
mysqldump -Q --opt -F --all-databases -h serverName -u root
--password=yourpasswd > /some/where/backup.sql
It generates a SQL commands file able to completely rebuild the DB, e.g.
useful after a mysql_install_db command.
Ciao,
Stefano
> -Original Message-
>
The mysqld.log file says:
020717 13:05:05 mysqld started
020717 13:05:05 /usr/local/libexec/mysqld: Can't find file:
'./mysql/host.frm' (errno: 13)
020717 13:05:05 mysqld ended
But I do see the host.frm file:
-rw-rw1 root root 8958 Jul 17 13:04
/var/lib/mysql/mysql/host.f
> CREATE TABLE new_table ()
> TYPE=BDB;
> INSERT INTO new_table SELECT * FROM old_table;
> CREATE INDEX ... ON new_table;...
> ALTER TABLE new_table ADD PRIMARY KEY (...);...
> RENAME old_table TO old_table_bak;
> RENAME new_table TO old_table;
>
> That should cause a downtime of less than a seco
DBI is the Perl module used to communicate with the database. The error message is
informing you that you do not have the DBI module installed on your system.
This isn't a mysql-specific problem, so you should probably consult with an actual
Perl help group. At the risk of going off-topic thou
You could use something like :
mysqldump -Q --opt -F --all-databases -h serverName -u root
--password=yourpasswd > /some/where/backup.sql
It generates a SQL commands file able to completely rebuild the DB, e.g.
useful after a mysql_install_db command.
Ciao,
Stefano
> -Original Message
Just a quick question. Why are you not running DBD::Mysql directly? It
should eliminate the ODBC layer and help with speed.
On Thu, 18 Jul 2002, Christopher A. Libby wrote:
> Date: Thu, 18 Jul 2002 08:22:33 -0400
> From: Christopher A. Libby <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subje
You could use something like :
mysqldump -Q --opt -F --all-databases -h serverName -u root
--password=yourpasswd > /some/where/backup.sql
It generates a SQL commands file able to completely rebuild the DB, e.g.
after a mysql_install_db command.
Ciao,
Stefano
> -Original Message-
> Fro
On Thu, 18 Jul 2002, Ilyas Keser wrote:
> Hi all...
>
> I am a new Linux user. Does any one have a shell script to backup all
> Mysql databases?
Read The fine Manual - it gives several ways.
-
Before posting, please check:
mysqldump -opt > everything.sql
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Ilyas Keser [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 18, 2002 8:44 AM
To: [EMAIL PROTECTED]
Subject: shell script to backup
Hi all...
I am a new Linux user. D
Hello!
Pete French wrote:
>If I have amast/salve pair where the slave is replicating from
>the master then do the table types have to be the same ?
>
>Specifically can I have a myisam table on the master and replicate to
>a bdb table on the slave ?
>
>The reasoning behind this is to try and find
Hi,
is it possible to simply update a row from one table with a row from
another table using reference key.
Something like this example query (which is doesn't work)
UPDATE orders_products SET orders_products.status=orders.orders_status
WHERE orders.orders_id=orders_products.orders_id
Hi all,
>I (like almost everyone else) use different character set than latin1.
>I have noticed that the Hungarian sorting does not work properly.
>I have checked he .conf files, and if I see it well, the way of comparing
character fields is very simple. Just comparing he> >characters at the
thanks victoria. now that is cleared up for me.
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 18, 2002 8:41 AM
To: [EMAIL PROTECTED]
Subject: Re: safe_mysqld - my.cnf weird foo
Shon,
Tuesday, July 16, 2002, 10:45:19 PM, you wrote:
SS> i c
Hello Everyone!!
I've just joined this list and have already started to enjoy the
various threads that are running. I also wanted to get some feedback
on something that I'm trying to do.
I have currently developed a survey system that uses a mysql database
that consists of 15 tables. The databas
Also in may NT machine appear the same error. Which is the problem ?
- Original Message -
From: "Ilyas Keser" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 18, 2002 1:58 PM
Subject: backup
> Hi list...
>
> What is the best way to backup a Mysql database? I read in the
On Thu, Jul 18, 2002 at 03:41:01PM +0300, Victoria Reznichenko wrote:
: Archbold,
: Thursday, July 18, 2002, 12:18:09 AM, you wrote:
:
: A> 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
Hi,
mySQL wasnt allowing anyone to write to it, so I deleted some stuff and
mySQL started working again. However, even though I had freed up more than
enough space, the problem repeated itself. When I tried to drop an old
database, mysql hung and I cant even get into mysql anymore. Any ideas on
w
Hi all...
I am a new Linux user. Does any one have a shell script to backup all
Mysql databases?
Thanks
ilyas...
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
can anyone tell me how to make mysql read my.cnf from /usr/local/etc instead
of /etc? i tried configuring with --sysconfdir=/usr/local/etc at compile
time. that is not working.
thanks,
shon
-
Before posting, please check:
htt
Hi all,
If I want to convert an existing Mysql install from non-largefile to support to
largefile support (I rebuilt the software and enabled this), do I need to rebuild my
databases/tables/indexes after I upgrade the software? Or should I be able to just
upgrade the software and use my existi
dou you know that mysql can handle maximum row of records?
thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread
Hi all,
I (like almost everyone else) use different character set than latin1.
I have noticed that the Hungarian sorting does not work properly.
I have checked he .conf files, and if I see it well, the way of comparing
character fields is very simple. Just comparing he characters at the same
po
>Description:
With the current series of MySQL RDBMS (tested with 3.23.49 on Debian
Linux 3.0 running a 2.4.19-pre10 kernel) connecting to a remote
database can be problematic since MySQL doesn't handle very well
situations where the remote database has become unavailable.
To be more precise, is
qingfong,
Thursday, July 18, 2002, 4:49:16 AM, you wrote:
q> mysql:
q> 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
q> 1000 record. help me
Shon,
Tuesday, July 16, 2002, 10:45:19 PM, you wrote:
SS> i configure/make/make install mysql-3.23.51 on sparc solaris using
SS> gcc-2.95.2. i used the configure option --sysconfdir=/usr/local/etc.
SS> i ran the mysql_install_db script, i performed all the chown/chgrp
SS> operations, i copied mys
Simon,
Thursday, July 18, 2002, 1:21:20 PM, you wrote:
>> I am trying to copy data from one table to another using in MySQL
>> INSERT INTO table1
>> SELECT table2
>> statment but I would like to add some fixed values to this and so some
>> thing like.
>> INSERT INTO table1
>> SELECT table2
>> VA
Archbold,
Thursday, July 18, 2002, 12:18:09 AM, you wrote:
A> 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
A> I have a simple set up like the one below:
A> CREATE TABLE mastertable
A
Alexander,
Wednesday, July 17, 2002, 11:32:19 PM, you wrote:
AB> When I want to run two servers with different
AB> configuration. Can I run in the same machine and two
AB> running?
Yes, you can (it's not true for Windows):
http://www.mysql.com/doc/M/u/Multiple_servers.html
http://
Morris,
Wednesday, July 17, 2002, 4:49:50 PM, you wrote:
MF> I still need to get a version of mysql working on
MF> AIX 4. I have been watching the mail list and
MF> have seen nothing about a new release. I recently
MF> looked at the web site and found that the current
MF> download binary release
Erick,
Thursday, July 18, 2002, 10:17:12 AM, you wrote:
>> let us say i have a table:
>>
>>customers
>>idint(10) auto_increment
>>name varchar(20)
>>
>>
>> whenever i do,
>>
>>insert into customers (name) values ('...');
>>
>> it automatically generates the id,
HI all;
I have 3 databases. I want backup all this databases by giving one
command. I use the backup command to backup my databases, it seems to
be the fastest way.
Can I write sql the sql-commands below in a file and execute them by
giving only one command?
use db1
backup table tab1, tab2 ta
yes, write them all to a file and put that file in a directory you have
access too. Then when you want to execute them:
mysql -u user -p < filename
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Ilyas Keser [mailto:[EMAIL PROTECTED]]
Sent: Th
- Original Message -
From: "Christopher A. Libby" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 16, 2002 3:32 PM
Subject: Problems with high-use tables
Hi - I've been using MySQL for a variety of functions with great success
over the last year. However, I recently reb
I am developing a site which shows tv schedules online...
http://www.einfotimes.com I want to add search to it.
Basically i want to know how to full text search through all the tables
in database and i also want the name of table in result along with
fields...is it possible?
Dasmeet
Just fo
If I have amast/salve pair where the slave is replicating from
the master then do the table types have to be the same ?
Specifically can I have a myisam table on the master and replicate to
a bdb table on the slave ?
The reasoning behind this is to try and find a *fast* was to convert
a MYISAM t
have you tried mysqldump?
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Ilyas Keser [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 18, 2002 6:15 AM
To: [EMAIL PROTECTED]
Subject: backup
Hi list...
What is the best way to backup a Mysql databas
1 - 100 of 119 matches
Mail list logo
