Re: mysqldump of one table?

hi i want to dump the contents of one table into a text file ... can you tell me what i've done wrong ? i tried : mysqldump --opt --tables studenttable myfile.txt mysqldump --opt --databases [studenttable] myfile.txt mysqldump --opt database [studenttable] myfile.txt but all

MySql - Ultradev

Subject: MySql - Ultradev From: David Raza Date: Wed, 13 Dec 2000 15:55:48 - I was wondering if anyone has managed to use Dreamweaver

Re: Number of Tables..?

What is the largest number of table per database does MySQL support? http://www.bitbybit.dk/mysqlfaq/faq.html#ch9_4_0 / Carsten Carsten H. Pedersen Keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq

mysqldump core dumping mysql

Hi! I'm having core dumps in mysql 3.23.28 ( BSD 4.2 ) during mysqldump. I've tried different options, now I'm currently running: mysqldump -F -l -q -O max_allowed_packet=16777216 db but sometimes mysql core dumps. Thanks for any idea!

MySQL CAPI and Multiple connections

Hi, I'm building a C API MySQL client. I need to connect to different dbs at the same time. My code is (approximately): // MYSQL mysql, *conn1, *conn2; mysql_init(mysql) conn1 = mysql_real_connect(mysq, ip1, user1, pass1, db1, 0, NULL, 0) printf("conn1 = %d",

Re: choose a free databse management

There are mnay free RDBMS around besides MySQL This includes: Postgresql mSQL (mini SQL) Oracle 8i is free for Linux The learning curve from any RDBMS eg: from Postgresql to MySQL or Oracle to MySQL because they are ANSI SQL compliant. On Fri, 12 Jan 2001, you wrote: Hi everybody, I

Re: MySQL C API multiple connections

Valerio Ferrucci writes: Hi, I'm building a MySQL C API client. I need to connect to different dbs at the same time. My code is (approximately): // MYSQL mysql, *conn1, *conn2; mysql_init(mysql) conn1 = mysql_real_connect(mysq, ip1, user1,

Re: mysql-3.23.30-gamma Compile Problem

I have a problem , I install mysql and i have a mistake : install_driver(mysql) failed: Can't load '/usr/local/lib/perl5/site_perl/5.005/s un4-solaris/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /usr/local/ bin/perl: fatal: relocation error: file

Re: query much slower when function used...?

okay, with gdb i can see that this column becomes a blob (thereby not allowing heap tables to be used - which has got to be costing me speed), is there any function i can use to 'cast' this column to a fixed length? hrm, apparently LEFT(SUBSTRING(MAX(CONCAT())), N) will do that for

Re: index corruption and mysqld crash

Thank you for your help but there is no cron job that kills the process. I also got an answer that was not CC'd to the list that suggested me to install 3.23. I have installed 3.23 (mysqld Ver 3.23.30-gamma for pc-linux-gnu on i686) today since I had a lot of users complaining and could not

Pre-installed MySQL from Redhat 7.0

Fellow travelers, I'm a MySQL debutant. I have no experience with it (other than not being able to get it to work on my Dell PowerEdge 1400 server running RedHat Linux 7.0). Is the RedHat Linux 7.0 distribution of MySQL a satisfactory or difficult one to use. Is it a good idea to buy a

Off list request for a mySQL solution

Hello, Jonas Norrman at mysql.com suggested that I write directly to this list with my request... I would appreciate if any responses would be sent directly to me at: [EMAIL PROTECTED] --- original message --- We are currently evaluating a hotel management software package which runs on

AW: Perl question

Well, this is a little off topic - but: - name your perl program to nph-yourname.pl (this will allow the non parse output) Start your perl-Script with: #!/usr/bin/perl $|=1; print "HTTP/1.0 200 OK\nServer: CERN/3.0\n"; print "Content-type:

Re: Locking records

MySQL doesn't have built in row-level locking, but they are chaning that. The best thing to do, for now, is to have a record_locked column, and set it to 1 if the record is in use. To lock the record, you would run a query like update table_name set record_locked = 1 where id = ??? and

Re: third time asking help concerning charsets

Sometimes when people aren't answering a question, it isn't because they are ignoring you or consider your questions stupid. Sometimes it's because we don't know the answer. Your question has nothing to do with MySQL and everything to do with php. It doesn't like that charset. I have no clue

Re: I need to tell MySQL that i have other database

Did you use mysqldump to save your databases? It is *highly* recommended that you do that instead of just copying the database files over. This way, you can just dump all the data back in and mysql will take care of everything :) If not, you can tell mysqld where to look for its databases:

Re: RedHat 7 and MySQL - Can't start server

