MySQL Database Forum

Hi guys, I need your help with this: I have two big databases in two different servers, each database it's different too and I need to replicate each one to a single mysql slave server. I need this: MasterA ---> SlaveC <-- MasterB

------=_NextPart_000_000C_01C35243.DD5E5820 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I read at MysQl.com about Explain SELECT, it says at then end of a = paragraph to optimize your query, using filesort or temporary, but I = went to MySQL search engine no luck on finding them, can...

Thanks... Say you have a double opt in mailing list, of which the subcriber list is store in the db. Im still somewhat of a newb, so bear with me... are there any pros/cons as to keeping the 'unverified' subscribers in a different table, aside from organization? I did just that, where, when they subscribe, they are put in a temp table,...

I was hoping someone could tell me a way to increase the productivity of a database server. It has nothing else installed other than the newest production version of mysql and the default packages from FreeBSD. Is there a toaster than can bring me up to speed. Thanks. --

------=_NextPart_000_0001_01C35286.10843160 Content-Type: multipart/alternative; boundary="----=_NextPart_001_0002_01C35286.10843160" ------=_NextPart_001_0002_01C35286.10843160 Content-Type: text/plain; charset="big5" Content-Transfer-Encoding: base64

------=_NextPart_000_0057_01C35233.C0403930 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hello, I have been using Snitz forums on windows 2000 IIS5 and MySQL for the DB. I have set up a test Microsoft Server 2003 IIS6, but I am having problems with the setup. It is able to connect to the database and the...

Hi all, I have the following two tables: mysql> SELECT * FROM clients; +-----+-----------------------------+ | cid | cname | +-----+-----------------------------+ | 101 | JV Real Estate | | 102 | ABC Talent Agency |

Hi all, I have the following two tables: mysql> SELECT * FROM clients; +-----+-----------------------------+ | cid | cname | +-----+-----------------------------+ | 101 | JV Real Estate | | 102 | ABC Talent Agency |

hi , I installed MySQL-server-4.0.14-0.i386.rpm MySQL-client-4.0.14-0.i386.rpm when I give mysqladmin -u root it is asking for password . The doc says that initially the password is empty and we just need to press enter . I read the mailing list posting but didnt find any clue i didnt set any password . mysql

hi , I installed MySQL-server-4.0.14-0.i386.rpm MySQL-client-4.0.14-0.i386.rpm when I give mysqladmin -u root it is asking for password . The doc says that initially the password is empty and we just need to press enter . I read the mailing list posting but didnt find any clue i didnt set any password . mysql

I used mysql_real_escape_string() method to insert image file into database. Now how do icheck whether it got stored in proper format ?? I used SELECT * INTO OUTFILE F1 FROM IMGTABLE; command , but i'm not able to see the image back in F1. How do i retrieve the image in proper format??

------_=_NextPart_001_01C35278.EC37A6F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All, Just a quick question on whether I need both fields to be indexed. The table is as below.. I'm wondering if I need to have these 2 fields =

I am using MySQL 4.013 (Win2000 Prof). How to set innodb_fast_shutdown to OFF in My.ini ? I have try to set it OFF but it didn't change ( I check it using Show Status Variables). Thanks.

I am using MySQL 4.013 (Win2000 Prof). How to set innodb_fast_shutdown to OFF in My.ini ? I have try to set it OFF but it didn't change ( I check it using Show Status Variables). Thanks.

After 60~120 secs the replication stopped.=20 Setting the parameter Connect-rety to 30 secs doesn't change the situation: the slave lose the connection and the replication is stopped. Massi -----Messaggio originale----- Da: Egor Egorov =20

After 60~120 secs the replication stopped.=20 Setting the parameter Connect-rety to 30 secs doesn't change the situation: the slave lose the connection and the replication is stopped. Massi -----Messaggio originale----- Da: Egor Egorov =20

Hi again, I know that "Show Column" query shows the name of all variables with their characteristics. I want to know if there is a command that ONLY shows the name of the varibales of a column (without characteristics). Thanks a lot.

Hi, Has anyone got an Alpha VMS 7.1 system accessing a Unix MySQL database system ? In other words a MySQL VMS 7.1 client. Ive seen the MySQL client for VMS 7.2 (mysql-3,22,25-clients-vms), but this wont work on 7.1 systems. (Conflicting library versions) And without the source there is no option of porting it.

Ver 3.23 on RH Linux. We came in this morning and were greeted by our DB server rejecting connections to the db from our application. There seems to be a high number of Aborted_clients. How can we tell what clients/connections are causing this? mysql> show status; +--------------------------+------------+ | Variable_name |...

Ver 3.23 on RH Linux. We came in this morning and were greeted by our DB server rejecting connections to the db from our application. There seems to be a high number of Aborted_clients. How can we tell what clients/connections are causing this? mysql> show status; +--------------------------+------------+ | Variable_name |...

I cannot seem to find this in the MYSQL Reference. Are there other places = I should check? The message text in my log started out with 'You have...'. = But, it was truncated and I could not see the rest. It occurred on a = submitted insert statement originating in an application. The insert = statement works ok directly on the MySQL server....

A couple of years ago a guy posted his tool in this newsgroup which was able to import access databases into oracle, mysql,etc. Does anybody still know how the tools name was? Thanks Carsten

<html> <head> </head> <body bgcolor="#0000FF" text="yellow" link="#CCCCCC" vlink="#CCCCCC" alink="#CCCCCC" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"> <table width="100%" border="0" align="center" cellpadding="0" cellspacing="1">

<html> <head> </head> <body bgcolor="#0000FF" text="yellow" link="#CCCCCC" vlink="#CCCCCC" alink="#CCCCCC" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"> <table width="100%" border="0" align="center" cellpadding="0" cellspacing="1">

Hello to all! Here's a MySQL-Problem for all you experts. Please help a non-expert: I've got several tables for a bank-customer-system, e. g. one with all the customer data (address etc.). And I've got two tables with nearly the same structure. Let's say: