Re: help on PHP code

WHERE (nickname = '$nickname') and (password = '$password')", $connection); remember to place quotes around the value nickname = $nickname wont work but nickname = '$nickname' will do Hope that helps Nitin - Original Message - From: "electroteque" <[EMAIL PROTECTED]> To: "Togochog E

Re: WHERE clauses across rows...

Oh. Yeah. Joins. Right. Self Joins. I've done joins, this just didn't occur to me. Thanks for the tip. I'll try it out. j- k- On Friday 27 February 2004 07:55 am, Eric B. wrote: > Not sure how you determine what the order of your rows are, but assuming > you have a column called rown

RE: help on PHP code

well dude u never showed what the parser returned, i am pretty sure u need curly brackets if u are including more than one line in an if statement -Original Message- From: Togochog Enhebatu [mailto:[EMAIL PROTECTED] Sent: Saturday, February 28, 2004 2:53 PM To: [EMAIL PROTECTED] Subject: h

help on PHP code

hi, Can any one help find the bug of the following code for me? I am new in MySQL and PHP, and trying to varify the user ID and password. help is appreciated. batu, http://www.w3.org/TR/html4/loose.dtd";> Customer Details Customer Details $nickname = $HTTP_POST_VARS['nickname

Re: InnoDB, mysqldump/mysql timeout dropping table (disaster recovery)

Hi, This only delays the agony. I have done that (using bzip2), but eventually this will not work. I would rather engineer a solution that "will just work" and will scale properly (given infrastructure support ie: network/disk). Thanks, Steve Williams William R. Mussatto wrote: How about if

Losing indexes after building from dump.

I finally figured out that we had been running large databases without indexes working at all. It turns out that if I use mysqldump to dump out a database, then drop/create the database and build from the dump, none of the indexes work. Things slow to a crawl. I found inadvertantly that by issuin

Re: InnoDB, mysqldump/mysql timeout dropping table (disaster recovery)

well then. perhaps you can add/modify the sshd.conf file, is there a default timout there? that would be my next shot. dan William R. Mussatto wrote: How about if you dumped to a compressor and stored the result? Steve Williams said: Hi, The problem with doing a myqldump to a file (via cron

RE: InnoDB, mysqldump/mysql timeout dropping table (disaster recovery)

How about if you dumped to a compressor and stored the result? Steve Williams said: > Hi, > > The problem with doing a myqldump to a file (via cron) is that at some > point it will hit the filesize limitiations. By streaming it over the > network, that problem is avoided on both ends of the pipe.

Re: Strange bug(?) with Phrase search in BOOLEAN MODE

Hi! On Feb 27, Haitao Jiang wrote: > > Thanks! That was what I guessed. But how to explain > "16-bit Touch" doesn't match records with "32-bit > Touch" in the keywords? It just returned all the > records with "16-bit Touch", i.e. "16-bit" seems does > count. Because the presense of "16-bit" subs

RE: InnoDB, mysqldump/mysql timeout dropping table (disaster recovery)

Hi, The problem with doing a myqldump to a file (via cron) is that at some point it will hit the filesize limitiations. By streaming it over the network, that problem is avoided on both ends of the pipe. The idea of doing the "scp" of the mysql data directory is not a bad one, but would requi

Innodb Hot backup

Egor, If I write a script myself that backup .frm, .ibd and all log files, how good that backup will be? Idea is not to shutdown the server though. Also I am using Innodb tables, and mysqlhotcopy will not for Innodb. Innodb Hot backup tool works, but I would prefer some free tool to do so. W

Re: InnoDB, mysqldump/mysql timeout dropping table (disaster recovery)

perhaps you would get a better response from doing scp... which runs over ssh... or doing the mysqldump in a cron job, so it will already be complete for transport by ssh. I still think scp is the more proper way to go. dan orlic Steve Williams wrote: Hi, We have a (pre-existing) disaster re

InnoDB, mysqldump/mysql timeout dropping table (disaster recovery)

Hi, We have a (pre-existing) disaster recovery/backup script that uses = mysqldump, ssh, mysql to backup an existing database. One of the tables = is rather large (1 Gig or so), and the time that it takes to "DROP = TABLE" on an already loaded recover server causes a timeout. I have = confirmed

Melissa

-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Client mySQL Server/I need help!!

Michael: You are right. I am installing MySQL Client ONLY & do not find mysql_install_db is nowhere found. Now I realize that for a client installation, mysql_install_db is not installed. You have been very kind in responding and helping me with this problem. I need further assistance in setting

RE: Privileging

At 16:40 -0500 2/27/04, Tucker, Gabriel wrote: Paul I am running the query in mysql. Just: select * from table; The other user is doing the same thing. I am not what parameters he is using when he connects, I'll find out. Thanks Gabe Try this: mysql --print-defaults to see what options my

RE: Design Advice?

Ed, Only MySQL 5.0 provides stored procedure functionality: http://www.mysql.com/doc/en/Stored_Procedures.html. If you are not using 5.0 and don't want to switch to 5.0, then using database "view" will also work. This link tells how to create views: http://www.mysql.com/documentation/maxdb/6d/11

Re: My backup scripts and how reliable are they?

on 02/27/2004 09:53 AM, Adam Hardy at [EMAIL PROTECTED] wrote: > On 02/26/2004 09:02 AM Scott Haneda wrote: >> As per the reco of someone on this list, I created a bash script that runs >> once a day to do the following: >> >> # set path to final destination >> location="/Volumes/foo/sql_dumps/"

Re: Client mySQL Server/I need help!!

If you are building from source and have already run `nake install`, then mysql_install_db should exist in the scripts directory inside your source directory and in the bin directory of the mysql install directory (/usr/local/mysql, perhaps). But, following this thread, there appears to be some

Re: Strange bug(?) with Phrase search in BOOLEAN MODE

Thanks! That was what I guessed. But how to explain "16-bit Touch" doesn't match records with "32-bit Touch" in the keywords? It just returned all the records with "16-bit Touch", i.e. "16-bit" seems does count. Thanks again! Haitao --- Michael Stassen <[EMAIL PROTECTED]> wrote: > It's expected

Re: Strange bug(?) with Phrase search in BOOLEAN MODE

It's expected behavior, not a bug. "16-bit Touch" is parsed as "16", "bit" and "touch". The first two are ignored because they are too short. So, this searches for rows with "touch", then selects the ones which contain your phrase. "16-bit" contains no words to search for, so it returns nothi

Strange bug(?) with Phrase search in BOOLEAN MODE

Could anyone explain why match (keywords) against ('"16-bit Touch"' IN BOOLEAN MODE) returns results, but not match (keywords) against ('"16-bit"' IN BOOLEAN MODE)? Is it a known bug? Thanks a lot! Haitao __ Do you Yahoo!? Get better spam protection with Y

COLLATION equivalents

I am running MySQL server 4.0.16 with MyISAM tables an a UTF-8 Default character encoding in the tables. Is it possible to make it so when a user enters a query using American English characters that they will equate to similar European (and other characters). So if they were to type a 'u' fo

Re: wierd error message from mysqld

Brent Bailey wrote: Hello, Im running mysql on a Freebsd 4.9.. In going through my logs this morning I saw this error. I find it odd that mysqd would try to open the /etc/hosts.allow file .. this makes me think that someone issued the command through mysql .with that in mind. 1. Is there

Re: Compatibility question

In the last episode (Feb 27), Rick Robinson said: > Is a statically linked 3.23.x MySQL client compatible with a 4.1.x server? > (Assuming the use of old-passwords). Yes -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysq

Compatibility question

Is a statically linked 3.23.x MySQL client compatible with a 4.1.x server? (Assuming the use of old-passwords). Thanks, R

wierd error message from mysqld

Hello, Im running mysql on a Freebsd 4.9.. In going through my logs this morning I saw this error. I find it odd that mysqd would try to open the /etc/hosts.allow file .. this makes me think that someone issued the command through mysql .with that in mind. 1. Is there a way to get mysqld

Re: Minimum privileges required for mysqldump

GRANT SELECT, LOCK TABLES ON dbname.* TO dump@'%' IDENTIFIED BY 'dump'; mysqldump --opt -udump -pdump -hlocalhost -B dbname --tables table_name worked just fine for me. >> Original Message << On 2/27/04, 1:40:46 PM, Paul DuBois <[EMAIL PROTECTED]> wrote regardin

Re: Can't create a new thread (errno 11)

Christof Egner wrote: Thanks for your answer. I tried it but it still occurs from time to time. Best Regards, Christof Christof: During a lull in activity on your server, try a stress test to see the maximum number of connection you can establish, and maybe even to some activity on the connect

Re: Minimum privileges required for mysqldump

At 11:37 -0800 2/27/04, Jim Shea wrote: At 2/27/2004 10:56 AM, [EMAIL PROTECTED] wrote: Give the use the lock option if you plan on using the --opt. How is that different than > Giving the "lock tables" permission as in: grant select, lock tables on dbname.* to [EMAIL PROTECTED]; results in th

Re: datetime in mysql

CurlyBraces Technologies ( Pvt ) Ltd wrote: hi , i have created datetime field in the field name "abc". so i want to get the system date and time automatically to the abc field for in each records. how can i do that ?can somebody help me ..plz define the column as timestamp --

Re: data types: TEXT, MEDIUMTEXT, LONGTEXT

* Is the procedure to store file paths, or the actual text itself? In order to use MySQL full-text indexing funcionality, you will need to store the actual text, and you need to have a FULLTEXT index on the column. Note that full-text indexing is supported only with MyISAM tables. *

Re: Minimum privileges required for mysqldump

At 2/27/2004 10:56 AM, [EMAIL PROTECTED] wrote: Give the use the lock option if you plan on using the --opt. How is that different than > Giving the "lock tables" permission as in: > grant select, lock tables on dbname.* to [EMAIL PROTECTED]; > results in the same mysqldump error. in the previous

Using mod_auth_mysql with Apache 2

Hello all! I know this isn't an Apache list but I already checked the documentation on Apache.org on trying to get this configured correctly. I have a question about mod_auth_mysql. I installed the rpms for Apache(2.x) and Mysql and I can see the module is in the /etc/httpd/modules dirctory: mod

RE: Client mySQL Server/I need help!!

Evelyn: I need help. I have followed your instructions. Here is my problem: . Installation ... ... Shell> Make Install Shell> scripts/mysql_install_db bash: scripts/mysql_install_db: No such file or directory -- Am I following the correct sequence? There is no directory "scripts"!

Re: Privileging

At 10:55 -0500 2/27/04, Tucker, Gabriel wrote: Hello I have a user that is granted all privileges for their database. When they run a select * on a table in that database, the request fails after about 1000 records. When I run the same query as root, I have no problems. Consequently, I believ

Re: unique values across more than one column

Anand Buddhdev wrote: On Fri, Feb 27, 2004 at 12:58:14PM +0200, Egor Egorov wrote: I'm using mysql version 3.23.58, on Fedora core 1 (the default supplied on the system). I have searched the mailing list archives, and google, for my query, but have not yet found an answer. Does anyone know if it

RE: Privileging

Can you do a show grants for [EMAIL PROTECTED] for both users and see if there is a glaring difference in permissions? >> Original Message << On 2/27/04, 12:33:56 PM, "Tucker," Gabriel <[EMAIL PROTECTED]> wrote regarding RE: Privileging: > Yes - the same machin

Re: Minimum privileges required for mysqldump

Give the use the lock option if you plan on using the --opt. >> Original Message << On 2/27/04, 12:02:34 PM, Jim Shea <[EMAIL PROTECTED]> wrote regarding Re: Minimum privileges required for mysqldump: > >On 2/27/04, 10:12:56 AM, Jim Shea <[EMAIL PROTECTED]> wrot

RE: Privileging

Yes - the same machine... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 11:03 AM To: Tucker, Gabriel Cc: [EMAIL PROTECTED] Subject: Re: Privileging Are you running this test from the same machine for both users? >> O

Re: Minimum privileges required for mysqldump

On 2/27/04, 10:12:56 AM, Jim Shea <[EMAIL PROTECTED]> wrote regarding Minimum privileges required for mysqldump: > I want to create a user that has the minimum rights to dump a database. I > can't find a discussion of the minimum required rights in the MySQL docs. At 2/27/2004 08:35 AM, [EMAIL PRO

Re: My backup scripts and how reliable are they?

On 02/26/2004 09:02 AM Scott Haneda wrote: As per the reco of someone on this list, I created a bash script that runs once a day to do the following: # set path to final destination location="/Volumes/foo/sql_dumps/" # set db_list to the list of databases db_list=`echo "show databases" | /usr/local

Re: WHERE clauses across rows...

Joshua J. Kugler wrote: 1) This is mostly an SQL question, although MySQL may have some trick up its sleeve that would help me. 2) I've searched the archives, and google 3) I've been using SQL for a long time, but can't think of a way to solve this 4) This may not be possible. :) I am dealing wit

