Re: No Data on table

Hi Christian, Thanks for the reply. I got the table repaired and deleted some data on it. What combination can i use to overcome the 4GB limit? TIA Regards, Nhadie Christian Hammers wrote: Hello On 2007-02-18 Nhadie wrote: I had an error that my database is already full, when i do a sel

Re: Real BITs which use 1 bit in 5.1?

Kevin Burton wrote: A little birdie: http://forge.mysql.com/wiki/Top10SQLPerformanceTips notes.. "In 5.1 BOOL/BIT NOT NULL type is 1 bit, in previous versions it's 1 byte." Is this true? Hmm, I had wondered about that when someone yelled it out at MySQL Camp... No, it's not true. The

Re: mysqlimport problem with , inside fields

Hey Scott - I dont think you can use , with mysqlimport as a field separator if it is part of the data. use something else - I used the pipe | character... This is what worked for me: C:\>mysqlimport --fields-enclosed-by=""" --fields-terminated-by=| --lines-terminated-by="\r\n" --ignore-lines=1

Re: Data back up for innodb tables - Copy paste

On 2007-02-19 abhishek jain wrote: > I want to copy paste the data files of Innodb database, is it possible, i > mean can i just copy the data files like that we do for myisam tables If you mean for a daily backup while the server is running: No! You often end up with corrupted tables doing that

Data back up for innodb tables - Copy paste

Hi, I want to copy paste the data files of Innodb database, is it possible, i mean can i just copy the data files like that we do for myisam tables, Thanks, Abhishek jain

Re: Borland C++ Builder 2006 DLL Woes

We have settled on the ado.net connector www.mysql.com after dbExpress pains. Although apparently dbExpress does work. What BDS 2006 service pack are you on? Keep us all posted if you solve it. Mark [EMAIL PROTECTED] wrote: We just purchased The Borland Developer Studio 2006 IDE and are having

mysqlimport problem with , inside fields

I've been trying to import fields that contains the comma character ',' inside double quotes '"', with the results following: mysqlimport --fields-optionally-enclosed-by=""" --fields-terminated-by=, --lines-terminated-by="\r\n" --ignore-lines=1 --user=root --password shark "c:\documents and set

Re: INSERT using SELECT results

INSERT INTO ztipos (type) VALUES (SELECT DISTINCT type FROM locais) ? -afan Miguel Vaz wrote: Hi, I have a table LOCAIS with: idtypedesc 1t1blah blah 2t1uihuih 3t2pokpokp I want to list only the distinct types and create a table

Re: INSERT using SELECT results

This may help you: mysql> create table locais( -> id int, -> type varchar(2), -> `desc` varchar(10)); Query OK, 0 rows affected (0.12 sec) mysql> select * from locais; +--+--+---+ | id | type | desc | +--+--+---+ |1 | t1 | sk| |2 | t2 | dsk |

Re: No Data on table

Hello On 2007-02-18 Nhadie wrote: > I had an error that my database is already full, when i do a select there > is always no result even select * from tablename. > > but when i look at it on /var/lib/mysql i can see the size of the file is > still huge, > > -rw-rw 1 mysql mysql 9174 F

INSERT using SELECT results

Hi, I have a table LOCAIS with: id typedesc 1 t1 blah blah 2 t1 uihuih 3 t2 pokpokp I want to list only the distinct types and create a table with those results. I know how to list the distinct

No Data on table

Hi All, Hope you can help me with this problem: I had an error that my database is already full, when i do a select there is always no result even select * from tablename. but when i look at it on /var/lib/mysql i can see the size of the file is still huge, -rw-rw 1 mysql mysql 9174