RE: Inserting '#' char as part of a field

Hi Are there any other characters with the same problem like #? Thanks -Original Message- From: Robby Tanner [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 1:16 AM To: Stefan Hinz Cc: [EMAIL PROTECTED] Subject: RE: Inserting '#' char as part of a field I solved the issue

replication problems

Hi All I am trying to make a replication for my database. The master and the slave both in version 3.23.41 and i am working on windows 2000. I create user with FILE privilege and I flush all the tables and block write queries. Now I run the query SHOW MASTER STATUS and I get null in all the

two questions in mysql

Hi All, I have mysql 3.23.41 on windows 2000 I have two questions I need to ask. 1) I want bigger value for the max_connections variable. can I define the value in my.ini file? how can I define this variable? 2) I tried to insert into table a string with the char ' and mysql failed to do

replication in mysql

Hi All I am trying to make a replication for my database. The master and the slave both in version 3.23.41 I create user with FILE privilege and I flush all the tables and block write queries. Now I run the query SHOW MASTER STATUS and I get null in all the columns (file, position, Binlog_do_db

RE: database mirroring in mysql

??? And another thing. Before I am doing all this steps, do I need to create the slave database? where do I need to create it? Thanks -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: Monday, February 03, 2003 12:29 AM To: Inbal Ovadia; [EMAIL

database mirroring in mysql

Hi all, Is there a possibility, in MySql, to define a mirror to my database, meaning that I define another database that will be a copy of my database and every operation that I will make on my database, will be done automatically in the second database? Or if I define database that contain only

RE: Recovery in MySql

Hi My tables are of type MYISAM. What exactly REPAIR does? Is this enough? If my database in not consistent is this command will help? Thanks, Inbal -Original Message- From: R. Hannes Niedner [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 10:10 PM To: Inbal Ovadia; MySQL

Recovery in MySql

Hi All, I have MySql on Windows. Today i had an electrical power interruption in the middle of working. The database remain not consistent and i could not continue working with it. Is there any Recovery after crash mechanism in mySql? Thanks, Inbal

mysql - pro or classic?

Hi All how can i know if my mysql is pro or classic? - 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

access denied

Hi all I am working with mysql, in windows, visual c++. I am trying to run this query from c++ program: select * into outfile 'table_name.txt' FIELDS TERMINATED BY '\t' ESCAPED BY '\0' LINES TERMINATED BY '\r' from table_name And i get exception with this error: access is denied for user

index in mysql

Hi all, I have a quation about index: In mysql, if i create table table_name with column loc_name (and another columns), and the col_name has PRIMARY KEY and UNIQUE constraints, Is an index created atoumaticly on this column? Thanks, Inbal

information about the tables in the database

Hi all, There is a way to know if I have table x in my db? Let's say some catalog tables that hold information about the db like tables name etc. and i can do query like select tables from catalogName and get all the tables in the db thanks :) Inbal

mysql and xml

Hi All Is MySQL works with XML? 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 PROTECTED]

more than one query in mysql

Hi all, can I write a few queries in mysql , separate with suppose ; and run them together? if I can, in what version can I do that? thanks, Inbal - Before posting, please check: http://www.mysql.com/manual.php

installation question

Hi After i install mysql, there is a way that i can know on witch drive i installed it on? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

install MySql on drive other than C

Hi all, I read in the manual about building mysql not on c:\ and i found that i need to change the file my.ini my questions are: 1) can i build this file by my self and not with winmysqladmin.exe? 2) it is enough to change this file if i want to put mysql in drive d, or am i need to do another

need help with installation

Hi I am working with Windows NT. I want to install mysql on drive d. Now i need to change the file my.cnf. In the manual they write that i need to put this file in c:\ BUT what if i don't have drive C?? and if now i want to write some program that find out the drive that mysql installed on. how

mysql++

Hi all, i want to know if i can work with mysql++ with both sql server and mySql thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

mysql-3.23.50

Hi all i have mysql-3.23.41 should i install 3.23.50? what are the differences between this versions? thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Running Multiple MySQL Servers on the Same Machine

Hi all, I want to run multiple mySQL servers on my machine. Can i do this on windows 2000 or just on Unix? because the manual talk about Unix. How can i do this on windows? thanks - Before posting, please check:

in and not in

Hi i want to do in mysql query like that: SELECT col_name FROM table1 NOT IN (select col_nmae FROM tablse2) how can i do that? thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual)

limitation in mysql

Hi, Is there any limitation about the number of rows in a table and about the number of tables that i can put in mysql? - Before posting, please check: http://www.mysql.com/manual.php (the manual)

mysql_affected_rows()

Hi I build a batch file that run a few sql queries. I want to know the results (how many rows affected) but it doesn't recognize the method mysql_affected_rows. What should i use to get the results? Thanks - Before posting,