Re: backup table/restore table question

possible but i find a very severe conflict with mysqldump between what the prod server will understand and what the test server will understand.. example: at the bottom of a create table section of mysqldump you will see the line : /*4 ALTER TABLE! LOCK READ--*/ and of course gives error 10064:

Re: OS X 10.3 install step by step

On 4/12/04 8:50 PM, "Scott Haneda" <[EMAIL PROTECTED]> wrote: > For some reason I get a lot of email from users on Mac OS X that can not > install MySql. I have written a step by step in hopes it will help. I > really did little more than copy the notes on the MySql site, but alas, it > seems so

Re: compiling mysql on a pentium

Walter Andreas wrote: >how to compile mysql 4.0.18 on a pentium for best performance? Check the INSTALL-SOURCE file in your source distribution. I found this: CFLAGS="-O2 -mcpu=pentiumpro" CXX=gcc CXXFLAGS="-O2 -mcpu=pentiumpro -felide-constructors" ./configure --prefix=/usr/local/mysq

Re: Too many server instances

Each one of those is a thread, not a server instance. I assume you're using Linux, since linux shows separate threads as processes. j- k- On Saturday 10 April 2004 06:48 pm, Emmett Bishop said something like: > Howdy all, > > I am having trouble configuring my server parameters > with m

Re: compiling mysql on a pentium

>how to compile mysql 4.0.18 on a pentium for best performance? > Check the INSTALL-SOURCE file in your source distribution. I found this: CFLAGS="-O2 -mcpu=pentiumpro" CXX=gcc CXXFLAGS="-O2 -mcpu=pentiumpro -felide-constructors" ./configure --prefix=/usr/local/mysql --with-mysqld-user=mys

Re: compiling mysql on a pentium

