InnoDB: Error: tablespace

Hi list, I have the following error in a MySQL server: 050617 09:16:35 mysqld started InnoDB: Error: tablespace size stored in header is 8660992 pages, but InnoDB: the sum of data file sizes is only 6432768 pages 050617 9:16:40 InnoDB: Started /usr/sbin/mysqld-max: ready for connections And

recovering a 17G dump

Hi list, I have a 17G dump from my DB, any suggestions to recover that dump faster, any variables to tune up?... I don't have an accurate binary backup, so I have to restore it from my 17G text file. I remove the indexes, foreign keys, I will create them after I've recovered all the data. I

RE: MYSQL to XML

Mathias Thanks for your help, I really appreciated it. And I was just wondering if MySQL has another statment (besides show create table) that only displays the foreign key, but I see that only with the show create table MyTable could get this. Greetings From: [EMAIL PROTECTED] To: Mikel

RE: MYSQL to XML

@lists.mysql.com X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2616 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Checked: Checked Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 24 Apr 2005 19:42:26.0285 (UTC) FILETIME=[BE1839D0:01C54905] Hi Mikel, There are a lot

MySQL to XML

Hi list, does it possible for MySQL to generate XML in the followin format: table name=ServiceType column name=idTipoServicio primaryKey=true required=true type=VARCHAR size=10/ column name=nombre required=true type=VARCHAR size=255/ column name=costo required=true type=FLOAT

Master-Slave bin-logs problem

| +-+ Thanks in advanced for your help, an I hope you can help me guys. Mikel _ Platica con tus amigos en linea con T1msn Messenger http://messenger.t1msn.com.mx/ -- MySQL General Mailing List For list archives: http

Re: Handling threads

Yes I can ping my server, the server still alive, I have a monitor that displays all the active connections, the hostname.err file doesn't log new lines, do I have to check out something else?... Thanks in advance Mikel From: Victor Pendleton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED

RE: Handling threads

