G'day Cameron
> Of course MySQL stores dates in -MM-DD
> whilst filemaker uses DD-MM- and so when I import my delimited text file
> MySQL interprets the dates incorrectly. I can't seem to find a way of
> changing the date format in Filemaker,
This can be done easily (we do it every
Its got nothing to do with the hardware :)
maybe u are not having any records in the table
or there is something amiss in the table or
feild or database names across both machines.
not a valid mysql result resource is 100% an
program-db related error.
you can try to port the entire databse f
--- Reçu de VITEUR.BUNTERMA 04 72 96 57 77 30/05/02 08.17 -
I found this link the other day which may have some interesting examples :
http://php.resourceindex.com/Complete_scripts
think I saw a Shopping cart section but haven't investigated it yet.
Matt
-
dear support:
i am a user of innodb,but today i meet a big problem.
i am copying all innondb table to the other disk,then in progressing ,i
interupt the command.
now the mysql couldn't start.
now the error below:
020530 12:33:54 mysqld started
020530 12:33:56 InnoDB: Database was not s
Hi Dan...
Oracle gives me the option for Varchar2(900)...
But mysql stops me at varchar(255)...
Is there any other alternate other than blob and text if i want that field t
contain around 1000 characters...
-Arul
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "Arul" <[EM
dear support:
i am a user of innodb,but today i meet a big problem.
i am copying all innondb table to the other disk,then in progressing ,i
interupt the command.
now the mysql couldn't start.
now the error below:
020530 12:33:54 mysqld started
020530 12:33:56 InnoDB: Database was not
GlacierPlease Be KIND...
Good Day,
I will attempt to give you as much information about the software as I can
before I ask the question(s).
My computers OS is Win98 SE.
I have downloaded MySQL Version 3.23.45 for Win 98 and, have installed it to
my machine. I have also downloaded and, installe
In the last episode (May 30), Arul said:
> I am trying to port my oracle Databse to mysql. I am using 3.23.49
> version of mysql.
>
> i had certain columns in oracle which had varchar2(900)
>
> But in mysql varchar doesnt support more than 255
>
> so what could be the alternate in this case..
>
Hi All
I am trying to port my oracle Databse to mysql.
I am using 3.23.49 version of mysql.
i had certain columns in oracle which had varchar2(900)
But in mysql varchar doesnt support more than 255
so what could be the alternate in this case..
Can i use Blob or text..But again if i use blob a
I'm told that one cannot write an Update Query with a Join in MySQL.
Does anyone know if this is true?
Thank you for your help
Joe
Joseph W. Cherner, President
SmokeFree Educational Services, Inc.
http://www.smokefree.org
"Never doubt that a small group of thoughtful citizens can change the w
I'm new to MySQL, and just installed the latest production release
on Win 2K. I have a few questions on users and privileges, please
help me understand.
First, when MySQL starts as a service, what user and password
does it use to access the database?
I created a MySQL account, should I change
On Tue, May 21, 2002 at 10:41:51AM -0400, walt wrote:
>
> Thanks for your reply Jeremy!
>
> I'm an Oracle person, so I tend to think of things being in multiple
> files/tablespaces.
Right.
> Do you know if there is a way to view the rollback stats?
I checked the InnoDB monitor (details in the
You might find this article helpful
Building an E-Commerce Site Part 1: Building a Product
Catalog
http://www.devshed.com/Server_Side/PHP/Commerce/Commerce1/page1.html
olinux
--- Jay Blanchard
<[EMAIL PROTECTED]> wrote:
> [snip]
> Is it possible to create your own shopping cart
> program with
On Thu, May 23, 2002 at 10:17:33AM +0200, Per Andreas Buer wrote:
> Hi.
>
> I've got an database-server with 768MB RAM running
> MySQL/InnoDB. There is quite a lot of I/O activity - about
> 7Mbytes/s. I am not quite sure why there is so much I/O - maybe the
> indexes won't fit into memory?
>
> I
If you can load the data into MySQL, put the date field into a CHAR(10)
field. After the data load, add a date field using ALTER TABLE. You
should then be able to run something like
UPDATE TABLE tablename SET NewDate
= CONCAT(
RIGHT(OrigDate,4),
Hi,
I have been using MySql very successfully on Linux for the past 1.5 years.
(a lethal combination)
This morning when I tried to login using MySqlFront, it seems that my
password has been changed. I was able to login to the server and restore it,
using the root password.
Upon further inspection
I considered perl but it is quite some time since I used it so I had been
wondering if there was a way do what I wanted from within MySQL. Having
said that it has taken about an hour for me to relearn some perl tricks and
get the problem sorted so perhaps I should have just tried straight off
ins
At 23:45 +0100 5/29/02, Cameron Murdoch wrote:
>Hi all,
>
>I apologise if this question has been asked recently; I have checked the
>list archives and could not see anything. This is my problem:
>
>I am trying to convert and import a fairly convoluted Filemaker Pro 5
>database to MySQL. I have e
On Wed, May 29, 2002 at 11:58:06AM -0600, Weaver, Walt wrote:
>
> when MySQL 4.0.2 will be out? We'd like to play around with InnoDB's
> autoextend feature on v.4.
On what platform? If you're on FreeBSD or Linux, I can send you one
of my daily builds. Sice you're just looking to play around, yo
You should try echoing out mysql_error() to see what error is being returned from
MySQL or run mysql from the command line on your laptop and run the same query that
your script is running.
HTH
--Sam Masiello
On Wed, 29 May 2002 20:35:33 -0400 (EDT) "Eric P. McDonough" <[EMAIL PROTE
Hello -
I am running MySQL 3.23.33 with Apache 1.3.19 and PHP 4.0.4PL1 on
a DELL Latitude C600 Laptop developing a project. However every time i try
to use mysql_num_rows it tells me that this is not a valid mysql result
resource. I've tried all kinds of differnt tricks to try to fix the
>Description:
`./configure --with-mit-threads` fails to compile vio/ and innodb/ due to
missing -I directives for pthread.h.
>How-To-Repeat:
in my particular case:
./configure --prefix=/usr/local/mysql/ --with-named-z-libs=z --without-libwrap
--with-mit-threads
gcc -DHAVE_CONFIG_H -I. -
>>If you start MySQL server from MS DOS prompt as:
>> C:\mysql\bin>mysqld-nt --standalone --debug
>>
>>mysqld shows you warning message.
hi! i tried this already.. but whenever i type
mysqld-nt -install to install mysql as a service.. an
error messge "Failed to install service" occurs..
usi
> OI!!! I'm going to sound like a complete ass now (I know) But since
> when does MySQL support FOREIGN keys?? *gasp* MAN this is going to
> make my life S much easier *curses at phpMyAdmin for not having the
> option*
Do remember that this is only valid for mysql 3.23.50+
Do you have any experience with Perl? Perhaps a quick script would convert your tab
delimited files to the proper format?
Bradley
Cameron Murdoch wrote:
> Hi all,
>
> I apologise if this question has been asked recently; I have checked the
> list archives and could not see anything. This is my
Hi
I am using mysql 3.2133b, Sun Solaris 2.6, JHTML and Apache. I have
been getting Time-out requesting db connectionUnable to connect to
database server where url was jdbc:z1MySQL://localhost:3306 error whenever
the JHTML is initialized for the first time. It works fine when i click on
the refr
Hi all,
I apologise if this question has been asked recently; I have checked the
list archives and could not see anything. This is my problem:
I am trying to convert and import a fairly convoluted Filemaker Pro 5
database to MySQL. I have exported the filemaker records as tab delimited
files a
> CREATE TABLE parent(id INT NOT NULL,
> PRIMARY KEY (id)) TYPE=INNODB;
>
> CREATE TABLE child(id INT, parent_id INT,
> INDEX par_ind (parent_id),
> FOREIGN KEY (parent_id) REFERENCES parent(id)
> ON DELETE CASCADE) TYPE=INNODB;
OI!!! I'm goin
Hi,
I am evaluating InnoDB's Foreign Keys and am stuck.
Using the sample tables I want to add records in the Child table with a NULL
parent_id (this being referenced to the Parent table) as follows:
CREATE TABLE parent(id INT NOT NULL,
PRIMARY KEY (id)) TYPE=INNODB;
CREATE TABL
See:
http://www.mysql.com/doc/P/r/Problems_with_alias.html
Gurhan
-Original Message-
From: Massimo Colurcio [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 29, 2002 5:09 PM
To: mySQL List
Subject: Alias & WHERE
It seems I cannot use an alias in WHERE clause, but I can use it in ORDER
On Wed, May 29, 2002 at 02:06:19PM +0300, Heikki Tuuri wrote:
> Jeremy,
>
> it looks like this crash can happen if you use MySQL 'user level locks'
> which are kind of semaphores. In that case MySQL will write a binlog entry
> even after THD::cleanup where the transaction handle is freed.
>
> >F
Hi,
It's more comfortable(and sure) if you use C API of MySQL.Order of (few of
the main) functions to be executed is :
mysql_init-initialise MYSQL struct
mysql_options-set options for connection
mysql_real_connect-this function make all for you, from connection
The thing is I'm looking for a solution with guaranteed transaction success. I have
thought about building a layer that would guarantee transaction success. Say I had
two duplicate databases and if a transaction failed on one it would still succeed
on the other. Once the transaction failed it shou
"hitesh_mittal"@itginc.com wrote:
>I am using MYSQL ++.
>Hitesh
>
>
>
Then, I would suggest posting your question over on the plusplus list
(see http://www.mysql.com/documentation/lists.html), as the developers
for MySQL++ hang out over there.
-Mark
---
It seems I cannot use an alias in WHERE clause, but I can use it in ORDER BY.
An examples:
this doesn't work
SELECT field1 AS ABC, field2 AS XXX, field3 AS QQQ FROM mytable WHERE ABC =
'abc' ORDER BY ABC
this works
SELECT field1 AS ABC, field2 AS XXX, field3 AS QQQ FROM mytable WHERE
field1 =
I dont think the types of tables will really help you, because as I understand it
mySQL doesnt yet have stored procs, views, and sub-selects, regardless of table type...
I may be wrong though...
Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073
"Help Wanted. Seeking Telepat
> -Original Message-
> From: Richard Davidson [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 29, 2002 1:31 PM
> To: MySql List; [EMAIL PROTECTED]
> Subject: FYI: @@IDENTITY
>
>
>
> I don't know if this is just weirdness on my system but I
> thought I would
> pass this on in case a
Greetings guys,
Special greetings to all of you who helped me in the last question, one
last
one
in a timestamp field, do I have to provide the values?
eg
create table ryan(t_imestamp timestamp(8), name varchar(30));
how do I insert? do I have to specify the value? if so how do I g
"hitesh_mittal"@itginc.com wrote:
>Hi
>I am using
>-mysql 3.23.59,
>- Solaris 2.6
>the program is in C++, using gnu C 2.95.3 .
>The table does have primary key constraint and the program should throw an
>exception when I try to insert and the the row aready exists, But instead It
>crashes.
>Any s
Has anyone architected an oltp database using mysql where downtime is
virtually eliminated? I understand it's fairly simple to set up a readonly system
using mysql replication or another type of replication to maintain the
uptime, but I have yet to see how to do this with a heavy transaction
syst
I don't know if this is just weirdness on my system but I thought I would
pass this on in case anyone runs into this problem. I'm converting some
Java/JDBC code from a commercial DBMS to MySQL. The existing code executed
the SQL statement "Select @@identity" after an INSERT to retrieve the
autoi
manual_Reference.html#CREATE_TABLE
>create_definition:
> col_name type [NOT NULL | NULL] [DEFAULT default_value] [AUTO_INCREMENT]
>[PRIMARY KEY] [reference_definition]
create table MyTestTable(cno int AUTO_INCREMENT, name varchar(20));
can't seem to find the ref right now, but
< i
Hi
I am using mysql 3.2133b, Sun Solaris 2.6, JHTML and Apache. I have been
getting Time-out requesting db connectionUnable to connect to database
server where url was jdbc:z1MySQL://localhost:3306 error whenever the JHTML
is initialized for the first time. It works fine when i click on the ref
Hi list, can someone here give me a quick and dirty example of how there
connecting to a database via sockets? I see the data in the man page
but I'm uncertain as to implementation. Thanks, justin
Sql,query
-
Before posting,
Hi guys,
Does anyone have any thoughts on using MySQL for a datawarehousing application?
Problems I've run in to are with mining data from a data warehouse because of the lack
of sub-selects, stored procs, and views.
Should I be looking more at InnoDB or MyISAM table types?
any thoughts are a
Hi
I am using
-mysql 3.23.59,
- Solaris 2.6
the program is in C++, using gnu C 2.95.3 .
The table does have primary key constraint and the program should throw an
exception when I try to insert and the the row aready exists, But instead It
crashes.
Any suggestions ??
Thanks
Hitesh
"Thi
Hey there,
I know this might sound like a stupid question to a lot of you guys out
there but please keep in mind I come from an oracle background and am new to
this:
I am accessing MySql from PHP, I have two questions regarding Auto_Increment
1) how to create an auto_increment?
create table MyT
sql> reset master;
Ric
- Original Message -
From: "Iago Sineiro" <[EMAIL PROTECTED]>
To: "MySql Mail List" <[EMAIL PROTECTED]>
Sent: Wednesday, May 29, 2002 6:14 PM
Subject: Can I remove innobd binarie files?
> Hi all.
>
> In the innodb directory I have these files (prototipo is the n
"hitesh_mittal"@itginc.com wrote:
>Hi All,
> I am new to MySQL ( using on Solaris )
> I wrote my first program to do the insertions in a table. If a row is already
>there then the program crashes instead of just throwing an exception.
>I have a catch (... ) handler also so I am sure that the Qu
Hi All,
I am new to MySQL ( using on Solaris )
I wrote my first program to do the insertions in a table. If a row is already
there then the program crashes instead of just throwing an exception.
I have a catch (... ) handler also so I am sure that the Query.Execute
("Insert.." ) is not thro
Hello,
We currently have two MySQL server/clients running on a RH/Linux 6.2 box,
3.23.40(production) and 3.23.49(development) We would like to setup the .49 with
a TCP/IP host instead of a socket. The .49 is using the port 3307, the default
server hostname is justlightening.justlightening.net(216
I have the following table;
++--+++
| id | wtn | dueDate| ageAmt |
++--+++
| 1 | 210-212-3871 | 2001-12-01 | 0.51 |
| 2 | 210-212-3871 | 2001-12-01 | 0.49 |
| 3 | 210-212-3871 | 2001-12-01 | 0.50 |
| 4 |
Hi All,
I am new to MySQL ( using on Solaris )
I wrote my first program to do the insertions in a table. If a row is already
there then the program crashes instead of just throwing an exception.
I have a catch (... ) handler also so I am sure that the Query.Execute
("Insert.." ) is not throw
I was hoping for some help with this -- I'm not sure if I can use just
one SQL statement to pull this data out, I think I need to use two
separate statements. Can someone clarify for me?
My tables:
+-+ +---+
| people | | projects |
+-+
Hello,
I'm using InnoDB tables, is there a way to know which foreign key constraint
was violated? Oracle gives me the constraint name in the error message, so
that I can seek in the data dictionary. I'm porting an web application
developed for Oracle to MySQL, so I need a solution with the smalle
SELECT cols FROM tbl INTO OUTFILE '/someflie';
ollie wrote:
>
> Does anyone have a way to export data from a table into a tab delimited text
> file? Can't seem to see the option in mysqldump.
>
> For bonus points - how could I achieve this via PHP?(!)
>
> TIA,
>
> ollie
>
>
Hi,
This error make reference to a variable which is not correctly defined.I
suppose that you have in routine which make "import" a variable like :
Dim myvar as lon
insted
Dim myvar as long
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e
Hello,
I created a blank table in MS Access 2000 for recieving data from mysql
and tried to compile importsql.txt in Access module but I still got the
error saying "user defined-type not defined". I copy pasted exportsql.txt
to the module and got the same error.
I have a coworker who told me sh
I've been trying to solve this problem for a couple of days now.
I've only started with DB's a month ago so I am no expert in SQL.
So, I present this problem to you guys in hopes of getting a solution.
Thanks in advance,
Mike
=
Question:
=
Using the query below I get the result
when MySQL 4.0.2 will be out? We'd like to play around with InnoDB's
autoextend feature on v.4.
Thanks,
--Walt Weaver
Bozeman, Montana
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http:/
Hello,
Can someone tell me what is the difference between MyODBC and iODBC?
My understanding is that in order for an application to be able to "talk" to
a database it needs a "protocol", and that protocol would be ODBC.
What I'm trying to do is have the Tango2000 application server
(www.witan
* Andy Cheng
> I am trying to learn about indexing and have a few questions.
>
> 1. Does index only apply to query that use = operator in the where clause?
No.
> 2. Does operators such as >, like and between will result to full table
> scan?
No. LIKE "%whatever%" will not use the index, but LIK
Hi all.
In the innodb directory I have these files (prototipo is the name of the
computer):
-rw-rw 1 mysql mysql 86 May 28 09:56 prototipo-bin.001
-rw-rw 1 mysql mysql 86 May 28 10:00 prototipo-bin.002
-rw-rw 1 mysql mysql 86 May 28 10:13 prototipo
[snip]
Is it possible to create your own shopping cart program with just mySQL and
PHP?
[/snip]
Yep.
[snip]
1) I am trying to build my own shopping cart. When building an orders
database, is it possible to make room for an infinite number of items in the
order?
[/snip]
Ideally you should have t
I have an application database that I'm unable to drop after a period of running
several applications against that are using the MySQL++ api.
Wondering if anyone has seen this, if it's a known bug and/or if there is a fix.
mysqladmin -uroot -p drop and rm -rf /var/lib/mysql/ do succesfully
re
Hi,
I am new to this list and new to mySQL and PHP so please excuse the
simplicty of my questions.
Is it possible to create your own shopping cart program with just mySQL and
PHP?
Right now I am building a database for my companies new web page. I am
looking to build an e-commerce site, but I pr
Hi,
I am trying to learn about indexing and have a few questions.
1. Does index only apply to query that use = operator in the where clause?
2. Does operators such as >, like and between will result to full table
scan?
3. For example, In the following table:
tbl_A
id int primary key
I am trying to compile MySQL 3.23.49 on the following system:
Compaq Tru64 Version 5.1 1885 alpha
gnu gcc 3.1
make 3.79
I keep getting the error shown below. Any trouble shooting insight will be
greatly appreciated.
Thanks
Dean
mv -f .libs/mf_cache.lo mf_cache.o
(cd . && ln -s mf_cache.
* BUNTER MATTHEW
> I'm putting together a table that has dates of reign for a monarch.
>
> What I eventually want to do is to be able to ask the question :
>
> Who reigned during 1585? And get an answer of : King Joe
>
> This info will be outputted in a php form on a web page.
>
> So if the da
Hi,
mysql_fetch_row returns a MYSQL_ROW, that is an array of byte strings.
look at
http://www.mysql.com/doc/C/_/C_API_datatypes.html
Frederic
- Original Message -
From: "Michael Flora" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 29, 2002 5:32 PM
Subject: Problem wit
> I'm looking for a way to create a table with a ID columns (PRIMARY KEY)
> generated automatically...
> The only probleme is that i cannot use a AUTO_INCREMENT field because I
have
> thousand of lines added each day (and all lines older than a week are
> deleted)With AUTO_INCREMENT, one
Michael Flora wrote:
> Hello all, I posted this question yesterday but received no feedback
> so I decided to ask again.
>
> I am new to MySQL and I am trying to access binary data stored in a
> MySQL table using a C program. The table looks like this:
>
>
> date date
> double firstfield
> dou
[snip]
I have a randomly ordered table. And I want to SELECT that table
by ORDERing it in specific row, and when I'm done I want to
find out numeric position of a raw where the first raw is 1, second is 2
etc.
Of course I could iterate over each row. But I want to do it for a
specific raw only. A
--- Reçu de VITEUR.BUNTERMA 04 72 96 57 77 29/05/02 17.27
2nd attempt.
Date: Wed, 29 May 2002 17:17:25 +0200
Subject: Re: Dates in a table
Your message cannot be posted because it appears to be eith
This query seems to be quite easy, but I still cannot figure
out how to do it.
I have a randomly ordered table. And I want to SELECT that table
by ORDERing it in specific row, and when I'm done I want to
find out numeric position of a raw where the first raw is 1, second is 2
etc.
Of course
Hi list!
I have a problem when trying to read data into tables with LOAD DATA LOCAL
INFILE.
I get this error:
ERROR 2013: Lost connection to MySQL server during query
When looking at the MySQL site it says that I should increase the
max_allowed_packet=# option (default 1M). However, my file is
Hello all, I posted this question yesterday but received no feedback so
I decided to ask again.
I am new to MySQL and I am trying to access binary data stored in a
MySQL table using a C program. The table looks like this:
date date
double firstfield
double secondfield
double thirdfield
My
You can use timeval struct and create a field in your Database as double,
and then use these two value tv_sec, and tv_usec to build you PK.
Hisseine
- Original Message -
From: "Jonathan Pelletier" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 29, 2002 10:45 AM
Subj
- Original Message -
From: "Anton" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 29, 2002 3:51 PM
Subject: MySQL not connecting over 110
> Hallo
>
> I cant use phpMyAdmin, or any of my other (php) pages as I get the
> error cannot connect to MySQL via 110 (111)
Well,
Since I did the backup with a |, it appended. I had to go through the file
and remove the older instances of the backups and then it worked ok.
Thanks for the help! You all saved me.
Scott
-Original Message-
From: D.K.Dubey [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 29, 2002 9:14
Hi,,
I'm looking for a way to create a table with a ID columns (PRIMARY KEY)
generated automatically...
The only probleme is that i cannot use a AUTO_INCREMENT field because I have
thousand of lines added each day (and all lines older than a week are
deleted)With AUTO_INCREMENT, one day or a
Christopher,
Wednesday, May 29, 2002, 5:18:25 PM, you wrote:
CLW> ok. my admin guy installed the linux rpm of mysql. however, i can't locate
CLW> the mysqladmin and mysql bins. do i have to install an additional rpm that
CLW> include those?
Yes, you should install MySQL-client package. You can f
Peter,
Tuesday, May 28, 2002, 7:10:28 PM, you wrote:
PE> How can I do a fulltext search on several tables
PE> with just one SQL query?
You can use full-text search in boolean mode on several tables without
full-text index.
SELECT * FROM table1, table2 WHERE MATCH(table1.column1,
ok. my admin guy installed the linux rpm of mysql. however, i can't locate
the mysqladmin and mysql bins. do i have to install an additional rpm that
include those?
Luke
-
Before posting, please check:
http://www.mysql.com/m
Hi,
I am about to set up a network which has a central "main" server, and
several (up to 30) "shop" servers (it is for a retail chain). I'm intending
to link install mysql on all of them and link them up using the method
described below. What I'd like to know is (a.) Can anyone see a fatal flaw
Hallo
I cant use phpMyAdmin, or any of my other (php) pages as I get the error
cannot connect to MySQL via 110 (111)
I had this in the past and what I did then was to check if mysql.sock
was in the temp directory (or a link to it)
I do see it there now but I cant seem to get any connection to M
You wrote::
deleted my database today by mistake and I have a backup from yesterday
made as follows:
mysqldump -A >> backup.txt
How can I restore this database?
Thanks for your help in advance.
Scott
Do get the backup write the command
mysql databasename < backup.txt
Regards
Daya Krishan
You should be able to do this:
mysql < backup.txt
-Original Message-
From: Hathaway, Scott L [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 29, 2002 8:49 AM
To: Mysql (E-mail)
Subject: database restore - please help
I deleted my database today by mistake and I have a backup from yeste
Hi Chris,
See the code how load BLOB into a MySQl
String saveSql = "INSERT INTO Table (DataCol) VALUES (?)"
try {
bos = new ByteArrayOutputStream();
oos = new ObjectOutputStream(new BufferedOutputStream(bos));
fileObj.writeObjectData(oos);
oos.
I deleted my database today by mistake and I have a backup from yesterday
made as follows:
mysqldump -A >> backup.txt
How can I restore this database?
Thanks for your help in advance.
Scott
-
Before posting, please check:
Jeremy,
Actually support is something I would like to explore. As of current,
Yahoo! does not have an active support contract with MySQL so we should
remedy that soon. Although I believe Yahoo receives our highest level of
support because of the tight relationship, we should at a minimum get bo
Victor,
Wednesday, May 29, 2002, 12:01:31 AM, you wrote:
VSA> Tells a great deal about how confused I am...
VSA> I've a database with three tables, one with image data, one with
VSA> categories and one table which helps me to have several categories per
VSA> image...
VSA> The following SQL gi
Peter,
Wednesday, May 29, 2002, 4:39:52 AM, you wrote:
PM> I have just installed mysql 3.23.49 onto my Mandrake installation using the RPMs.
PM> How can I get the mysql server to start as the PC is booting ??
If you installed MySQL server from RPMs mysqld should automatically
run at the boot ti
ddd,
Thursday, May 30, 2002, 12:10:07 AM, you wrote:
d> I have a question,
d> is possible to search on mysql 4.0 in fulltext index
d> the exact phrase ?
"Phrase search" will come in 4.0.2...
d> thanks
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email
On Wed, May 29, 2002 at 02:10:07PM -0700, ddd wrote:
> I have a question, is possible to search on mysql 4.0 in fulltext
> index the exact phrase ?
http://www.mysql.com/doc/F/u/Fulltext_Search.html suggests that it is
possible. Here is the relevant excerpt:
The boolean full-text search capabilit
Hello
I have a question,
is possible to search on mysql 4.0 in fulltext index
the exact phrase ?
thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (t
Christian,
It's pretty easy, you can do it with a normal INSERT statement, all
you've got to remember is that NUL (ascii 0) needs to be escaped as
"\0", and that double quotes and single quotes should also be escaped
(i.e. \" and \').
Getting the data back again is even easier, because it'll une
Hello Outthere!
Maybe this is a very simple question, but I'm a Rookie so lets see. I've tried to load
BLOBs into my MySQL-DB, but I could not find a documentation how to do this. How can I
load a BLOB, for example a PDF-File from my local filesystem into the database (which
SQL-commands do I
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: "ritu singla" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, May 29, 2002 2:31 PM
Subject: Re: Log Files in InnoDB (MySQL)
> Ritu,
>
> the ib log files contain records of every change to database pages in the
>
Hi!
On May 23, Przemyslaw Popielarski wrote:
> "Sergei Golubchik" <[EMAIL PROTECTED]> wrote:
> > > 1 row in set (0.00 sec)
> >
> > Works fine for me (that is "No rows" - and no bug).
> > Probably, it's one of numerous fulltext-related bugs that were fixed
> > since 4.0.1 release.
>
> Will you fi
1 - 100 of 122 matches
Mail list logo