Walter Andreas wrote: Hi there, how to compile mysql 4.0.18 on a pentium for best performance? I searched the net now for 2 days and found lots of hints on compiling with icc and pgcc, but it looks to me that icc is not working with mysql 4.0.18 and pgcc is out of date (maybe gcc already catch

compiling mysql on a pentium

Hi there, how to compile mysql 4.0.18 on a pentium for best performance? I searched the net now for 2 days and found lots of hints on compiling with icc and pgcc, but it looks to me that icc is not working with mysql 4.0.18 and pgcc is out of date (maybe gcc already catched up with pgcc?). Sett

OS X 10.3 install step by step

For some reason I get a lot of email from users on Mac OS X that can not install MySql. I have written a step by step in hopes it will help. I really did little more than copy the notes on the MySql site, but alas, it seems some people are not following those correctly. Hopefully, people can poi

Re: backup table/restore table question

At 20:23 -0400 4/12/04, Andy B wrote: hi... i have a server where there are 5 tables inside a database. i was wondering if i did the following command from inside a script: backup table dbname.tablename to /home/users/my_dir/ then with a different script gzip/tar them, after gzipped ftp them to my

Re: Fulltext index

I find doing this helps to reinitialize the indexes ALTER TABLE shotlist TYPE=MyISAM; REPAIR TABLE shotlist QUICK; > I am trying to add a second fulltext index to an already existing table > (named "articles"). > > The first index is for field(column name) "text" of type "longtext" > > I want to

Re: FBSD 5.2.CURRENT-p4 and mysqld problems

Ken, Thank you very much for reply. I'm having this problem since March 13th, and having big trouble. I compiled mysql with linuxthreads-2.2.3-15. At 04:17 AM 13.04.2004, you wrote: Are you able to run show process list? Sometimes I can't run show processlist. It hangs. What is the status of yo

Fulltext index

I am trying to add a second fulltext index to an already existing table (named "articles"). The first index is for field(column name) "text" of type "longtext" I want to add a second index that will be for this field and field(column name) "title" of type "varchar" I used this query: >alter

Re: How do I determine the row number or key when table has no key fields

Andy Ford wrote: I thought LIMIT limited you to N number of CONCURRENT record. ie. limit 10 or limit 20 I believe Ross would like to select select 1000 records and then do a sub select of records 1-20 and then 21-40 on this record set LIMIT also allows you to specify a starting record, i.e. LIM

backup table/restore table question

hi... i have a server where there are 5 tables inside a database. i was wondering if i did the following command from inside a script: backup table dbname.tablename to /home/users/my_dir/ then with a different script gzip/tar them, after gzipped ftp them to my test server into say c:/db_backup/db_

Re: Get MySQL to ignore the backslashes?

Hi Alex. This question was discussed last week. Search the archives for 'backslash'. The short answer is that there is no global option to do what you want. You'll have to do it in code. On Mon, 2004-04-12 at 17:10, [EMAIL PROTECTED] wrote: > Is there a 'global' way to tell MySQL to not interp

Get MySQL to ignore the backslashes?

Is there a 'global' way to tell MySQL to not interpret the backslashes ('\'s) in the submitted SQL as escape characters? In other words, I'd like for them to always be treated as if they themselves were already escaped with a backslash (i.e. '\\'). I'm using 3.23.52, accessing it with an older

InnoDB and searchs

Hi, We have a FULLTEXT search in our site. The is after we migrate the tables from MyISAM to InnoDB, this search stop working. Looking at the MySQL Documentation (http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html) I´ve seen that it´s support for MyISAM tables online. So, how can I make a se

Process in "waiting for table" state after an ALTER TABLE

Hi, I'm using MySQL 4.0.18-max (same problem with 4.0.18-standard) on one server, and I encounter a strange problem : When I make some change on a table (adding index for exemple), at the end of the ALTER process all the queries that must write on this table switch in the "Waiting for table" stat

Re: Table lock problem on INSERT with FULLTEXT index?

FWIW, I'm still having this problem. I've completely dropped the table and re-built it from the ground up. It's a bizarre problem... The table is totally simple. A primary key, and then three varchar fields. The FULLTEXT index spans the 3 varchar fields. There are only 6500+ rows, so it's p

Re: raid configure option?

In the last episode (Apr 13), Yonah Russ said: > Can anyone explain what the raid configure option does? Is this for > use when storing mysql on hardware raid? if so, what type(s)- ie. > striping, mirroring? It's mainly to support tables over 2gb on old Linux kernels that can't do large files. Yo

raid configure option?

Can anyone explain what the raid configure option does? Is this for use when storing mysql on hardware raid? if so, what type(s)- ie. striping, mirroring? Thanks yonah -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: compiling mysql with intel icc

are you sure that the icc binary is in your path? have you sourced the script in the icc directory which sets the environment variables for you? yonah Walter Andreas wrote: Hi there, I am trying to compile mysql 4.x with intel compiler for maximum performance. On my research I have found that f

Re: How to protect MySQL server from intruders ?

Hi Sam, There are many methods and you should alsways employ more than one. The first is to use the grant system inside of mysql http://dev.mysql.com/doc/mysql/en/GRANT.html If you want no network access at all use --skip-networking Don't listen for TCP/IP connections at all. All interaction wi

Re: Multiple SELECTs in one query

You might consider a whole different approach which is more efficient, because regardless of VB or MySQL - in your current setup you are issueing 3 distinct SQL statements against the same table and you might be able to convert it to only issueing one. Basically, use functions to create 1's or

RE: mysql error file

Michael wrote: >mm... Have you looked in /etc/rc.d/init.d/mysql to see what, exactly, it >oes when you tell it to start? > >Michael I briefly looked in there. This is the same script it uses to start MySQL, and was installed with the rpm of MySQL. I would think it should come with all availabl

Re: Getting mysql to work in Panther

It sounds like you are able to login as a guest, but not as 'root'. Please note that 'root' for MySQL is not the same as root user for the OS, they are totally unrelated. I typically change the account name for MySQL root to 'mysqlroot', so my login would be mysql -u mysqlroot -p. There is no "

How to protect MySQL server from intruders ?

Hello Group I would like to know if there is some thing I can do during the configuration of MySQL server so that I could restrict only one user from accessing the database and all others are restricted from the access of the databas? I mean I do not want anybody else to access the database

Re: FBSD 5.2.CURRENT-p4 and mysqld problems

Are you able to run show process list? What is the status of your query? What date was your freeBSD 5-current built on? Please send output of uname -a, so that we know exactly which version on which date because -current changes every day. Also are you using libmap.conf? If yes, what are it's co

Re: mysql error file

Hmm... Have you looked in /etc/rc.d/init.d/mysql to see what, exactly, it does when you tell it to start? Michael Luc Foisy wrote: Actually, that didn't change anything. Still writing to $HOSTNAME.err -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Monday, Apr

Re: [Q] moving database to server in new timezone

On 12-Apr-2004 Riaan Oberholzer wrote: > I'm, using mysqldump to dump a complete database on a > server in The Netherlands and want to load the > generated SQL onto a server in the USA to make an > exact copy of the database. > > However, I have Timestamp(14) fields that are dumped > as e.g. "200

Re: Problems building readline on Solaris 7

Hi Erek, This seems familiar to me, are use still using Solaris make? If yes, try using GNU (gmake) it looks like a make problem. Hope this helps, Ken - Original Message - From: "Erek Dyskant" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 12, 2004 8:44 AM Subject:

RE: security reason for not using load data infile local?

It depends on the variable. Can you give an example of the variable you are trying to set? As far as the load data infile, I believe it depends on how your database will be accessed. If you have a need for remote administration or are working with geographically separated databases then the ability

Re: security reason for not using load data infile local?

Ginger, can't speak to the log file issue but check out this link for the dynamic server variables: http://dev.mysql.com/doc/mysql/en/Dynamic_System_Variables.html Best O'luck, Tripp --- Ginger Cheng <[EMAIL PROTECTED]> wrote: > Hello, MySQL gurus, > Sometimes the 'local' option of 'load

security reason for not using load data infile local?

Hello, MySQL gurus, Sometimes the 'local' option of 'load data infile' is disabled for security reasons (that is what I got from web). What could be the security problem? I have another question, is there any way to change a variable of mysql server without shutting it down? Thank you for help

Re: compiling mysql with intel icc

Walter Andreas wrote: #define SYSTEM_TYPE "pc-linux" #define VERSION "4.0.18" configure: exit 77 andy ideas? That's singularly sparse; not even a line number. All I can suggest is to find where configure tests for an executable output and see what it's doing. It may be misinterpreting "icc" f

[Q] moving database to server in new timezone

I'm, using mysqldump to dump a complete database on a server in The Netherlands and want to load the generated SQL onto a server in the USA to make an exact copy of the database. However, I have Timestamp(14) fields that are dumped as e.g. "2004101015" local time and is read as local time too

Re: Multiple SELECTs in one query

Aha, that would explain it! I guess my next question would have to be...is the the appropriate list to inquire as to the stability of the current Alpha builds? My app is pretty timid in its use of SQL, mostly SELECTS and a smattering of UPDATES and INSERTS on single tables. But on the other

Re: How can I avoid filesort with BETWEEN and ORDER BY

Donny, Thanks for your answer. I tried your example after adding the necessary index and it works as long as I define a single number not a range (i.e. p_cat.lft = 4). Will keep working on the range part. What I am more interested in is the workarounds that can be made to improve the ORDER BY

RE: mysql error file

Actually, that didn't change anything. Still writing to $HOSTNAME.err -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Monday, April 12, 2004 12:03 PM To: Luc Foisy Cc: Paul DuBois; MYSQL-List (E-mail) Subject: Re: mysql error file Note (see ps output) that you ar

Re: Re[2]: backup

I did get soimething working mysql command setup to lock tables with read lock command.. works very well. Steve Sills Platnum Computers, President http://www.platnum.com [EMAIL PROTECTED] - Original Message - From: "Carsten R. Dreesbach" <[EMAIL PROTECTED]> To: Cc: "Steve Sills" <[EMAIL

RE: Multiple SELECTs in one query

You will need to be using MySQL 4.1.x in order to perform sub-selects. -Original Message- From: Steve Pugh To: [EMAIL PROTECTED] Sent: 4/12/04 11:01 AM Subject: Multiple SELECTs in one query Hello, all! I am porting my Visual Basic app over from MSDE to MySQL, and things so far are goin

Re: Mac Installation

Santino wrote: check the permission of /tmp folder. I think mysql user can not access that dir: I agree. At least a couple of Mac OS X updates improperly restrict permissions on /tmp. chmod 777 /tmp Don't do that. It's not safe. You need the sticky bit set so one user can't clobber another

Re: backup

I use snapback it does the rolling restoration... works awesome it links the files to save space, and had a transfer log, to show how much was transfered Steve Sills Platnum Computers, President http://www.platnum.com [EMAIL PROTECTED] - Original Message - From: "Benjamin Ara

Re: mysql error file

Note (see ps output) that you are using safe_mysqld, rather than mysqld_safe, as you have mysql 3.23.58. Hence, you need to change [mysqld_safe] to [safe_mysqld] in your my.cnf. See . Michael Luc Foisy wrote: I hade it misconfigured (wrong

Multiple SELECTs in one query

Hello, all! I am porting my Visual Basic app over from MSDE to MySQL, and things so far are going quite well. I've found most of the "gotcha" differences in how I need to structure my queries, but I am having trouble with one in particular. In my original code, I could use one query to get a

Problem

Im havin problem running Mysql through DOS. I´m running or trying to, mysql-4.1.1a-alpha-win, I had no problem running this program in my WinXP computer, but in this one with Win98, after typing almost all commands e.g. "mysql -u root" nothing happens after, it doesn´t freeze my pc, nothing happ

RE: Queries per second average

Use caution when modifying your values The following formula should not be greater than your total amount of memory. key_buffer_size + (read_buffer_size + sort_buffer_size) * max_connections ... Also allow memory for the Operating system and other applications that may be running on the same machin

Re: Queries per second average

Awesome. Hope it works out. P Dan Johnson <[EMAIL PROTECTED]> 04/12/2004 02:16 PM To: [EMAIL PROTECTED] cc: Subject:Re: Queries per second average Victor Pendleton wrote: >I agree with Peter, 50 queries per second is not a MySQL limit. Have you >che

Re: Queries per second average

Victor Pendleton wrote: I agree with Peter, 50 queries per second is not a MySQL limit. Have you checked the slow query log or the *.err log file to see if anything is being logged or if `bad-performing` queries are causing this bottleneck? Have you checked your variables to see what your `max-c

Re: Queries per second average

Dan Johnson wrote: The site that I am working on is experiencing MySQL freeze ups any time after the 'Queries per second average'; seen on the STATUS output; is at 48-50 in value. When the site owner asked the hosting service about this they told him that the MySQL cannot go above that limit.

Re: Queries per second average

At 08:16 AM 4/12/2004, you wrote: The site that I am working on is experiencing MySQL freeze ups any time after the 'Queries per second average'; seen on the STATUS output; is at 48-50 in value. When the site owner asked the hosting service about this they told him that the MySQL cannot go above

RE: Reinstall Windows.

You can use mysqldump, then zip up the files. Do not forget to backup your innodb directories if you are using InnoDB tables and grab the my.ini/my.cnf file. Once you have re-installed windows just place the directories/files on the new file system and adjust your my.ini/my.cnf if necessary. Victo

Reinstall Windows.

I need to re-install windows, so I need to re-install mysql. How can I backup my databases so when I reinstall mysql put them to work again?, Thx in advance, Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROT

Reinstall Windows.

I need to re-install windows, so I need to re-install mysql. How can I backup my databases so when I reinstall mysql put them to work again?, Thx in advance, Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROT

RE: Queries per second average

I agree with Peter, 50 queries per second is not a MySQL limit. Have you checked the slow query log or the *.err log file to see if anything is being logged or if `bad-performing` queries are causing this bottleneck? Have you checked your variables to see what your `max-connections` variable is?

Re: install: config root user fails

I have a similar setup at home, and got the same error. See explanations and fixes below. Douglas Dickinson wrote: warning: complete db server newbie! (I've done plenty of SQL & JDBC coding, but never had to care about the server side until now ;-) Installed the binary distribution packages for

Re: Queries per second average

I've done hundreds if not thousands of queries per second... I do not see how the server can be an issue unless it's configuration is bare.. And I don't know how much that should affect it if it's a decent server :-/ If there are configuration constraints, it could be disk that's mussing it up.

Queries per second average

The site that I am working on is experiencing MySQL freeze ups any time after the 'Queries per second average'; seen on the STATUS output; is at 48-50 in value. When the site owner asked the hosting service about this they told him that the MySQL cannot go above that limit. He still has lots of

RE: mysql error file

I hade it misconfigured (wrong param name prior to MySQL 4.0) Doc Quote http://dev.mysql.com/doc/mysql/en/Error_log.html Beginning with MySQL 4.0.10, you can specify where mysqld stores the error log file with the option --log-error[=file_name]. If no file_name value is given, mysqld uses the n

RE: mysql error file

I changed mysql_safe to mysqld_safe and it is still sending the error output to $HOSTNAME.err -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 07, 2004 11:17 AM To: Luc Foisy; MYSQL-List (E-mail) Subject: Re: mysql error file At 10:10 -0400 4/7/04, L

Re: sql-bench - wrong socket error

Hi- ./run-all-tests --socket='/tmp/mysql.sock' from ./run-all-tests --help... Regards, Erek On Mon, Apr 12, 2004 at 02:09:28PM +0200, Walter Andreas wrote: > Hi there, > > I am trying to benchmark a mysql installation. > > After running: > /usr/local/mysql/sql-bench # ./run-all

Problems building readline on Solaris 7

Hi- I have not been able to build readline on Solaris 7. No matter what I change in the configuration, it still gives me the same error. Any ideas would be greatly appreciated. Thank you all in advance for the help. Regards, Erek System Configuration: gcc: 3.3

sql-bench - wrong socket error

Hi there, I am trying to benchmark a mysql installation. After running: /usr/local/mysql/sql-bench # ./run-all-tests it throws the error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Thats ok, since the socket is /tmp/mysql.sock as configured in my.cnf I

Re: syntax error on create

"warwick mayson" <[EMAIL PROTECTED]> wrote: > > I am new to mysql and have a create script that when sourced throws a syntax error. > > The script : > > CREATE TABLE employee ( > id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, > name VARCHAR(255) NOT NULL, > PRIMARY KEY(id) > ) > TYPE=InnoDB; >

Re: upgrade which client?

"Duke, Brian" <[EMAIL PROTECTED]> wrote: > > I needed to do some subqueries. I had mysql-3.23. Somehow I thought > mysql4 included subqueries. Loaded mysql-4.0. Converted everything and > got it working except it doesn't do subqueries. Therefore we installed > mysql-4.1.1 6 hours of figuring out t

Re: Getting mysql to work in Panther

Daniel Lahey <[EMAIL PROTECTED]> wrote: > I have been trying for months to set up mysql on my Mac (Panther) with > no success. I can't run mysqladmin as root. I get an access denied > error message. If I try to use SHELL>mysqladmin -u root password > 'password' I get access denied as either ro

Re: InnoDB weird thing!!

"starofframe" <[EMAIL PROTECTED]> wrote: > Hi, > > I wanna ask about InnoDB... > > I've been trying InnoDB for sometimes and I found out one thing weird that is : > > "When I make an InnoDB tables and filled it with some records ..it took about 2 Mb of > file's capacities.. > but when I delete all

Re: Set Password [SOLVED]

On Mon, Apr 12, 2004 at 11:19:50AM +0100, Russell Horn wrote the following: > > > The man page says > > > > /usr/bin/mysqladmin -u user -p somepassword > > > > Not here it doesn't. My man page says: > > mysqladmin [-#|--debug= logfile] [-f|--force] [-?|--help] >[--character-set

RE: Set Password [SOLVED]

> The man page says > > /usr/bin/mysqladmin -u user -p somepassword > Not here it doesn't. My man page says: mysqladmin [-#|--debug= logfile] [-f|--force] [-?|--help] [--character-sets-dir=directory] [-C|--compress] [-h|--host=[#]] [-p[pwd]] [--password=[pwd]]

Re: Mac Installation

check the permission of /tmp folder. I think mysql user can not access that dir: chmod 777 /tmp Santino At 22:00 + 11-04-2004, Mustafa Hakim wrote: I am trying to install MySql on MAC OS X. After the pkg is installed I am not able to start the MySql server due to the Socket error. ERROR 2002

a problem

I have a webserver on Mandrake9 and Mysql3.23.56,php4.3.x,apache1.3.x is running on it. i wanted to transfer this server another server(FreeBSD4.9) completely. To backup of mysql database i used mysqldump as following; mysqldump -u user -p -all mydatabasename > mydatabasename.backup no pr