Yes it is, it shows the threads_created, threads_cached, threads_active, Do I need to check out another variable, Greetings and thanx in advanced From: Victor Pendleton [EMAIL PROTECTED] To: 'Mikel - ' [EMAIL PROTECTED],Victor Pendleton [EMAIL PROTECTED],'[EMAIL PROTECTED] ' [EMAIL PROTECTED

Handling threads

but it lasted 20 hours to displayed me the same error Can't create thread errno (11) the question is, do I have to increment those values or I'll have to increment other variables, or if you know any urls that I could use I really appreciate. Thanks in advanced Greetings Mikel The system features

Re: Too slow recovering mysqldump files

I'll set up those parameters in my.cnf and try again the recovery from the dump file. I'll hope these changes make faster the recovery. Thanks again Heikki, Mikel P.S. Do you recommend the innodb hot backup tool, does it do faster than the other options, or is a combination of both? From

Re: Too slow recovering mysqldump files

Thanks for your fast response, I'll adjust the autocommit parametr, too, and I'll will let you know if this improves the restore of my data base. Greetings Mikel From: Heikki Tuuri [EMAIL PROTECTED] To: Mikel - [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Too slow recovering mysqldump

Re: Too slow recovering mysqldump files

Here we are my options: set-variable = innodb_log_file_size=150M set-variable = innodb_log_buffer_size=8M I follow the example that came here: http://www.mysql.com/doc/en/InnoDB_start.html; Greetings and best regards Mikel From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject

Too slow recovering mysqldump files

Hi list, does anyone know a faster way to recover a mysqldump file cause When I recovered one dump file it took 26 hours ! to finish, I think it's too slow. Thnx in advanced, greetings MySQL server 3.23.58 RedHat 7.3 4GB RAM 2 scsi disk via fiber channel (333GB each) 2 processor Xeon 1.6GHZ

threading limit

2.4.22, and 3.23.55-Max-log. Is This information ok?, or I'm missing something. Greetings Mikel _ MSN. Más Útil Cada Día http://www.msn.es/intmap/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

threading support

2.4.22, and 3.23.55-Max-log. Is This information ok?, or I'm missing something. Greetings Mikel _ Charla con tus amigos en línea mediante MSN Messenger: http://messenger.microsoft.com/es -- MySQL General Mailing List For list

Re: thread problem

I'm using linux, Red Hat 7.3 Linux version 2.4.22, and 3.23.55-Max-log. Is This information ok?, or I'm missing something. Greetings Mikel _ MSN Fotos: la forma más fácil de compartir e imprimir fotos. http://photos.msn.es

thread problem

Hi list, I have the following problem and here is the message that displays the console when I try to connect Warning: Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent Greetings Mikel

Re: thread problem

I'm using linux, Red Hat 7.3 Linux version 2.4.22, and 3.23.55-Max-log. does This information is ok?, or I'm missing something. Greetings From: Jeremy Zawodny [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Mikel - [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: thread problem Date: Fri

thread problem

Hi list, I have the following problem and here is the message that displays the console when I try to connect Warning: Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent Greetings Mikel

Re: TCP/IP Security for Remote Access of MySQL DBs...for newbie

the whole channel issue? cheers, Mikel Rich Fortnum wrote: Hi there. I have a need to reach into a remote database and write to their tables from my tables. Or have them reach into my tables and read from mine. Either way, data will travel over the net. I need that data secure and I don't know how

Re: [PHP-DB] any good web hosting with php and mysql support? (OT)

Starting @ $20.00/month http://www.ocsny.com -- Original Message -- From: Gurhan Ozen [EMAIL PROTECTED] Date: Mon, 14 Jan 2002 13:17:59 -0500 Hi All, I am currently looking for a reliable web host to host my personal website. I know there are

Re: mysqldump - basic question

Rory, Take a look at the shell scripts for mysqlbackup here http://www.ocsny.com/main/index.ocs?url=mysqlbackup It will explain things quite nicely. Cheers, m! ROry O'Connor wrote: this is an absolute newbie question - but when i try to run mysqldump with a cron (like with a shell

Re: Need help with SELECT and JOIN pls

| Silly Apple Comercial | came with the streaming server. | 2 | y | 2.95 | ++-+-+---+--++-+--+ 3 rows in set (0.00 sec) I hope this helps... cheers, Mikel Jaime Teng wrote: Hi, I

Re: ALTER TABLE error

are you sure you don't want to UPDATE Advertisers SET PACK_KEYS=0;? Steve Osborne wrote: Can anyone tell me why I am receiving the following error? I am connecting to a remote server via ssh, and accessed the mysql prompt by typing: mysql The following is the screen contents after

Re: Image's

tryt constructing a URL like file:///images/110101/yourpic.jpg out of the location... [EMAIL PROTECTED] wrote: Either the coffee is flat or someone switched to decafe on me. What is the proper way to retrive an image that is stored as a path in a field name with SQL? My path would be

Re: conceptual question.

Recommend that you store the link/url in lieu of the actual files. cheers, mikel Venu Allavatam wrote: hello all! i have a question regarding the storage of data. The doubt is... Should the data (mostly binary files) be stored in the database as a field or a link(a path) to the data be stored

Re: question

Check your grants table in the mysql db...make sure you have given yourself permission to user said db from the specified host as that user... Wells, Kenneth L wrote: How can I fix this? Database: mysql_error:Host 'localhost.localdomain' is not allowed to connect to This mysql server Fatal

Re: How to make apache webserver on a Linux box connect to a remote mySQLdatabase on a separate Sun box

well for starters you should look into updating your grants table, to allowe the remote server to access the db. Don't forget to properly set the userid, password, and perms for this...Highly encourage to grant this id read only access...but that's your call. Then on the prospective webserver

Re: FreeBSD server help

Kyle, Need a bit more info, what version of mysql? Have you granted the other host(s) permission to use mysql? are you using mysqladmin to stop and start the daemon? cheers, m! Kyle B wrote: Hi all, I am going to try and describe my problem as best as possible. here it goes. Am

Re: Unix Shell Auth from MySQL

checkout pam_mysql under the ports collection in fBSD...;) cheers, Mikel Chris Aitken wrote: Hi, Something ive been thinking about for a while but havent been able to come up with a definitive answer is this... Is there a system out there which can take over from the normal

Re: Expect Script accessing MySQL

I'm not up on expect, but I would assume that since you can use sh then you should ber able to use expect. Generally speaking in sh you can do the following: #!/bin/sh MYSQLCMD=/usr/local/bin./mysql USER=me' HOST=some.host.com PASSWD=whatever QUERY=SELECT userId FROM thisTable WHERE id=1

Re: ACT2 Conversion

Hi guys, Are we talking about Symantec's ACT product? Cheers, Mikel Rolf Hopkins wrote: I've never heard of ACT2 but if you can export the data to a delimited text file, you could import it into mysql. You may have to edit the file a bit though. - Original Message - From

Re: Migration Oracle = MySQL

I'm not sure how this happend but Mikel didn't write that. Could some one kindly forward me the original for the snippet below, including the headers...? Thanks, Mikel Ray Cote wrote: At 4:44 PM -0400 4/26/01, Mikel wrote: I'm trying to create a perl script that just produces a MySQL

Re: Migration Oracle = MySQL

just curious but can't you do a SQL dump of oracle...and if so (since I'm not up on it) whats' the correct syntax, especially from the command line... Cheers, Mikel Johan Andersson wrote: Anybody tried this? and hopefully got some good ideas of how to do it properly? I'm trying to create

Re: Mysql commands from Linux shell

yes absolutely...look into mysqlbackup (http://www.ocsny.com/main/index.ocs?url=osl ) for an example. Cheers, Miekl Fabio Galarraga wrote: Hi to all: I have a linux script and I need it can execute some mysql commands. Is it possible? If possible, how? Best regards, Fabio Galarraga

Re: Run time version of MySQL

a whaping $0. Cheers, Mikel johnd wrote: Hi, We are planning to move on to MySQL. Could you send us your opinions about MtSQL. It will greatly help us to make decision and to use MySQL. Thanks. Regards, John Ding - Before

Re: MySQL performances?

Well what exactly do you consider big? Mohamed Sadok MOUHA wrote: Hi, does any one used MySQL in real environment with big databases and a big number of connections? If yes, what's the hardware config? Thanks --

Re: Once again... quotas...

for the burstable circuits. Cheers, Mikel Tristan 'Minty' Colgate wrote: Hi There, I have recently been asked to implement per database quotas for mysql for a large scale shared webhosting environmnet, from the lists it seems pretty obvious that mysql cant achieve this at the moment (without

Re: taxes

they are in my state. cheers, mikel Mike Wexler wrote: Actually its even more complicated than this. There are city taxes and other taxes on other boundaries. In addition the rules as far as what things are taxable vary by locality. For example, some localities charge taxes on shipping and others

Re: taxes

the core storefront locations...Anyway that's how they do it...not how everyone else does...this make good sense if your host is located in one state...;) ok I think we've veer far enough off course... cheers, mikel Mike Wexler wrote: Mikel King wrote: guys I think you are making this a way

Re: taxes

Wound't you just set a table with an id, state_abrev, tax columns. Then the id column will match the selection...et cettera...capisce LDL Enterprise wrote: does anyone know how to calculateg taxes for a shop cart that would set the tax depending on the state that they select when filling

Re: Shell Shocking

Problem is that most ISPs can't afford a competent DBA...;( clay bond wrote: On Tue, 13 Feb 2001, Donald Korth wrote: The hosting company has given me a user name and passwd . When i log into my own site thro' a telnet session i 'm able to view all the databases created in the server that

Re: Shell Shocking

Absolutely this is nothing short of bad adminingIbet you could scag in their passwd file and has root access in short order...;( And of course the ISP will blame mysql if anything happens to them though...lazy bad ISP cheers, mikel Donald Korth wrote: Hello The hosting company

Re: Port 3306

fwcmd=/sbin/ipfw... on BSD usage like so ${FWCMD} add deny all from any to any via ${oif} Have to make a new kernel to support ipfw though cheers, mikel [EMAIL PROTECTED] wrote: What OS? If Linux or *BSD, they have firewall software (ipchains on linux, don't recall what

Re: GUI for Linux mySQL

Marko, Check out... http://www.freebsd.org/cgi/url.cgi?ports/databases/mysql-navigator/pkg-descr Also there are a few php as wellas python driven utils out there that make it entirely web based Cheers, Mikel Marko Sarunac wrote: Is there a GUI for mySQL that will run on either

Re: Problem for localhost connection.....

did you edit /etc/resolv.conf? dyu wrote: Dear all, i m running mysql on freebsd webserver and using our own DNS server. Everything run fine with database and web serving. However, i m trying to change the DNS ip addresses to our isp's DNS server instead of ours on this webserver. Then

Re: OT - Cron

Ade, Try: http://www.ocsny.com/main/index.ocs?url=osl It should have what you need. Cheers, Mikel [EMAIL PROTECTED] wrote: Hi, I`ve been searching for hours now so I thought I`d ask some lists I belong to, does anyone know of a decent CRON tutorial??? TIA Ade

Re: Changing a Table name

Of course there is... ALTER TABLE name RENAME newname ; Of course you can find this sort of thing in the manual of even on Quetin Smith's SQL reference site... http://comclub.dyndns.org:8081/sqlref/ Cheers, Mikel Don wrote: Hi, Is there a quick and simple way to change the name of a Table

Re: Corrupted tables

to auto discover the databases in your db and print them into straight sql...I have another cron job that runns shortly after that tars the data to tape and then they can be erased from disk... cheers, mikel "Kissandrakis S. George" wrote: Hello I have mysql 3.23.31 on x86 linux Some

Re: Starting MySQL

on the same server you can get away with localhost, however; if not then you must make an entry for each domain... Cheers, Mikel Carlos Corzo wrote: Hello, I bought MySQL by O'reilly. This thing is just as tough to read as the manual but I am trying and utilizing both. When we installed MySQL

Re: Please read the manual

it is important for all of us to help by giving back to our community...;D Cheers, Mikel Neff Patrick K wrote: Maybe it is the lack of coffee this morning talking or maybe it is the fact that I have spent 4 days trying to get mysql up and running on linux(a platform I am unfamiliar with) but I assumes