Re: WHERE clauses across rows...

If you use php to access your data through web pages you can move the pointer in the query results around. I've got some code I could show you if it would be helpful. Email me off list. bob At 10:55 AM 2/27/2004, Eric B. wrote: Not sure how you determine what the order of your rows are, but

Re: A question about mysql database backup.

On 02/25/2004 09:13 AM Frederic Wenzel wrote: Now I am assigned to do the backup of a whole mysql database (version: 3.23.36). I want to make sure whether the following procedures are correct for database backup. 1. mysqldump -F --opt database_name > database_name.backup In my opinion, you shou

Re: Two indexing questions

Marc Slemko wrote: On Thu, 26 Feb 2004, Keith Thompson wrote: Given these two tables: create table t1 ( id int unsigned auto_increment, a int, ... [other fields] primary key (id), index aid (a,id) ) type=innodb; create table t2 ( id int unsigned,

Re: spatial problems in mySQL

At 18:23 +0100 2/27/04, Jochem van Dieten wrote: Saurabh Data wrote: I am doing research on spatial data and how it can be used in open source systems like mySQL. Can someone give me some outline of problems in handling spatial data in mySQL. If you are specifically looking for problems you might

Re: spatial problems in mySQL

Saurabh Data wrote: I am doing research on spatial data and how it can be used in open source systems like mySQL. Can someone give me some outline of problems in handling spatial data in mySQL. If you are specifically looking for problems you might find the following interesting: http://postgis.r

Re: WHERE clauses across rows...

Not sure how you determine what the order of your rows are, but assuming you have a column called rownumber, or soemthing to that extent, which is a sequential numbering of the rows in your table, you can probably do it with a join on itself. You might have to play with the join syntax a little (i

Re: spatial data in mysql

At 15:25 + 2/27/04, Saurabh Data wrote: Dear newsgroup readers, I am doing research on spatial data and how it can be used in open source systems like mySQL. Can someone give me some outline of problems in handling spatial data in mySQL. Many THanks Saurabh Probably the best place to start

spatial data in mysql

Dear newsgroup readers, I am doing research on spatial data and how it can be used in open source systems like mySQL. Can someone give me some outline of problems in handling spatial data in mySQL. Many THanks Saurabh ___ Saur

data types: TEXT, MEDIUMTEXT, LONGTEXT

I see the data types TEXT MEDIUMTEXT LONGTEXT listed in the MySQL documentation, and I have read Section 13.7 MySQL Full-Text Search. I infer from this that it is possible to store searchable text files in tables. My questions are these: * Is the procedure to store file

RE: problem with 4.0.18

well, I've reinstall from pkg. My sys: openbsd 3.3 Mysql: 4.0.18 When I try to start the server: mysqld_safe --user=_mysqld & I receive that: observe# mysqld_safe --user=_mysql & [1] 6694 observe# Abort Abort Starting mysqld daemon with databases from /var/mysql 040227 17:38:56 mysqld ended

spatial problems in mySQL

Dear newsgroup readers, I am doing research on spatial data and how it can be used in open source systems like mySQL. Can someone give me some outline of problems in handling spatial data in mySQL. Many THanks Saurabh _ Tired o

Re: Minimum privileges required for mysqldump

The user will need SELECT access to the table(s) in question. >> Original Message << On 2/27/04, 10:12:56 AM, Jim Shea <[EMAIL PROTECTED]> wrote regarding Minimum privileges required for mysqldump: > I want to create a user that has the minimum rights to dump a

is XA Driver available

Hi, Does MySQL support distributed transaction using weblogic app server? If yes, please let me know from where should I download the XA driver? It is urgent, please reply as soon as possible. Regards, Elsan. __ Do you Yahoo!? Get better spam protection with Yaho

Minimum privileges required for mysqldump

I want to create a user that has the minimum rights to dump a database. I can't find a discussion of the minimum required rights in the MySQL docs. Included in my searching was: 5.4.3 Privileges Provided by MySQL and 8.7 mysqldump, Dumping T

Feature request related to COMPRESS and UNCOMPRESS functions

To whom it may concern at Mysql AB: I see from the Mysql 4.1.1 CHANGELOG that new COMPRESS(), UNCOMPRESS(), and UNCOMPRESSED_LENGTH() functions were added. That is great news, and something I have been very interested in for a long time, as evidenced by this mysql mailing list thread, dating back

Re: Privileging

Are you running this test from the same machine for both users? >> Original Message << On 2/27/04, 9:55:03 AM, "Tucker," Gabriel <[EMAIL PROTECTED]> wrote regarding Privileging: > Hello > I have a user that is granted all privileges for their database. When t

Privileging

Hello I have a user that is granted all privileges for their database. When they run a select * on a table in that database, the request fails after about 1000 records. When I run the same query as root, I have no problems. Consequently, I believe this is a permissioning problem. Since I ha

Re: lower_case_table_names, Mac OSX, InnoDB and 4.0.18

Bruce, I have now filed bug report 2994 about this. Regards, Heikki List:MySQL General Discussion« Previous MessageNext Message » From:Bruce DembeckiDate:February 27 2004 2:01pm Subject:lower_case_table_names, Mac OSX, InnoDB and 4.0.18 There seems to be some issues we are

07006 error

I've been getting a 07006 error when attempting to store a variable types as a double into a table with the c# .net ODBC components using the MySql ODBC driver. I place the value into the record via a variable also typed as a double with the following code: dbrow["doublevar"] = doubleval; The

Can MySQL give different column different weight when compute

I want to give some columns of my table more weight when it comes to compute the relevancy score. For example, if a word appears in "Title" column, it should weight more if it appears in "Body" column. Does MySQL support this? Thanks for your help! Haitao Jiang

Re: select query help needed

Daniel, >I have a database with the following (simplified) structure: >[Products] >ProductID >ProductName >[PurchaseRecords] >ProductID >CustomerID > >I need to find all of the rows in the table Products which do not have >at least one corresponding row in PurchaseRecords. How do I transla

select query help needed

Hello All, I have a database with the following (simplified) structure: [Products] ProductID ProductName [PurchaseRecords] ProductID CustomerID I need to find all of the rows in the table Products which do not have at least one corresponding row in PurchaseRecords. How do I translate this

Re: API C

Hi Volnei, Under Linux you do not need the -lsocket. (If I recall correctly that is for SUN Solaris but I might be wrong) As for your run-time error, the DLL libmysqlclient.so is not in the library path. Either modify /etc/ld.so.conf to include where is that library (it seems to be /usr/loca

Re: join assistance

* Michael Collins > Using the latest MySQL 4. > > I could use some help on performing a join but not retrieving all the > records of the child table. I have a set of tables, the ones involved > in this are related as follows: > > members (one) -< (many) orders (one) -< (many) orderitems > > The end

Re: API C

Hi Galbino is the MySQL-client and MySQL-devel package instaled Regards Luiz www.xharbour.com.br -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

API C

Hello, I made a compilation test, to see how it works, and already the first beginner problems came. #include #include #include int main(int argc, char *argv[]){ MYSQL_RES *result; MYSQL_ROW row; MYSQL *connection, mysql; int state; /* Conectando com MySQL */ printf("Iniciand

lower_case_table_names, Mac OSX, InnoDB and 4.0.18

There seems to be some issues we are experiencing with this new lower_case_table_names variable introduced in 4.0.17 and modified in 4.0.18. So much so that I can't upgrade to 4.0.18 at all. Here is the startup log from a 4.0.18 mysqld: 040227 02:00:22 mysqld started 040227 2:00:22 Warning: Se

Re: unique values across more than one column

On Fri, Feb 27, 2004 at 01:54:13PM +0200, Egor Egorov wrote: > > Ok, thanks for the response. > > > > The problem with first doing a select, and then an insert, is that > > there exists a race condition. Between the select and insert, someone > > else could insert a row which might cause a duplic

Re: unique values across more than one column

Anand Buddhdev <[EMAIL PROTECTED]> wrote on 27/02/2004 11:26:41: > The problem with first doing a select, and then an insert, is that > there exists a race condition. Between the select and insert, someone > else could insert a row which might cause a duplication. > > I have another soluti

Re: Can't create a new thread (errno 11)

Thanks for your answer. I tried it but it still occurs from time to time. Best Regards, Christof -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Can't create a new thread (errno 11)

Hi Ken, Sorry for my late answer, the problems occur under debian linux 3.0 with custom 2.4.20 kernel. There's no sysctl value set. Best Regards, Christof -- ___ Configo Systems GmbH - Jahnstr. 62 - 64285 Darmstadt - DE Tel +49.6151.3

Re: unique values across more than one column

Anand Buddhdev <[EMAIL PROTECTED]> wrote: > On Fri, Feb 27, 2004 at 12:58:14PM +0200, Egor Egorov wrote: > >> > I'm using mysql version 3.23.58, on Fedora core 1 (the default >> > supplied on the system). >> > >> > I have searched the mailing list archives, and google, for my query, >> > but have

Re: unique values across more than one column

On Fri, Feb 27, 2004 at 12:58:14PM +0200, Egor Egorov wrote: > > I'm using mysql version 3.23.58, on Fedora core 1 (the default > > supplied on the system). > > > > I have searched the mailing list archives, and google, for my query, > > but have not yet found an answer. > > > > Does anyone know

Re: unique values across more than one column

Anand Buddhdev <[EMAIL PROTECTED]> wrote: > > I'm using mysql version 3.23.58, on Fedora core 1 (the default > supplied on the system). > > I have searched the mailing list archives, and google, for my query, > but have not yet found an answer. > > Does anyone know if it's possible to define 2 c

Re: Can't connect

"Andrea Beyreuther" <[EMAIL PROTECTED]> wrote: > I have the following problem: > > I can't connect to the mysql server. I always get error messages (access denied). > > I installed it on Windows XP Professional. > > The mysql server is running as service. A web server is running as service too (IIS

Re: fulltext search always returns no results

"Don Dikunetsis" <[EMAIL PROTECTED]> wrote: > > Hi, > > The comments in the fulltext doc page > (http://www.mysql.com/doc/en/Fulltext_Search.html) discuss the issues of > stopwords and over 50% hits, so I did my best to avoid those particular > bombs in my searches. > > The "subject" column c

Re: Full-Text Search on MERGE Tables

"Lorderon" <[EMAIL PROTECTED]> wrote: > > Is it possible to define MERGE table on several tables with full-text > indexes? Yes, but without specification of FULLTEXT index in the MERGE table. > And to make a select on the MERGE table with MATCH AGAINST? > You can permorm boolean full-text sear

unique values across more than one column

Hi everyone, I'm using mysql version 3.23.58, on Fedora core 1 (the default supplied on the system). I have searched the mailing list archives, and google, for my query, but have not yet found an answer. Does anyone know if it's possible to define 2 columns in a table, with a constraint that wil

Can't connect

Hello, I have the following problem: I can't connect to the mysql server. I always get error messages (access denied). I installed it on Windows XP Professional. The mysql server is running as service. A web server is running as service too (IIS V5.1). The my.ini (e:\windows\my.ini) contains:

Re: A question about mysql database backup.

on 02/27/2004 12:11 AM, Li, Lenny Yong Bo (Lenny) at [EMAIL PROTECTED] wrote: > > 1. database backup. > This is done on the standby one with the following command. > mysqldump --opt --quote-names --flush-logs database_name > database.backup How does this operations handle binary fields, password

Re: Import Access DB into MySQL

Hi, > I need to do this behind the scenes. The user will need to press a > button for the .mdb file to be imported. I can't use a thrid party > program for this. Then write your own. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Serve

RE: A question about mysql database backup.

Fred, Jim, Thank you very much for your kind help! I still have other questions about the MySQL operation. If a service host is redundant, one is in active status, the other is standby. I want to make the following operation . 1. database backup. This is done on the standby one with the foll