Hello,
I have a table with approximately 68,000 records. I then get a file
uploaded to the server with approximately 68,000 master_id's listed in it.
If the master_id's in our MySQL table are not one of the master_id's listed
in the file, they need to be deleted from the MySQL table.
Right now,
Hi,
I am a newbie and hope someone can she light on why I can't get the
DBD::mysql connection working in my perl script. The script is a test one
and very simple.
I have the mysql daemon running and mysqladmin works, and DBI is installed
too. I went through the installation process for DBD a
Use http://www.mysql.com/doc/R/e/Resetting_permissions.html to reset your
password.
> could someone tell me how to make a clean sweep of MySQL from my
> system so i can start over?
> (i need to toss phpMyAdmin temporarily too
>
> i get asked for a password at every bend and none of the ones i use
I have installed mysql 3.23.39 on Linux Mandrake 8.0.
I have created a database but today I can't execute safe_mysqld.
Mysql tell me:
<< The file /usr/local/mysql/libexec/mysqld doesn't exist or not
executable. Please do a cd to the mysql installation directory and
restart this script from there a
Aah!! Thanks :-)
I didn't know a "flush privileges;" SQL statement was necessary. I'll be sure
to remember that!
Thanks!
Brian
>Perhaps the 'replication' of 'user' data (and/or other MySQL 'control' data)
>doesn't perform the necessary 'refresh' (which occures when you do a "flush
>privile
could someone tell me how to make a clean sweep of MySQL from my
system so i can start over?
(i need to toss phpMyAdmin temporarily too
i get asked for a password at every bend and none of the ones i use'
hardly ever' work ;)
e. i just don't get the root stuff and winder whay i can't
> I am a student using your mysql 2.23.38 version.My application details
> are,
>
> App-Server = TOMCAT3.2
> APPLICATION USED= JAVA AND JSP
>
> I have started MYSQLADMIN and I have a green signal of MYSQL in my
> taskbar.
> MYSQL is running but it is not responding. It is giving a
Hi folks! I have a question for you all... I've got two separate mysql
servers running on one machine. Both are 3.22.23b but used for separate
instances of separate webservers.
I'm having trouble with the "1030: Got error 127 from table handler" error
on only one of the servers.
Here's the sc
> I am trying to use php to print my results. This is my code (I have checked
> to see if fields are correct with regards to spelling and so on):
>
> printf("Genus: %s\n", mysql_result($result,0,"genus"));
>
> and I get the error message:
>
> Warning: Supplied argument is not a valid MySQL resul
[LogicEngineBean] java.sql.SQLException: General error: Got error -30996
from table handler
[LogicEngineBean] at
org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:498)
[LogicEngineBean] at
org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:551)
[LogicEngineBean] at
org.gjt.mm.m
We need to build MySQL from the source distribution and install into a
staging area, and then copy the contents of that staging area over to
/usr/local/mysql. During our build process, we cannot modify /usr/local.
The configure script lets us assign a prefix for installation into the
staging a
Hi folks! I have a question for you all...
I've got two separate mysql servers running on one
machine. Both are 3.22.23b but used for separate
instances of separate webservers.
I'm having trouble with the "1030: Got error 127 from
table handler" error on only one of the servers.
Here's t
I was searching the lists for an alternative to ODBC in Access 97, and came
across MyVbQL. I like what it does, but being written for Visual Basic, its
classes and such are not compatible with Access 97.
Does anyone know of a Visual Basic API/wrapper for libmysql.dll that would
allow the "dir
You'll be hard pressed to find one. There is one being worked on. You'll
find it on sourceforge. http://dbdesigner.sourceforge.net I think. What I
used for my layout was Dia. Probably not the best, but it worked.
If you find a good one, let us know.
j- k-
On Wednesday 20 June 2001
I have made an Access 2000 application for a real-estate company.
My client will be exportign his Access data in a MySql database which will
produce dynamic HTML pages (with some scripting) in an ISP server. So, his
data will be published at the Internet, this way.
My client will need to just cl
Jack:
We do it all of the time. We wrote some of our (Win32) client software to
use ODBC, so it can run on networks with other RDBMS (MSSQL7, Oracle, etc.).
Recently, we have incorporated the MySQL native library (libmysql.dll) into
one of our apps, allowing us to run directly with MySQL. Works
I'm not entirely familiar with how the daemon stores these values for the
entire database, but I'm guessing it's done in memory. Is it not possible
to allocate storage for these values in memory for each table that has been
opened?(they'd be removed once the table is destroyed, and not stored at
I've been looking around for a database modeling tool, ported for Linux.
I have seen in the archives a few suggestions of Windows-based tools,
but has anyone found or used a Linux-compatible database modeling tool?
Thanks,
Rob Mazur
Seattle, WA
-
Hi,
I've been experimenting with MySQL lately to see if we can use it in our project. We
hope to have a Linux server with a mix of linux and win98 clients. Is this possible
and if so, which products should I use.
Thanks jack
Hi.
On Wed, Jun 20, 2001 at 03:30:38PM -0700, [EMAIL PROTECTED] wrote:
> Ok...
> The replication is working perfectly.
[...]
> When I add a new user to the master server (using the webmin MySQL interface),
> the user can log in to the master server perfectly, but cannot log into the
> slave serve
Hello.
On Wed, Jun 20, 2001 at 08:27:19PM +0200, [EMAIL PROTECTED] wrote:
>
> is it possible to update fields of a table with values taken from another
> table? Like this (illegal) command would do:
> UPDATE b SET b.v = a.v WHERE b.id = a.id;
Not yet.
Multi-table deletes/updates are planned f
Hello.
On Wed, Jun 20, 2001 at 12:36:28PM +0100, [EMAIL PROTECTED] wrote:
> Hi folks,
>
> How come I can access databases on my server using an illegal username and
> password combination with the MySQL GUI? The username and password are valid
> on the server but should only work on localhost an
Perhaps the 'replication' of 'user' data (and/or other MySQL 'control' data)
doesn't perform the necessary 'refresh' (which occures when you do a "flush
privileges"), but was 'triggered' when you changed the users' password
Turtle wrote:
> Ok.. even more bizarre... IN addition to what I to
Hello.
On Wed, Jun 20, 2001 at 02:46:18PM +0100, [EMAIL PROTECTED] wrote:
> I seem to be reaching the max_heap_table_size with heap tables that should be at
> least 10 times smaller than the max size
>
> The following shows what happens, note the error after the insert statement:
>
> mysql> CRE
Ok.. even more bizarre... IN addition to what I told you in my last posting,
I just logged onto the slave server and changed the user's password to what
it was already, and now the user can log in.
I verified the ENCRYPTED password string before and after the change, and it
was IDENTICAL!!! NO
Ok...
The replication is working perfectly.
It's just gorgeous how it works.
All of my tables sync with multiple machines perfectly.
When I do a show slave status; I never see any errors.
HOWEVER!!:
When I add a new user to the master server (using the webmin MySQL interface),
the user ca
I'm trying to use the Full text Search with the japanese language using
either doublebyte or singlebyte character. The problem is it doesn't seem
to be working at all for any searches. I use a sql statement like this one
select * from hdwkeywords where match (JAPANESE) against ('japanese
keywor
Hello *.*
The new Version (1.19beta) of MySQL-Front is available: Download at
http://www.anse.de/mysqlfront/download.php
The main reason for this update is the new editing-grid, which was requested
by many users. I said goodbye to the old component (StringAlignGrid) and
implemented the ZEOS Dat
Hi guys,
Is there any work around the max_allowed_packet problem?
I am trying to import some big strings (33M - 300M) using mysql 3.23.36
on mandrake 8.0
Cheers,
arek
PS. Apologies if this is a well known problem but I am new to this list
and could not find a definitive answer in docs.
---
On 2001 Jun 20, Michael Widenius <[EMAIL PROTECTED]> wrote:
>
> Tim, what do you think if we rename our own copy of bdb with 'libmy-bdb'
> just to ensure that we link with our copy of bdb ?
I think this is a good idea. libdb is everywhere, and it's
too easy to make a mistake. I'll add it to my
Hi,
When I try to give a default value in an enum field with a string
containing extented ascii value (i.e. higher than 128), I get an 'Invalid
default value for enum_field' error. For instance, the command:
alter table MyTable add AnEnumField enum('Employé', 'Producteur',
'Actio
I understand that I can execute SQL/DDL inside a text file
into MySQL. I have DDL that ERWin spitted out. It includes
keywords like "go" between instruction sets and also a
alter table section with foreign keys. Can I execute this as is,
or should I clean up this part of the sql flle?
Thanks
Vij
I get the following message ,
"Operation is not supported for this type of object" ,
whenever I try to use the index property of a recordset object based on a
table linked to Mysql Database using ODBC.
Can someone out there please tell me how this can be resolved.
Thanks.
--
If you're not using GCC 3.0 AND libwrap, this message probably won't
apply to you
Trying to compile 3.23.39 on Linux 2.4.5 with GCC 3.0 and libwrap enabled
leads to errors like this when the compiler reaches mysqld.cc:
c++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/usr/local\""
-DDATADIR="\"/u
Markus,
when you try to create the table test with type = innodb,
does the server print into the error log or to the screen:
Innobase: error: table test/test already exists in Innobase data dictionary
If so, then you have probably created the table already in the InnoDB
format and deleted the .
At 20:41 20/06/2001 +0200, Markus Wichitill wrote:
Hi,
Thanks for the bug report. I was be able to repeat the issue
after I dropped the already existing database test.
The problem is InnoDB applies the following error:
Innobase: error: table test/test already exists in Innobase data dictionary
i installed some days ago the RedHat 7.1 with apache and the php4, since
that i have donne nothing in my system, tham i installed the mysql wich
works fine, i installed the php-mysql rpm packege, my php is version
4.0.4 and the packeg is for version 4.0.1, i dont know if is it but the
php and the
Check the permissions on the directories you are using for data, as well as
checking the user the MySQL deamon is running as.
j- k-
On Wednesday 20 June 2001 06:55, [EMAIL PROTECTED] wrote:
> MySQL newbie question here!!
>
> I have MySQL installed on Red Hat Linux 7. I have a Test, Back
You say it's not sending the user name. What connect string are you using?
Does it include the user name? Can you post the exact connect string you are
using when you connect to the database?
As I have it set up on my windows side of things: the DSN in the ODBC setup
has no username or pass
At 00:57 21/06/2001 +0700, Aa wrote:
Hi,
First create the my.ini file at /WINNT directory.
Edit the following section and keys
[mysqld]
basedir=e:/_db/mysql
datadir=e:/_db/mysql/data
If you want the InnoDB table, below the samples of the keys for the
[mysqld] section:
[mysqld]
basedir=e:/_db/
Hi,
I was wondering if anyone has seen a similar error?
"An error has occurred in ProcessorAdding{TXC][MyODBC] Access denied for
user: '[EMAIL PROTECTED]' Using Password:NO"
We can't seem to replicate this error. We are using MySQL with AvantGo. (
MySql server version 3.23.32)
Thank you,
H
Hi,
I'm using MySQL 3.23.39-log compiled from sources on SuSE Linux 6.4. When I
create an InnoDB table with the same name as the database, I get the
following error message:
mysql> create database test;
Query OK, 1 row affected (0.01 sec)
mysql> create table test (x int) type=innodb;
ER
Hi,
is it possible to update fields of a table with values taken from another
table? Like this (illegal) command would do:
UPDATE b SET b.v = a.v WHERE b.id = a.id;
Jens
-
Before posting, please check:
http://www.mysql.com/
OK now I feel dumb I thought I had checked that... but what has
happened was that there were multiple instances of the file... so while I
changed the write access on the mysql files I thought were being used
it still didn't work... but low and behold... there was another directory
wit
Please not my email address I would like to have mysql sent to is
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 20, 2001 11:16 AM
To: [EMAIL PROTECTED]
Subject: confirm subscribe to [EMAIL PROTECTED]
Hi! This is the ezmlm
On Wednesday 20 June 2001 07:30, Michael Widenius wrote:
> Hi!
>
> > "Sasha" == Sasha Pachev <[EMAIL PROTECTED]> writes:
>
> Sasha> On Tuesday 19 June 2001 17:43, Russell E Glaue wrote:
> >> > . After you've pulled, run BUILD/compile-pentium (for a lean fast
binary)
> >> > or BUILD/compile-
You didn't mention how many 'transactions per second/minute/hour' you
expect... (on those 25 connections)
A Sun Ultra 10 is just a PC built by Sun (but with a Ultra-SPARC CPU and
other nice enhancements). I don't know if Sun has made it possible to
attach ANY brand of disk drive (that they haven
Hi,
This is my first comeback to install mySQL on Windows 2000 Server and have some
trouble on installing mysqld-nt as a service as told in readme and looking for some
assistant from the expert. I have download the latest version of mySQL that is version
: 3.23.39-max-nt.
I try to follow ste
ls -l /var/mysql/mysql/user.*
Replace above path with actual path on your system.
Does mysql have write privileges on the files?
[EMAIL PROTECTED] wrote:
> Unfortunately I have tried that. Attempted to GRANT all privelages to the
> root user it failed with the same error message stating t
Hi.
I'm running the binary (RPM) installation of MySQL server 2.23.39 for pc-linux-gnu
on i686 with Kernel 2.4.4 on the master and 2.4.2 on the slave.
I'm using two machines on a local network, one 192.168.0.14 and the other one
192.168.0.81.
The appropriate lines from my.cnf on the slave (192.
If you back them up before you check them, and the check blows up, you
still have your backups.
Koen Gogne wrote:
> hi,
>
> I'm trying to automate the back up of my MySQL databases,
> and before I perform my backup I check my tables using
> myisamchk and isamchk.
> When myisamchk and isamchk r
On Wed, Jun 20, 2001 at 10:59:46AM -0500, Jeff Jirsa wrote:
> Hi, I'm having a problem building MyODBC 2.50.37 on BSD.
> When I run make after configure, I get the error:
>
> "Makefile", line 315: Need an operator
> make: fatal errors encountered -- cannot continue
When I see this, my first assu
Hi folks,
How come I can access databases on my server using an illegal username and
password combination with the MySQL GUI? The username and password are valid
on the server but should only work on localhost and I am on a remote
machine.
regards
Andy Ayers
---
Andy
Without more information this appears to be a very simple question -
serialize the object insert it into the blob field.
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> m] On Behalf Of Saeed Saleem
> Sent: Wednesday, June 20, 2001 11:28 AM
> To: [EMAIL PROT
Unfortunately I have tried that. Attempted to GRANT all privelages to the
root user it failed with the same error message stating that the Table
"user" is read only.
UGH Too frustrating!!
apologies if this is documented somewhere, but i have found much of the
material confusing.
I am attempting to build mysql-3.23.39 on a sun Solaris 2.6 box, with the
languages / utilities installed.
1. perl5.6.1
2. GNUmake
3. GNUm4
4. GNUtar
5. apache1.3.19
6. autoconf-2.13
7. automake-1.4
8. ga
Hi, I'm having a problem building MyODBC 2.50.37 on BSD.
When I run make after configure, I get the error:
"Makefile", line 315: Need an operator
make: fatal errors encountered -- cannot continue
Line 315 contains:
-include $(DEP_FILES)
If I comment out 315 and run make again, I get:
make: don'
Hi all, i need to deploy a huge database (about 160 Gb) of information,
mainly images and pdf documents, access will be aprox of 25 simultaneous
connections in the worst case; so i need to choose the right hardware
configuration and i need your help.
We are thinking in a Sun Ultra 10
Would anyone can kindly answer my question :
How to store/retrieve objects in blob fields, plz keep in mind that I am using
java.
Regards
Muhammad Saeed
Sr. Software Developer
eTrango Pakistan (pvt) Ltd.
Why dont you use the GRANT command?
GRANT ALL ON database.* TO newuser@localhost IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
Something like that...
Cheers, Nessi
At 15:55 20/06/01 , you wrote:
>MySQL newbie question here!!
>
>I have MySQL installed on Red Hat Linux 7. I have a Test, Backup an
>I am currently using MySQL to warehouse real-time data, and I have a couple
>of questions regarding AUTO_INCREMENT columns.
>
>OS: Linux/Solaris
>MySQL version: 3.23.33
>Table Types: MYISAM
>
>
>1) The data is only stored for 24hrs. If I do continuous deletes from the
>tables, will the AUTO_INCR
Hi.
On Tue, Jun 19, 2001 at 09:01:30AM -0700, [EMAIL PROTECTED] wrote:
> I'm generating a pulldown menu using PHP and MySQL. Originally I had the
> list order by model where it put everything in alphabetical order. I need to
> order them by year of model which luckily coincides with the order tha
MySQL newbie question here!!
I have MySQL installed on Red Hat Linux 7. I have a Test, Backup and Live
environment. All with the same installations of Linux, MySQL and CF. The
problem that I am having is that I am trying to create a new database user
in the table "user" in MySQL. It works find in
> How can I transfer the data from a MySQL 3.22.32 running on RedHat
> 6.2 Linux to a MySQL 2.23.37 running on Windows 98?
MySQL-Front 1.18 (www.mysqlfront.de) is able to replicate directly between
two opened connected hosts : "Im-/Export" => "Export Tables" => "Output:
Another Host/DB". You only
Hello.
On Tue, Jun 19, 2001 at 11:30:34AM +0530, [EMAIL PROTECTED] wrote:
[...]
> This is my sql statement:
> mysql> select count(*),travel.nome_hotel,travel.tour_operator,
> city.city,travel.vitofferta from travel,city where city.id=travel.cityid
> group by travel.nome_hotel limit 5;
>
> The re
I am currently using MySQL to warehouse real-time data, and I have a couple
of questions regarding AUTO_INCREMENT columns.
OS: Linux/Solaris
MySQL version: 3.23.33
Table Types: MYISAM
1) The data is only stored for 24hrs. If I do continuous deletes from the
tables, will the AUTO_INCREMENT colu
Hi.
On Mon, Jun 18, 2001 at 08:48:45PM -0300, [EMAIL PROTECTED] wrote:
> How can I transfer the data from a MySQL 3.22.32 running on RedHat
> 6.2 Linux to a MySQL 2.23.37 running on Windows 98?
Use 'mysqldump' to create an SQL dump and then use the 'mysql' command
line tool on Windows to execute
Hi!
Tim, what do you think if we rename our own copy of bdb with 'libmy-bdb'
just to ensure that we link with our copy of bdb ?
Regards,
Monty
> "Dave" == Dave FitzPatrick <[EMAIL PROTECTED]> writes:
Dave> On 19 Jun 2001, at 13:36, Sinisa Milivojevic <[EMAIL PROTECTED]> wrote:
>> Dave Fi
Hi,
First of all, this is irrelevant if you're not using HP-UX.
Second, apologies if this isn't the correct list, but I've been unable
to find
a more suitable one.
This is just some info on how I got Mysql-3.23.39 to compile on HP-UX
11.00 using gcc,
because I thin
On Wed, 20 Jun 2001, Michael Widenius wrote:
>
> Hi!
>
> > "Sasha" == Sasha Pachev <[EMAIL PROTECTED]> writes:
>
> Sasha> On Tuesday 19 June 2001 17:43, Russell E Glaue wrote:
> >> > . After you've pulled, run BUILD/compile-pentium (for a lean fast binary)
> >> > or BUILD/compile-pentium-
I seem to be reaching the max_heap_table_size with heap tables that should be at
least 10 times smaller than the max size
The following shows what happens, note the error after the insert statement:
mysql> CREATE TABLE jontmp (id INT(11) UNSIGNED NOT NULL , relevance TINYINT
UNSIGNED NOT NULL,
One way you can try doing this is by implementing phrase searching after
the fulltext search:
"...WHERE MATCH author AGAINST('ian fleming')
AND LOCATE('ian fleming', LOWER(author)) > 0
I think this will work.
Barry Wiegan
> At 17:09 19/06/01 , you wrote:
> >Hi. We're using full text sear
That means either your $result doesn't exist or the query you used to get
$result failed.
Use something like this (at least in PHP) to see what MySQL's error was:
if ($result=mysql_query($query))
{
//worked
//echo mysql_num_rows($result);
}
else
{
//didn't work
$errMsg="Failed Query: $customer_s
hi,
I'm trying to automate the back up of my MySQL databases,
and before I perform my backup I check my tables using
myisamchk and isamchk.
When myisamchk and isamchk report errors I would like to catch that
and maybe perform a restore operation.
hence my question: what could go wrong when runn
Hi,
We are using fairly complex fulltext queries on multiple tables via
inner joins. We ge the correct results, but they are not sorted by
relevance as indicated in the manual. I tried to reconstruct the
query to use "AS score FROM tablename" and sort on the score, but
always get syntax errors
I am trying to use php to print my results. This is my code (I have checked
to see if fields are correct with regards to spelling and so on):
printf("Genus: %s\n", mysql_result($result,0,"genus"));
and I get the error message:
Warning: Supplied argument is not a valid MySQL result resource
anyone know howto get mysql to allow multiple connections to a user? i'm trying to get
a db working also using php4 but when someone is searching the db someone else can't
query it. (it's http://virtuozo.hn.org/wp/ )
Kind Regards
kris Amy
Make sure mysql owns the mysql database directory and files.
Peter H. Burris wrote:
> I'm a sysadmin who created mysql installs for users on linux x86 boxen; I
> had to create self-contained, architecture-specific packages to comply
> with our in-house means of handling software in my departmen
Hi!
> "Sasha" == Sasha Pachev <[EMAIL PROTECTED]> writes:
Sasha> On Tuesday 19 June 2001 17:43, Russell E Glaue wrote:
>> > . After you've pulled, run BUILD/compile-pentium (for a lean fast binary)
>> > or BUILD/compile-pentium-debug - it will build a binary for you.
>>
>> We run all our M
Hi,
> Milan Kajnar wrote:
>
[skipped]
> >I use WinZeosDB 3.3 Components in Delphi applications...
>
> This definitely looks like a bug in Zeos components. Running this
> command in mysql client or mysqlgui works just find.
May be, at least ZeosDBO-5.2.2 works for me fine. Check
http://www.zeosli
Thanks for your feedback.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
I am sure this has been recommended on this list before, but here it goes:
One very good book to read regarding theory is: Database Design for Mere
Mortals by Michael Hernandez, it sits along with Paul DuBois' book on my
night table. I don't think you can pick a better combination to teach
yoursel
wendorf, pat writes:
> Is it possible to observe Handler_read_next and Handler_read_key on a per
> table basis? If not, could this feature be added?
>
> I'm not subscribed to this list, please cc all replies back to this email
> address.
>
> - Pat Wendorf
>
>
Hi!
It could be possi
Milan Kajnar wrote:
>Hello..
>
>I need help in this:
>
>When I use this query on my DB:
>
>"OPTIMIZE TABLE xxx..." - all look fine... but when I want optimize next
>table I get this error message from MySQL server: Command Out of Sync - You
>cannot run this command now
>
>When I disconnect a
Quoting Alessandro Coppelli ([EMAIL PROTECTED]):
> I have this simple table
>
> create table tbl (
> sid int not null auto_increment ,
> filed1 LONGTEXT,
> field2 LONGTEXT,
>primary key (sid)
> )
>
> When I insert one item ( insert into tbl values (filed1,filed2) ) I
> o
Hi to all.
I have this simple table
create table tbl (
sid int not null auto_increment ,
filed1 LONGTEXT,
field2 LONGTEXT,
primary key (sid)
)
When I insert one item ( insert into tbl values (filed1,filed2) ) I
obtain error .
Why ?
Must I insert the sid ? If yes
Hi
I am getting the following error while i try to do a make
/usr/lib/bison.simple: In function `int yyparse()':
/usr/lib/bison.simple:255: Internal compiler error.
/usr/lib/bison.simple:255: Please submit a full bug report to
`egcs-bugs@egcs.
gnus.com'.
/usr/lib/bison.simple:255: See
http://e
My name is Thanatip Tantulavanich.I study computer sience
Burapha University in Thailand.
I do the Project to topic Sort Thai Language in MySQL.I can
Sort Thai Language but I don't know module for Sort in MySQL.If I
command order by for sort Thai-database.
Project for use
>Description:
I have installed my MySql month ago and it was working well,
but now when i want to create table in my database it
tells me sush error
--- ERROR 140, cannot create ./TESTS/pid.frm
I dont know what to do
>How-To-Repeat:
>Fix:
>Submitter-Id:
I came across this error in a script which keep track of interesting URLs,
where the first column in a table is an automatically incrementing,
primary-key Id field. This statement failed:
mysql> insert into Matches values
(0,1234,56,'http://interesting.com/', 'title', NOW(), 'New');
ERROR 1062:
I know that this files exist on mySQL Windows,
(3 files by Tables)
someone can tell me if this files exist on mySQL HPUX?
I use this files to make a rollback.
Thanks.
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://per
With MySQL 3.23's MyISAM tables, yes, since they are platform independent.
> Hi,
>
> Do someone maybe know, if it is possible to transfer a
> mysql database?
> Is it enough, that I copy the
> /mysql/data/$databasename to another computer to have
> there the same database with the same tables an
http://www.mysql.com/doc/R/E/RENAME_TABLE.html says:
As long as two databases are on the same disk you can also rename from one
database to another:
RENAME TABLE current_database.table_name TO other_database.table_name;
And as the user comments say, you can use ALTER TABLE with 3.22.
Copying c
What are the types of the columns?
> Hi all,
> ... running this query
>
> alter table item_dettagli
> add fulltext(categoria_prezzo,settore,movimento,soggetto,lingua)
>
> I get this error:
>
> 1005 - Can't create table '.\pickwick\#sql-3d0_2.frm' (errno: 140)
> Query:
> alter tabl
The default max_allowed_packet is 1 meg
http://www.mysql.com/doc/P/a/Packet_too_large.html
> hi
>
> Can anyone please help with regards to long blob data insert.
> I have a data which more than 1mb which MySQL long blob field
> refuse to insert.
> However if my data is less than 1mb there if n
Hi all,
i have installed mysql on NetBSD, already had to work around and make a
dir /usr/local/mysql/libmysql/.libs with the file libmysqlclient.so
cause for some reason mysql expect it there. Now i only get this error.
010620 9:50:51 /usr/local/mysql/libexec/mysqld: Table 'mysql.host' doesn
http://www.mysql.com/doc/R/e/Replication.html
> Hi all,
>
> I'm new to this list, fairly new to PHP and mySQL and I have a question
> about syncing two databases. I search all over the web for this,
> including a
> win32 version of rsync, but that's not suitable in my case, so
> here it goes:
http://marc.theaimsgroup.com/?l=mysql&r=1&w=2
> Is there an archive to this list?
>
> My MS Access ODBC is not sending the user name to MySQL, and I don't
> doubt that it is a known problem.
-
Before posting, please check:
hi,
I'm trying to automate the back up of my MySQL databases,
and before I perform my backup I check my tables using
myisamchk and isamchk.
When myisamchk and isamchk report errors I would like to catch that
and maybe perform a restore operation.
hence my question: what could go wrong when runn
I havent changed these settings but there is a section on it
in the mysql manual. And yes mysql filters everything under
4 letters out and it wont output results for words matched too
often (I think the manual said more than 50% but it was only
for words that matched all entries for me).
From th
1 - 100 of 106 matches
Mail list logo
