Hi,
I want to restore the database from the back up of the database taken using
mysqldump.
I took the backup into a .sql file of my wholw database. Now, i want to run that sql
file, i.e i want to recreate the tables/data of that database from the backup of .sql
file. How to do this?.
In article [EMAIL PROTECTED],
Martijn Tonies [EMAIL PROTECTED] writes:
This is plain rubbish. See my other example with a more complicated
view source. When adjusting the view, or extracting a script - the
view source becomes complete gibberish.
MS SQL, or Firebird, for example, store the
Hello Harald, others,
This is plain rubbish. See my other example with a more complicated
view source. When adjusting the view, or extracting a script - the
view source becomes complete gibberish.
MS SQL, or Firebird, for example, store the view-source as defined -
this includes
In article [EMAIL PROTECTED],
Martijn Tonies [EMAIL PROTECTED] writes:
Hello Harald, others,
This is plain rubbish. See my other example with a more complicated
view source. When adjusting the view, or extracting a script - the
view source becomes complete gibberish.
MS SQL, or
Hello Harald, others,
This is plain rubbish. See my other example with a more complicated
view source. When adjusting the view, or extracting a script - the
view source becomes complete gibberish.
MS SQL, or Firebird, for example, store the view-source as defined -
this includes
On 05 Oct 2004 11:46:18 +0200, Harald Fuchs wrote:
Martijn Tonies writes:
MS SQL, or Firebird, for example, store the view-source as defined -
this includes comments, spacing etc etc... In short: it becomes usuable.
MySQL should do this too. From reading these lists, I think MySQL
only
On 05 Oct 2004 12:02:44 +0200, Harald Fuchs wrote:
Martijn Tonies [EMAIL PROTECTED] writes:
I was asking if the view-source can be stored, so that it can be retrieved
the way I created it. Do you agree or disagree?
I disagree. A proper information_schema implementation is much more
than
Great example and my apologies because as you know
we've been down this road before.
Side note - once again I did not provide my acutal
table names , this time they haven't been created as
of yet.
Let me skinny this down though a bit and focus on one
aspect of my design connundrum.
Remember
Hi there,
I am having serious problems with a mysql 4.0.18 production server.
Mysql takes away sometimes almost 100% of the cpu. The system works fine for
days, but then suddenly load average climbes up and up and up till about 17.
This is wat top says:
top - 12:06:47 up 9:50, 2 users, load
Hi there,
I am having serious problems with a mysql 4.0.18 production server.
Mysql takes away sometimes almost 100% of the cpu. The system works fine
for days, but then suddenly load average climbes up and up and up till
about 17.
This is wat top says:
top - 12:06:47 up 9:50, 2 users,
In article [EMAIL PROTECTED],
Jochem van Dieten [EMAIL PROTECTED] writes:
Since the is no requirement to have an accessible DEFINITION_SCHEMA
there may be a mechanism to recreate the definition on the fly from
other information, but the same goes for the other view related base
tables in the
Hello,
I am developing an application that will remotely access a MySQL database
hosted on Interland ISP servers.
This application will be sold to the users without sharing the source code.
The .exe file is build using the LIBMYSQL.LIB library and, when sold, will
have to be accompanied by the
Hello,
I tried to optimize our server according to the hints given in the mysql
manual and some articles I read. To find out whether our system needs
tuning I performed what's written in the manual section 4.6.8.3:
If Key_reads is big, then your key_buffer_size variable is probably
too small.
Hello all,
Can someone tell me the consequences of setting max_connections and
open-files-limit too high? That is, higher than I'd expect to need under
normal circumstances, say 10,000 connections when all I'd expect is less
than 1,000 at any one time. Could a malicious user bring MySQL to its
Hi,
I'm trying to create a table that has 1000 columns, but I keep on getting
Error Code : 1005 (errno: 139). Does anyone has an idea why this happens? I
thought the limit in number of columns was around 3500...
Many thanks,
Filip
I've attached my sql statement as a zipped file as otherwise
I think you are on the right track. All you need to make your new
statement work is a GROUP BY clause. You can either reference your columns
by name or by position.
SELECT P.id,
P.date,
D.browser_decoration,
PD.entry_date
COUNT(PD.*)
FROM Process P
LEFT
IF you have a version of MySQL that is recent enough (4.0+) you can merge
your two queries *when you run them* by using the UNION predicate.
http://dev.mysql.com/doc/mysql/en/UNION.html
Much better than a client-side merge.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
You are correct, there is no predicate you can use to pull the refurl
value from the same row that the MAX(entry) value comes from . That will
require a second processing stage. Depending on what version of MySQL you
are running, you have some options:
*store the results of this MAX() query in
Brent,
You need to modify your BUFFER size on your CMD shell screen. Right click
the title bar then select properties and find the section that talks
about Screen Buffer Size (it's under the layout tab for me). This only
works for me if I use it in a window (not full screen).
I always create
At 9:14 -0400 10/4/04, [EMAIL PROTECTED] wrote:
What you are looking for is the MAX() of the Time column (most recent
entry)
select user, host, max(time) as time, count(user) as visits
from userlog where user!=''
group by user, host
order by time desc
limit 10;
The issue you ran into is caused by
Hi,
In mySQL: 4.0 with out innodb, is there any facility/command to write data
into mutiple tables at a time?.
Thanks,
Narasimha
Confidentiality Notice
The information contained in this electronic message and any attachments to this
message are intended
for the exclusive use of
Hi,
How to create database in mysql 4.0 with out classic. What i mean is
1. How to create database
2. How to create users and hhow to give privilages to them
3. How to create table space
4. How to create rollback segment
5. How to allocate tables to table space
Please help me in
First of all a kind salute to the master yoda of SQL query's Shawn Green :)
He saved me a couple of hours the other day with a linking a table to itself
query !
I've been in the Telecommunications industry for more than 2 years now. I
hope that I can provide feedback any questions regarding DB
(I guess this means it's example-counterexample time)
Business Rule 1: Each store can have up to three managers
Business Rule 2: No manager can run more than one store.
Q1: what kind of relationship is this
a. one to one
b. one to many
c. many to many?
(answer at
Hi,
I am also doing migration from oracle 7.3 to mysql 4.0 classic.
May i know how to handle Oracle Views, stored procedures/triggers in MySQL 4.0 ?.
May i know how to create database, table space, roll back segments, users, allocating
tables to table spaces (as we do in oracle) in
Hi,
What's the best way to run a fulltext search when several fields from a
single table are involved?
I have a database of products with fields for Title, Summary, and
Description. The first two fields are varchar and the third is text. An
FULLTEXT index is created for the Description
Narashimha,
You have been asking too many, very basic questions that are covered in
excellent detail in the online manual. Please do not expect us to do your
research for you.
http://dev.mysql.com/doc/mysql/en/index.html
MySQL is a very well documented product. The online manual is not only
[snip]
How to create database in mysql 4.0 with out classic. What i
mean is
1. How to create database
2. How to create users and hhow to give privilages to them
3. How to create table space
4. How to create rollback segment
5. How to allocate tables to table space
[/snip]
RTFM at
Most database designs do not function well with that many columns, even if
it is possible.
Here is a small chunk of your column definitions:
`ACCHG` double(18,4) default '0.',
`ACCHG_DC` int(2) default '0',
`ACCLI` double(18,4) default '0.',
`ACCLI_DC` int(2) default '0',
`ACCO`
Is there a way to convert the following result set:
id f2
--- ---
1 b
1 c
to:
id f2
-- --
1 b,c
Using a select or any other functions? Basically, I want to put f2 fields together
when ids are the
Kevin Cowley
RD
Tel: 0118 902 9099 (direct line)
Email: [EMAIL PROTECTED]
Web: http://www.alchemetrics.co.uk
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: 05 October 2004 16:03
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Migrating from
At 8:04 -0700 10/5/04, Ed Lazor wrote:
Hi,
What's the best way to run a fulltext search when several fields from a
single table are involved?
You should have a FULLTEXT index for each combination of columns that
you want to use in the MATCH() part.
If you sometimes search Description, and other
Hi,
I have a perl script that connect to mysql using the
following:
my $dbh =
DBI-connect(DBI:mysql:$dbname;host=$host,$dblogin,
$dbpasswd) or die Cannot connect to $dbname: .
$DBI::errstr;
But after I upgraded to 4.1.5 I get the following
error message:
DBI-connect(dbname;host=host) failed:
Hi Narasimha,
I'm pretty new to mysql, only one year doing development in this platform.
As far as I know you will not 've stored procedures/triggers in MySQL 4.0
.รง
Please check the documentation and what is coming in version 5.0
(http://dev.mysql.com/doc/mysql/en/MySQL_5.0_Nutshell.html )
I
Hi everyone,
I'm running windows XP professional and just downloaded the latest binary
installer. I have used MySQL for a while (this is a new install), but for
some reason when I double click the setup.exe icon, I get the following
error message: The system file is not suitable for running
Bob Ramsey wrote:
Thanks for the replies. This appears to be the right answer:
where page_body regexp '.*img .*.*' and page_body not regexp '.*img
.* alt= .*.*';
I don't think so. Here's why:
First, REGEXPs can match partial strings, so the .* is unnecessary at the
beginning and end. Second,
If you have mysql 4.1, you can use GROUP_CONCAT().
SELECT id, GROUP_CONCAT(f2) FROM yourtable GROUP BY id;
See the manual for details
http://dev.mysql.com/doc/mysql/en/GROUP-BY-Functions.html.
Michael
Feghhi, Jalil wrote:
Is there a way to convert the following result set:
id f2
Check out the GROUP_CONCAT() function, see if this help:
http://dev.mysql.com/doc/mysql/en/GROUP-BY-Functions.html
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Feghhi, Jalil [EMAIL PROTECTED] wrote on 10/05/2004 11:20:21 AM:
Is there a way to convert the following
Claire
The Authentication protocols changed with 4.1. If you do a search on the
archive this subject has come up several times. Either upgrade your perl
interface or make 4.1.5 use the old protocol.
Kevin Cowley
RD
Tel: 0118 902 9099 (direct line)
Email: [EMAIL PROTECTED]
Web:
If your MySQL version is 4.1 or later,
you could try GROUP_CONCAT
the query should be ( not tested ):
select id,GROUP_CONCAT(f2) from tablename group by id
regards,
Giulio
Il giorno 05/ott/04, alle 17:20, Feghhi, Jalil ha scritto:
Is there a way to convert the following result set:
id
If you are using an ODBC driver or some other pre-4.1 library to connect
to a post-4.1 MySQL server you can get the message you describe.
Here is some reading about cross-version authentication issues:
http://dev.mysql.com/doc/mysql/en/Problems.html (esp section A.2)
I have had much better luck unzipping the Win32 binaries into their own
folder and updating the my.ini file to match.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Brian Menke [EMAIL PROTECTED] wrote on 10/05/2004 11:32:49 AM:
Hi everyone,
I'm running windows XP
At 8:27 -0700 10/5/04, Claire Lee wrote:
Hi,
I have a perl script that connect to mysql using the
following:
my $dbh =
DBI-connect(DBI:mysql:$dbname;host=$host,$dblogin,
$dbpasswd) or die Cannot connect to $dbname: .
$DBI::errstr;
But after I upgraded to 4.1.5 I get the following
error message:
What build of MySQL are you running? I don't believe an electronic
ignition is included in 4.0 or 4.1.
--bemansell
On Mon, 4 Oct 2004 17:07:07 -0700 (PDT), Don Dachner
[EMAIL PROTECTED] wrote:
Anyone have experience with installing the Dyna III electronic ignition?
I put it on my R80/7, but
For now it take us 12 hours to copy the data by using scp, it will probablly take us
1 week to finish the mysqldump.it takes too long, we dont want do it.
We are not useing any float type columns in our tables, is it still ok to copy?
Thank you!!
--Alex
alex ye [EMAIL PROTECTED] wrote:
Right now on a form I have the instructions below, I'm pretty
comfortable with using PHP.
I'm thinking of replacing the text below with some self-explainatory
radio buttons. Is it as easy as just putting + in front of each word
if all words would be checked. Or if the radio button phrase was
You should be careful to lock the table if you use one statement to count
the rows in the result set and then another statement to build the result
set. Otherwise, there is a chance another user could add or delete a row
that affects the count between the time you run the first statement and the
This is what it says about the ONLY_FULL_GROUP_BY option...
ONLY_FULL_GROUP_BY
Don't allow queries that in the GROUP BY part refer to a not selected column. (New
in MySQL 4.0.0.)
I don't see how this can help me, because in the GROUP BY part I do refer to a
selected
column. The
Ok... I've taken a close look at the various options.
* The use of a temporary table would solve the problem. However, I am very uncertain
of the
efficiency of the use of temporary tables the way you suggest. I would need 6 queries
to the
database, plus creation of a new table based on
Is there a way to have boolean fulltext searches and still have results
automatically sorted in order of decreasing relevance?
It would be nice to enter a search for
+orange -fruit
And have the results come back in order of decreasing relevance.
Thanks,
Ed
--
MySQL General Mailing
Hello people,
I am new in the list!!
I am with a server linux red hat 9.0 with the mysql 4.0 installed server
and usually rotating.Even so I don't get to connect in this server of
another machine Windows that has the client of the mysql 4.0.
Them machine is tied up in net it is obvious.
The only way to know for sure is to try both methods and compare
performance. I have had excellent response times from my temporary
tables (especially since you can add indexes to them). If you would like
some help in crafting some test queries, just post the SHOW CREATE TABLE
results for
Does anything need to be done to my data while upgrading the server from
3.23 to 4.0.21?
Thanks,
Ed
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Tuesday 05 October 2004 01:14 pm, Ed Lazor wrote:
Does anything need to be done to my data while upgrading the server from
3.23 to 4.0.21?
Whats the deal and this list? No one can ever just hit new message, they
always hit reply and put a new subject in..
Geez.. This list is horrible with
I notice the following special tables innodb_monitor, innodb_lock_monitor,
innodb_tablespace_monitor, innodb_table_monitor, and innodb_validate.
The information from the first can be accessed from the MySQL client prompt
with show innodb status without creating the table and watch standard output
Ok. Thank you for all your help! I will perform some tests to see how to get the best
results.
Thank you for offering to help with this stage, but I'll try doing it by myself.
Remi Mikalsen
E-Mail: [EMAIL PROTECTED]
URL:http://www.iMikalsen.com
On 5 Oct 2004 at 14:11, [EMAIL PROTECTED]
Hi there,
I have noticed a few things that cause problems when using table aliases
(SELECT ... FROM table1 t1, table2 t2):
1) Fulltext index queries don't work. I tried to complete a following query:
a)
SELECT p.*, c.name AS categoryname FROM products p, categories c WHERE
You're close. I hit reply to all, typed in a new subject, and then modified
the To field by removing all but the [EMAIL PROTECTED] address.
Come to think of it, I'm hitting reply on this message as well.
What difference are you seeing that makes this significant?
-Ed
-Original
We're not perfectionist like you. :)
-Original Message-
From: Jeff Smelser [SMTP:[EMAIL PROTECTED]
Sent: Tuesday, October 05, 2004 2:23 PM
To: [EMAIL PROTECTED]
Subject: Re: update MySQL
On Tuesday 05 October 2004 01:14 pm, Ed Lazor wrote:
Does anything need to be done
-Original Message-
From: Jeff Smelser [mailto:[EMAIL PROTECTED]
Whats the deal and this list? No one can ever just hit new
message, they
always hit reply and put a new subject in..
Saves having to retype the list address, or look it up. I don't see what
difference it makes...
--
-Original Message-
From: Brian Mansell [mailto:[EMAIL PROTECTED]
What build of MySQL are you running? I don't believe an electronic
ignition is included in 4.0 or 4.1.
It's slated for 5.0, to complement the turbocharger and MegaSquirt support.
--
MySQL General Mailing List
For list
Try this:
select column1, match(column1) against ('+orange -fruit' IN BOOLEAN MODE) as score
from some_table where match(column1) against('+orange -fruit' IN BOOLEAN MODE)
order by score desc
this way you have your results ordered by relevance, and you also get the relevance
value in
the
On Tuesday 05 October 2004 01:55 pm, you wrote:
We're not perfectionist like you. :)
Actually its proper email etticate.. look it up if you don't believe me..
Jeff
pgpjB48FEXyL0.pgp
Description: PGP signature
On Tuesday 05 October 2004 01:56 pm, David Brodbeck wrote:
Saves having to retype the list address, or look it up. I don't see what
difference it makes...
Click on the email, on mine, it brings up a nice to empty message with the
email address..
Jeff
pgp50O9uZVT4t.pgp
Description: PGP
-Original Message-
From: Jeff Smelser [mailto:[EMAIL PROTECTED]
On Tuesday 05 October 2004 01:56 pm, David Brodbeck wrote:
Saves having to retype the list address, or look it up. I
don't see what
difference it makes...
Click on the email, on mine, it brings up a nice to
On Tuesday 05 October 2004 02:23 pm, David Brodbeck wrote:
Well, that's nice...
Hmm
I just don't see what difference it makes. As far as I can see, the
outcome is identical either way...
Cause your doesnt support threads.. Outlook was the only one I knew off that
did not.
Jeff
Jeff,
If you sort it by conversation topic, then it will seem to group by
threads.
I'm running Outlook 2000.
Scott
-Original Message-
From: Jeff Smelser [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 05, 2004 3:36 PM
To: [EMAIL PROTECTED]
Subject: Re: update MySQL
On
-Original Message-
Try this:
select column1, match(column1) against ('+orange -fruit' IN BOOLEAN MODE)
as score
from some_table where match(column1) against('+orange -fruit' IN BOOLEAN
MODE)
order by score desc
this way you have your results ordered by relevance, and you also
On Tuesday 05 October 2004 02:39 pm, Scott Hamm wrote:
If you sort it by conversation topic, then it will seem to group by
threads.
I'm running Outlook 2000.
Seem.. Thats the key word.. Its not true threading support..
These are not there for looks..
References:
[EMAIL PROTECTED]
Hi.
This discussion is very off-topic for this list. Please take the
discussion of how to use your email client off-list.
Thanks.
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-Original Message-
Actually its proper email etticate.. look it up if you don't believe me..
That sounds like a copout. Could present formal references to back this up?
I'm trying to substantiate your claims, but a Google search failed to bring
up anything relevant when searching with
- If you use one word in your search, 1 is a probable score, because all the results
that
appear have the same relevance (they all contain that word!).
- If you use two words, where the second isn't present in all results, you shouldn't
get
relevance value 1 in all results.
- If you use the
Outlook 2003 here and its working just like Scott's (Converation, Subject,
etc.).
-Original Message-
If you sort it by conversation topic, then it will seem to group by
threads.
I'm running Outlook 2000.
Cause your doesnt support threads.. Outlook was the only one I knew off
-Original Message-
- If you use one word in your search, 1 is a probable score, because all
the results that
appear have the same relevance (they all contain that word!).
- If you use two words, where the second isn't present in all results, you
shouldn't get
relevance value 1 in
Ed Lazor wrote:
-Original Message-
Actually its proper email etticate.. look it up if you don't believe me..
That sounds like a copout. Could present formal references to back this up?
I'm trying to substantiate your claims, but a Google search failed to bring
up anything relevant when
Ed,
When you *reply* to a message, most mail clients (including yours) add a
header
like this:
In-Reply-To: [EMAIL PROTECTED]
That stuff in between the and is the message-id of the replied-to
message.
This tells the recipient's email client that your message is a reply, not
a
When I run top after my server has been running for a few days, Mysql is
using 60 or 70MB of memory. When I restart mysql, it goes back to 3000. Any
idea where I should start to look for a problem? What causes this?
I am running RH 7.3 and php/Mysql combo. I don't expect anyone to fix this,
In the last episode (Oct 05), Doug Wolfgram said:
When I run top after my server has been running for a few days, Mysql
is using 60 or 70MB of memory. When I restart mysql, it goes back to
3000. Any idea where I should start to look for a problem? What
causes this?
What are your mysql memory
In the last episode (Oct 05), Doug Wolfgram said:
At 07:35 PM 10/5/2004, you wrote:
In the last episode (Oct 05), Doug Wolfgram said:
When I run top after my server has been running for a few days,
Mysql is using 60 or 70MB of memory. When I restart mysql, it goes
back to 3000. Any idea
79 matches
Mail list logo