I would suggest checking your errorlogs. They should be in your datadir. tail datadir/hostname.err that should tell you what the problem is. If you can't figure out how to fix it, you might want to copy and paste the last couple of lines from your logs in your email. Atle On Fri, 12 Jan

RE: Installation problem.

At 09:08 12/01/2001 -0500, Jenny Lie wrote: Hi! I did reboot the machine and it still can't do mysqld-nt --install. Anything I should do? The first step, I did run setup.exe, then in c:\mysql\bin, I ran mysqld-nt --install, was that right? That is correct. What is your OS ? Regards, Miguel

RE: Installation problem.

At 09:08 12/01/2001 -0500, Jenny Lie wrote: Hi! I forget to say you in the last mails that you need to do the login in the NT/W2k machine as Administrator privilege or with an user which has the privilege to install services in the machine. Regards, Miguel I did reboot the machine and it

RE: Installation problem.

Hi, Thanks! I did log in as Administrator. I'm running Windows NT Server 4.0 Jenny Lie Web Developer Onramp Network Services Inc. 200 Town Centre Blvd, #302 Markham, ON L3R 8G5 (905) 470-4064 EXT 241 E-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.onramp.ca -Original

Help with an SQL statement

Thanks for everyone's help with the dat question now I would like to know if someone could help me with another question. I have a table called COUNTER and a field in the table called HITS in an SQL statement I would like to update this field by adding 1 to it's current value any ideas? Thanks,

Re: MySQL Performance...

"Patrick FICHE" [EMAIL PROTECTED] writes: I just wanted to know if my assertions are rigth and what are the common way to solve this type of problems ? Store your results into a temporary table? -- Dave Hodgkinson, http://www.hodgkinson.org Editor-in-chief, The

Re: Index ? Key ?

Martin Thoma wrote: Hello ! I'm a database-newbee. What I need is a column that makes the record unique. The content should be generated autoamtically and it should be able to get a lot of records (BIGINT would be nice). But I don't know if I should use PRIMERY KEY, KEY, INDEX or UNIQUE.

problems when accessing from several clients

Hi all, When I access MySQL from several API clients, one of them quits with the error message: Query failed (Lost connection to MySQL server during query) Does any one know why?

Help with a semi-complex query

I'm simplifying slightly, here's the basic tables: build --- idx int namechar(16) test_name idx int namechar(64) main_table idx int unsigned test_name_idx medint status char build int swipchar(11) I want to do the

Re: 3.23.28-gamma Crash and data loss

We have replicated this crash over and over just now... Very strange. Yet with the 2.23.30 version, we dont lose the data and dont seem to get corruption. Here is exactly what happened... (This also crashed it in the first place, which lost all our data in the 2.23.28 version) We have a table

mysql-3.23.30-gamma Compile Problem

Hi All. I'm trying to compile mysql on a intel SMP machine and I get the following error. I'm using redhat 7 any ideas? c++ -O3 -DDBUG_OFF -fno-implicit-templates -rdynamic -o .libs/mysql mysql.o readline.o sql_string.o completion_hash.o ../readline/libreadline.a -lncurses

Re: Perl question

Try http-push Eric Fitzgerald wrote: Beyond the other suggestion, also remember to flush your STDOUT. flush(STDOUT); - Original Message - From: "Ron Beck" [EMAIL PROTECTED] To: "Mysql" [EMAIL PROTECTED] Sent: Friday, January 12, 2001 8:56 AM Subject: Perl question Hello

Mysql and NAS?

I've done quite a bit of searching but I've not run across any experiences with multiple Mysql servers running on separate computers using the same data files off a NAS server. Anyone? - Before posting, please check:

Re: Perl question

perldoc CGI::Push ;-) "Aaron E. Schlesinger" wrote: E-mail me the code. Its late and I'm grumpy. I'll e-mail you back the answer tommorow :) Aaron -Original Message- From: Colin Faber [mailto:[EMAIL PROTECTED]] Sent: Friday, January 12, 2001 20:28 To: Eric Fitzgerald Cc: Ron

Table full error ( I Know its in the manual.. I just don't get it)

Ok I get a table is full error... So how/where do I set the tmp_table_size ? or the BIG_TABLES option so that its started that way at system start-up? from what I gather the Big_Tables option writes ALL tmp tables to disk, is that correct? so I should use tmp_table_size instead (got 512 MB

need advice about security

Hi everyone, I use a MySQL database for the back end of our e-commerce site. We take credit as one method of payment and the last 8 digits of the card number are stored in the database. There is a web interface to the database from which I can get order information, but not the card number. I