Hi all,
I have an sql file that I exported from a database of mine that has over 3000 lines
(records) in it. How do I go about importing that information into the database ?
Previously I was using the same sql to test it, but it was only a few hundred lines or
so and I simply cut-and-pasted the
On Feb 11, 2004, at 9:31 PM, Chris Nolan wrote:
Done intelligently, though, a Visual FoxPro app that uses VFP for
the GUI and business logic, and which uses MySQL as the back end, is
an incredibly powerful combination. I haven't done VFP development
that uses Xbase-type tables in years. You
Greetings MySQL gurus!
I am setting up a local db and plan to access it via perl & DBI. on a Mac
iBook running OSX 10.3.2
After creating a new user account to run the sql server, I connected to
the sql server with my personal account and all works fine regarding
accessing my tables, etc.
I then
N??j??j{ z恨w???oz??
???篆??i, all
I have a mysql server (dual P4 2.0G, 1G MEM, RH8.0, Mysql 4.0.12),
There are 2 tables defined as follow:
create table a (
imgid int not null,
parent int,
imgtype char(3),
img longtext,
primary key (imgid),
key (parent, imgid)
) type = innodb;
cont
Ed Leafe wrote:
On Feb 11, 2004, at 7:31 PM, Chris Nolan wrote:
Yes, we all know that Microsoft *bought* FoxPro's underlaying
technology, that is *FoxBASE*! Everything ever called FoxPro has been
a Microsoft product.
Sorry, you're off by a few years. FoxPro had been out for several
years
On Feb 11, 2004, at 7:31 PM, Chris Nolan wrote:
Yes, we all know that Microsoft *bought* FoxPro's underlaying
technology, that is *FoxBASE*! Everything ever called FoxPro has been
a Microsoft product.
Sorry, you're off by a few years. FoxPro had been out for several
years before Microsoft boug
N??j??j{ z恨w???oz??
???篆??i all,
I have setup a replication slave for my company's master mysql server,
but the slave stops on sql "DROP /*40005 TEMPORARY*/ TABLE xxx" frequently,
(xxx is the temporary table name created on master by our applicaion
server, because no subselect support under m
Hello,
we are currently running MySQL 4.0.15 w/InnoDB tables on a RH/Linux 9.0 and
would like to upgrade. the current RPM's installed are:
MySQL-client-4.0.15-0
MySQL-embedded-4.0.15-0
MySQL-devel-4.0.15-0
MySQL-shared-compat-4.0.15-0
MySQL-shared-4.0.15-0
MySQL-server-4.0.15-0
MySQL-bench-4.0.1
Hi all,
I'm looking at developing an (open source) server-style application with
the embedded MySQL library to be employed as the primary data store.
Has anyone attempted to use InnoDB Hot Backup for such a beast? I ask as
I do not know whether communication between ibbackup and the database
e
Yes, we all know that Microsoft *bought* FoxPro's underlaying
technology, that is *FoxBASE*! Everything ever called FoxPro has been a
Microsoft product.
Agreed that FoxPro's xBase implementation is quite quick, but the fact
that it's pushed as a high-performance multi-user engine is a bit of an
Okay,
So I should be good with a 30GB setting. My temp dir is on a volume with
over 300GB of free space.
What about the other settings?
Has anyone on this list actually dealt with a database of this magnitude and
MySQL? Most people I talk to are running pretty small databases and usually
nothing
These files will be created in the /tmp directory or where ever your temp
directory was declared. One temp table will be created for each ALTER or
CREATE INDEX statement.
>> Original Message <<
On 2/11/04, 5:42:31 PM, Chris Fossenier <[EMAIL PROTECTED]> wrote
re
None of my individual tables are larger than 12GB, however, I have no idea
if MySQL creates a separate TMP file for each indexing job or if it creates
a new one for each instance.
Also, where would it create this file? In the tmp dir?
Chris.
-Original Message-
From: [EMAIL PROTECTED] [ma
I did a search of the list before posting. Noticed
several others having the same issue, but could not
find a resolution in any of the posts.
I seem to be having some clib problems with the
current
AIX mysql binary (AIX 4.3.3, mysql-standard 4.0.17
(ibm c++ compiled) -- downloaded on 02/11/200
Interesting idea, but I should be ok. I don't plan to have large amounts of
MySQL threads. I just had FreeBSD setup to allow 2GB of memory per process
because of memcached which I also plan to run on this server. I just
compiled it to a little under 2GB and MySQL ran fine, it was just hard to
tr
If I am reading your parameter correctly, MySQL will limit the size of
the temporary file created to 30GB. If the file exceeds this limit, then
MySQL will use key cache to create the index. What is the footprint of
your MYD and MYI files?
>> Original Message <<
Humble apologies for the broken link. Google on the filename; it seems popular enough
that it should be out there somewhere. Particularly look at the MySQL site; there
might've been a few links there.
--Sean Flynn
Stefaan Van Dooren <[EMAIL PROTECTED]> wrote:
Thanx for the answer,
But the lin
Can you provide a better explanation of these variables? I have yet to find
a thorough explanation of each one of them.
My myisam_max_sort_file_size = 3M
I am running the indexes with an "ALTER TABLE ENABLE KEYS" command after I
load the data into the tables.
Chris.
-Original Message---
Can you connect from the command line as this user from this host?
Have you tried using a different user?
Can you ping the target host from the source host?
>> Original Message <<
On 2/11/04, 3:25:49 PM, Adam Staunton <[EMAIL PROTECTED]> wrote
regarding RE: mySQL
Don't know wether this is best practice o rnot but what I have set up is a
batch file that:
1. stops the mysql service.
2. copies and zips the databases to a separate machine 3. restarts the
service.
I have used the archive files on other machine sand they all seem to work
fine, the whole thin
Performing your indexing in one batch will create a temp table only once
as opposed to n-times.
What is the current value of your myisam_max_sort_file_size?
>> Original Message <<
On 2/11/04, 2:53:34 PM, Chris Fossenier <[EMAIL PROTECTED]> wrote
regarding RE: Ind
Michael McTernan wrote:
Hi there,
I'm making something similar to a file revision control system, and using
MySQL on Linux as the database to drive it. Almost all my tables are
InnoDB, and generally it is going very well, with the exception of one table
that is always very slow.
This table holds
Hi there,
I'm making something similar to a file revision control system, and using
MySQL on Linux as the database to drive it. Almost all my tables are
InnoDB, and generally it is going very well, with the exception of one table
that is always very slow.
This table holds the files within the da
Hi,
I do just this at the moment - I have a cron job that runs MySQL dump, gzips
the output, and will then ftp the important files to a machine that get's
backed-up to a tape drive. I also time the dump, and it currently takes
just over 3 minutes which is quite acceptable for what I'm doing. I'm
> -Original Message-
> From: Madscientist [mailto:[EMAIL PROTECTED]
> We use this mechanism, but we do our mysqldumps from a slave
> so the time doesn't matter.
Excellent idea.
> Interesting side effect: A GZIP of the data files is _huge_.
> A GZIP of the
> mysqldump is _tiny_. For
Using phpmyadmin I have granted all priviledges to the user for the database. Any
ideas ?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, 12 February 2004 4:12 AM
To: Adam Staunton
Cc: [EMAIL PROTECTED]
Subject: Re: mySQL and odbc
Have the grant tabl
Here is the create statement and the resulting table:
mysql> create table test(
-> myblob longblob) default charset latin1 default collate
latin1_general_cs;
Query OK, 0 rows affected (0.08 sec)
mysql> show create table test \G
*** 1. row ***
I'm having difficulty getting binary logging to run. My system is a Debian 3.0r2
system running MySQL-server 4.0.16-log. I have added "log-bin" to my my.cnf file.
However, when I restart MySQL I don't get a binary log anywhere. When I run SHOW
MASTER STATUS, I receive an empty set. I'm sure
I have checked these...but I don't know what to set them too. Can I get more
input? Should I only run 1 index at a time? I have 2 machines (both quad
Xeon)..one is running a singel indexing job, the other is running 6 jobs. It
looks like they will end up completing in the same amount of total time
From: "David Brodbeck" <[EMAIL PROTECTED]>
Sent: Wednesday, February 11, 2004 9:27 PM
> > > -Original Message-
> > > From: Michael Collins [mailto:[EMAIL PROTECTED]
>
> > > Is there any "best-practices" wisdom on what is the most preferable
> > > method of backing up moderately (~10-20,000
What type of Data is being indexed?
- depends on the table, but I'll provide a few samples.
- table a1 has 3 indexes
- col1 = BIGINT
- col2 = varchar(3)
- col3 = varchar(11)
- table h1 has 3 indexes
- col1 = varchar(11)
- col2 = INT
- col3 = INT
Is the databa
On Wed, 2004-02-11 at 09:29, Chris Fossenier wrote:
> Hello,
>
> I had a question about indexing a while back and everyone screamed
> "normalize"!!
>
> Well...I've normalized much as I'm going to, and at most I have 3 indexes on
> any one table. My database has 120 million records in it and the
On Feb 10, 2004, at 9:12 AM, Chris Nolan wrote:
12. MySQL AB weren't responsible for afflicting the world with the Jet
database engine (Access) or Visual FoxPro, thus they are more
trustworthy than MS! :-)
Microsoft *bought* FoxPro; they didn't develop the database engine.
FWIW, it is one of t
> > -Original Message-
> > From: Michael Collins [mailto:[EMAIL PROTECTED]
> > Is there any "best-practices" wisdom on what is the most preferable
> > method of backing up moderately (~10-20,000 record) MySQL 4
> > databases? A mysql dump to store records as text, the
> format provided
>
On Feb 11, 2004, at 1:47 AM, nyem wrote:
It works fine on small number of rows, but when the table reaches 400
rows the time it took to execute the query was 16 sec. And my cpu shot
up to 100% whenever I populate 1000 rows. What have I done wrong here?
Did you try creating an index on the `date
> > Is there any "best-practices" wisdom on what is the most preferable
> > method of backing up moderately (~10-20,000 record) MySQL 4
> > databases? A mysql dump to store records as text, the
> format provided
> > by the BACKUP sql command, or some other method? I am not asking
> > about replic
Hi,
I'd love to see this too. Even if it was a book that cost ?40 to buy, I'd
get a copy.
Hey, maybe someone can recommend a book - I've looked hard and not really
come up with anything better than the MySQL manual, which while great, is
missing the 'best practices' :(
Thanks,
Mike
> -Ori
Have the grant tables been set up to allow this user access from this
host?
Do a show grants for this user.
>> Original Message <<
On 2/10/04, 5:52:11 PM, Adam Staunton <[EMAIL PROTECTED]> wrote
regarding mySQL and odbc:
> Hi all,
> I am getting the following
Yes a duplicate copy of the table is created and the Indexes are created
on that new table, the original table is dropped and the new table is
renamed. What type of data is being indexed? Are you attempting to index
while the database is being actively used? What version of MySQL are you
using?
Hi,
I have done a show processlist\G right after I start slave.
*** 1. row ***
Id: 1
User: martin
Host: localhost:1110
db: NULL
Command: Query
Time: 0
State: NULL
Info: show processlist
*** 2. row
This is Ascii 241 and should display fine in your MySQL monitor.
SELECT CHAR(241) displays correctly for me. How are you inserting this
character into the database?
>> Original Message <<
On 2/11/04, 11:20:30 AM, Julien Martin <[EMAIL PROTECTED]> wrote
regarding
Did you install PHP-mysql*.rpm?
Curtis
On Tue, 10 Feb 2004, Eric W. Holzapfel wrote:
> Hello Listers,
>
> I have a problem with my PHP/redhat setup, and possible problem with my
> Mysql setup.
> I have Apache (2.0) and PHP (4.3.2) installed on a Red Hat 3.0 ES system.
> I have MySql install
Hello,
I had a question about indexing a while back and everyone screamed
"normalize"!!
Well...I've normalized much as I'm going to, and at most I have 3 indexes on
any one table. My database has 120 million records in it and the index
creation is taking a ridiculous amount of time. I can creat
Hello,
I am trying to display the following letter "ñ" (n with ~) on a web page.
Basically I would like for the correct letter to appear in the web page as
well as on the mysql console as well as in the html source. How do I do
that?
Thanks in advance,
Julien.
--
MySQL General Mailing List
For l
* Bengt Lindholm
> I have a table where I need to group the content on a timestamp. Any
> record that is less than say 5 minutes from any other record needs to
> be grouped with that other record.
>
> ID timestamp
> 1 2004-02-02 12:00:00
> 2 2004-02-02 12:00:05
> 3 2004-02-02 12:05:20
* Carlos Vazquez
> I get this error when I try to execute the following select statement:
> "All Parts of a PRIMARY KEY must be NOT NULL; if you need null in
> a key, use UNIQUE instead."
>
> CREATE TEMPORARY TABLE IF NOT EXISTS
> CashVariances
> (PRIMARY KEY(sUnit))
> SELECT
> sUnit,
* rmck
> I have a varchar field "start" on my db that stores dates. The
> dates are loaded into mysql from a txt file which are like this
> "2004-02-10 23:35:12" in the txt file.
>
> I'm thinking this is not a correct choice of datatype for the
> column which is called "start". What is the be
I solved it myself :)
You need to keep the primary keys in the same order as the index, DOH!
ofcourse :)
In parant table
PRIMARY KEY(key1,key2)
In child table
INDEX(key_fk1, key_fk2)
Regards
/Jonas
- Original Message -
From: "Jonas Lndén" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
I have a varchar field "start" on my db that stores dates. The dates are loaded into
mysql from a txt file which are like this "2004-02-10 23:35:12" in the txt file.
I'm thinking this is not a correct choice of datatype for the column which is called
"start". What is the best or recommended dat
mysql> SHOW PROCESSLIST\G
Id: 2
User: system user
Host:
db: NULL
Command: Connect
Time: 80
State: Waiting for master to send event
Info: NULL
Id: 3
User: system user
Host:
db: NULL
Command: Connect
Time: 192
State: Has read all relay log; waiting for the
On Wed, 2004-02-11 at 22:29, Jochem van Dieten wrote:
> Chris Nolan wrote:
> > Martijn Tonies wrote:
>
> > Additionally, it is an accepted fact that MySQL is faster than the
> > mighty, mighty PostgreSQL.
>
> No, it is not. It is an accepted fact that MySQL is faster than
> PostgreSQL for certa
Hello, I am banging my head against the wall trying to figure out how to construct a
foreign key towards a table with a primary key consisting of two columns. I have been
googling around and thought this would work, but it just gives me an ERROR 1005.
ALTER TABLE testDB ADD FOREIGN KEY (fkey1, f
I get this error when I try to execute the following select statement:
"All Parts of a PRIMARY KEY must be NOT NULL; if you need null in a key, use UNIQUE
instead."
CREATE TEMPORARY TABLE IF NOT EXISTS
CashVariances
(PRIMARY KEY(sUnit))
SELECT
sUnit,
dSalesDate AS dDa
"naveen" <[EMAIL PROTECTED]> wrote:
> thanks Victoria Reznichenko
>
> for your help
> where will i put this parameter
> SET FOREIGN_KEY_CHECKS = 0;
> in the dump file or under mysql pormpt.I added through mysql but still the
> same error comes.
You should put
SET FOREIGN_KEY_CHECKS = 0;
at the
I get this error when I try to execute the following select statement:
"All Parts of a PRIMARY KEY must be NOT NULL; if you need null in a key, use UNIQUE
instead."
CREATE TEMPORARY TABLE IF NOT EXISTS
CashVariances
(PRIMARY KEY(sUnit))
SELECT
sUnit,
dSalesDate AS dDat
Mike,
you are close: you want the mysql client to give back just the data, no
column description. Change this line to read:
MYSQL="/usr/local/mysql/bin/mysql --user=$username --password=$password
--host=$server --skip-column-names cetechnology"
On Tue, 10 Feb 2004, Mike Tuller wrote:
> Ok. I
thanks Victoria Reznichenko
for your help
where will i put this parameter
SET FOREIGN_KEY_CHECKS = 0;
in the dump file or under mysql pormpt.I added through mysql but still the
same error comes.
can you please help me in that
with regards
Naveen
- Original Message -
From: "Victoria
"vitaly" <[EMAIL PROTECTED]> wrote:
> How can I disable the option of SQL DELETE of data from MySQL4.x database for some
> specified tables? Or even for all the database tables?
Don't grant DELETE privilege for those users.
--
For technical support contracts, goto https://order.mysql.com/?ref=
Jack Lauman <[EMAIL PROTECTED]> wrote on 11/02/2004 11:47:20:
> I have a table containing information about different businesses. I
> want to randomly select a single row from the table using a prepared
> statement in a java bean.
>
> What is the most eficient way to do this?
Try SELECT
Dear Sirs and Ladies,
i'm on the way to create some big indexes on a huge MyISAM-table(13G),
using the 'ALTER TABLE ADD INDEX ..., ADD INDEX ..., ...' -Statement.
After mysql copied all data to the temporary #-Tables it slowes down very
much.
A top shows my that it mostly runs in 'D' (uninterrupt
Hi group,
How can I disable the option of SQL DELETE of data from MySQL4.x database for some
specified tables? Or even for all the database tables?
10X.
SELECT * FROM test ORDER BY RAND() LIMIT 1;
See pp. 694-695 in the MySQL Cookbook.
Eamon Daly
NextWave Media Group LLC
Tel: 1 773 975-1115
Fax: 1 773 913-0970
- Original Message -
From: "Jack Lauman" <[EMAIL PROTECTED]>
To:
> Additionally, it is an accepted fact that MySQL is faster than the
> mighty, mighty PostgreSQL. It is an accepted fact that PostgreSQL
> developers don't lie. The PostgreSQL developers say that they are faster
> than most commercial databases in their normal fsync mode. Therefore, by
> communica
I have a table containing information about different businesses. I
want to randomly select a single row from the table using a prepared
statement in a java bean.
What is the most eficient way to do this?
TIA
Jack
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Matt Mastrangelo <[EMAIL PROTECTED]> wrote:
> I'm using mySQL 4.1.1a-alpha on XP Professional. When I execute a
> create table script containing a COLLATE clause, all LONGBLOB fields are
> silently changed to LONGTEXT in the resulting table. This behavior does
> not occur on version 4.1.0-alph
"Liying Huang" <[EMAIL PROTECTED]> wrote:
>
> I have tried to upgrade mysql to 4.0.17 version, still
> have the same problem. All queries shown in relay-bin
> file at slave, but slave database is not updating. I
> read documentation, but can't find helpful information
> on this.
Do you use any re
Hi,
is it possible to manage the users present in mysql with an ldap
directory ? if yes, where can I find some documentation (I didn't find
it on google) ?
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROT
Chris Nolan wrote:
Martijn Tonies wrote:
Additionally, it is an accepted fact that MySQL is faster than the
mighty, mighty PostgreSQL.
No, it is not. It is an accepted fact that MySQL is faster than
PostgreSQL for certain tasks.
The PostgreSQL developers say that they are faster
than most com
"naveen" <[EMAIL PROTECTED]> wrote:
> Hi
> when i try to put the data(xyz.sql) taken using mysqldump commant
>
> bin/mysql --user=root --password=secret xyz < xyz.sql
>
> ERROR 1005 at line 12: Can't create table './XYZ/Bcl.frm' (errno: 150)
>
> what is this comming,why is it comming.
You can us
Hi,
C:\mysql\bin>perror 150
Error code 150: Unknown error
150 = Foreign key constraint is incorrectly formed
Take care,
Aleksandar
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi
when i try to put the data(xyz.sql) taken using mysqldump commant
bin/mysql --user=root --password=secret xyz < xyz.sql
ERROR 1005 at line 12: Can't create table './XYZ/Bcl.frm' (errno: 150)
what is this comming,why is it comming.
with regards
naveen
I am considering an upgrade on our server from 512 megs of RAM to 1 or
possibly 1.5 gigs, and would like to know if I'm going to get a
significant performance boost. Any suggestions or information is much
appreciated. Our configuration is as follows:
The table has around 100,000 records (but will
"Colin O'Connor" <[EMAIL PROTECTED]> wrote:
> I don't have much experience with MySQL server, but I am working on a
> project which consists of a Java application accessing MySQL databases. The
> program is packaged with the mysqld binary for Windows, and the Java program
> simply executes the bina
Hi
i am able to use mysqldump as
mysqldump --opt xyz >xyz.sql
i got the file xyz.sql.
i put that file in 4.0.17 directory and ran
bin/mysql -e "source path/xyz.sql"
then it say's
' ERROR 1049: Unknown database 'xyz'
if i try to create this database and try to run the command
"Jacque Scott" <[EMAIL PROTECTED]> wrote:
>
> I have a DateTime data type for one of my fields. If an entry is being
> INSERTed then I want the DateTime to be NOW(). I want this done
> automatically and not have to set me SQL str to do this. I have tried
> to set the default as NOW() but it wil
New system, Openserver 5.0.7 with MP1, GNU Devtools, . MySQL 4.0.16
Configure :
CC=gcc CFLAGS="-O3 -mpentium" LDFLAGS=-static CXX=gcc \
CXXFLAGS="-O3 -mpentium -felide-constructors" \
./configure --prefix=/usr/local/mysql \
--enable-thread-safe-client --enable-local
Thanx for the answer,
But the link you gave me is broken :-(
I have FSU-threads version 3.14 installed on that system.
Stefaan
-Original Message-
From: Sean Flynn [mailto:[EMAIL PROTECTED]
Sent: dinsdag 10 februari 2004 23:17
To: Stefaan Van Dooren; [EMAIL PROTECTED]
Subject: Re: MyS
Try ABS()
Terry
--Original Message-
> Hi all,
>
> I m looking for any function or a work around to fetch numerical data
> without its sign (-10 --10, 10 --> 10). Any ideas?
>
> Thanx
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubs
Hi!
For formatted text, you may be able to get away with using FULLTEXT
searches on MyISAM tables, depending on the definition of "formatted".
Regards,
Chris
On Wed, 2004-02-11 at 18:55, Veysel Harun Sahin wrote:
> Hello list,
>
> What is the best way to store and search formatted text?
>
> T
Hi Peter,
> > > * Assuming that my points below regarding performance are correct (I'm
> > > sure that Heikki will stand by InnoDB and back up anyone preaching
it's
> > > performance benefits), the lower hardware costs are an important
factor
> > > (as in lower for a given performance target).
> >
80 matches
Mail list logo
