[EMAIL PROTECTED] wrote:
Hi,
Thank you for your reply. If I have the create table info in my
dump file, while doing the restore using mysql dbname dump.dmp, I am
getting errors like
mysql -uMNMSDBA -pMNMSDBA -f mnms
c:\progra~1\mitel\opsman~1\temp\almhist.dmp
ERROR 1050 at line 11: Table
Ligaya Turmelle wrote:
I'm a beginner - but can't you also use mysqlimport?
Not in the case when you have made a backup using mysqldump while using
the default options. mysqlimport is a front end for LOAD DATA INFILE
(http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html)
It is usefule when you
Hi there!
I have some problems with the complex MySQL join operations. In most
cases, LEFT JOIN fulfills my needs but sometimes it doesn't work in the
expected way. I'll give an example:
orders
--
- orderid
- customerid
customers
-
- id
- customername
orderitems
--
- itemid
Hi,
one more problem. The database-version above crashes, whenever I try to work
with it. Work means, that I like to look at a table via php-myadmin. In this
moment, the database crashes.
I know that alpha is with bugs, 5.0.0 runs stable so far, but does not
support views...
Thanks for
Joshua,
the stack trace below shows that you are trying to drop a database? Why?
If you can, you should use SELECT ... INTO OUTFILE to save of your tables
what you can save, then rebuild the whole InnoDB tablespace, and import the
tables back to MySQL.
The .err file below starts from a
[snip]
Having a hard time finding a server/host who supports MYSQL 4.1.3 or
above.
Does anyone know and can recommend a host who offers this?
[/snip]
http://www.phpwebhosting.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
[snip]
It is worth it for performance reasons !
[/snip]
Really? What performance stats are you looking at here?
[snip]
And if you believe ASP.NET only provides a few benefits, then you are
adequately informed, my friend
[/snip]
Yes, he is adequately informed...and correct.
--
MySQL General
[snip]
I read 6) as saying that until you complete all of the calculations on a
row, you don't change the data for the row. I could even interpret this
as saying that you don't update ANY row on the table until you have
completed the calculations for ALL of the rows.
I read 7) as saying that you
Hi,
with which options of mysqldump you have taken backup. if you
use --add-drop-table option then it will add drop table statement in dump
file. otherwise it wont add that statement and you will get that type of
errors.
if you didn't use that option then drop the schema and then try to restore
Hi,
after granting privileges did you executed flush privileges command. if not
execute below command and then check
mysql flush privileges;
thanks
Anil
-Original Message-
From: sam [mailto:[EMAIL PROTECTED]
Sent: Monday, January 03, 2005 9:09 AM
To: mysql@lists.mysql.com
Subject:
Hi Heikki,
Please see below...
On Mon, 3 Jan 2005 15:14:12 +0200, Heikki Tuuri [EMAIL PROTECTED] wrote:
Joshua,
the stack trace below shows that you are trying to drop a database? Why?
At that point, I'd heard from our developer of so many problems I
figured what I would do is test things
Joshua,
about dumping tables from a corrupt database, see:
http://dev.mysql.com/doc/mysql/en/Forcing_recovery.html
This describes how to remove the whole InnoDB database:
http://dev.mysql.com/doc/mysql/en/Error_creating_InnoDB.html
Be very careful. You do not want to lose your valuable data.
well, since we were having so many problems with the InnoDB tables, we
created a non-InnoDB version of the database in question...
Basically we want to do whatever it will take to get InnoDB tables
working in our environment. Any assistance you can offer towards this
goal will be greatly
I am very new in mysql, and don't want to disturb users who have much more
expirience with mysql.
Is there any mysql list for newbies??
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.6.6 - Release Date: 12/28/2004
--
MySQL
Joshua,
the problem you had was serious corruption in the ibdata files. It can be
caused by an InnoDB bug, an OS bug, faulty hardware, and also by an error of
the database administrator.
Linux kernels 2.4.18 seemed to have corruption issues.
There are no known corruption bugs of this type in
smime.p7m
Description: S/MIME encrypted message
I did the first 2 step you listed below, but when I typed in the mysql -u
root, I got a new error message
ERROR 2003 (HY000) Can't connect to MySQL server on 'localhost' (10061)
Thanks
David.
- Original Message -
From: Tom Crimmins [EMAIL PROTECTED]
To: David Katz [EMAIL PROTECTED]
Cc:
This error is caused when the server isn't started. Make sure that you start
the server first, then
log in. When you skip the HOSTS.FRM tables (by doing mysqld
--skip-grant-tables), you have to
restart the server normally to effect your changes in the mysql root user.
J.R.
-Original
The program would also need to handle...
...queries that span multiple lines
...change databases when appropriate before queries
yes I could program such a beast but I thought someone else might have
already done it.
daniel
-Original Message-
From: Andy Davidson [mailto:[EMAIL
Hi,
Thank you for your reply. Even though I used the --add-drop-table
option, I am getting the error messages. Actually I am taking the backup
for a group of tables as following
D:\Code\OPS\6.9.1.12\NetMgmt\OPS_src\C_src\backupmnms\Debugmysqldump
-uMNMSDBA -p
MNMSDBA --databases mnms
Do I have to reinstall mysql in order to change the default data dir
from /var/lib/mysql?
Can I do this:
mv /var/lib/mysql /newdir/mysql
cd /var/lib
ln -s /newdir/mysql mysql
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
mysql describe art;
+-+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+-+--+--+-+-++
| id | int(11) | | PRI | NULL| auto_increment |
| parent
Ahhh, you guys are sooo funny - you all know what I mean
-Ursprüngliche Nachricht-
Von: Jay Blanchard [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 3. Januar 2005 14:36
An: Freddie Sorensen; [EMAIL PROTECTED]
Cc: mail.pmpa; mysql@lists.mysql.com
Betreff: RE: AW: [PHP] How to argue
Drop the tables manually then try the restore.
[snip]
ERROR 1051 at line 11: Unknown table 'alarm'
ERROR 1050 at line 12: Table 'alarm' already exists
[/snip]
It seems strange that you get these errors in this order. If you post maybe
the first 15 lines of your dump file, I may be able to
[snip]
Do I have to reinstall mysql in order to change the default data dir from
/var/lib/mysql?
Can I do this:
mv /var/lib/mysql /newdir/mysql
cd /var/lib
ln -s /newdir/mysql mysql
[/snip]
This should work. You could also change the datadir variable in your my.cnf
file instead of creating
Hi,
use the below command to take backup
mysqldump databasename tablename tablename --add-drop-table dump
file name
i tested it on my local server also it is working fine for me. other wise
just open the dump file by executing the below command
on linux:
head -100 dumpfile name
o/p:
--
Hi all,
this has been bugging me for some time now.
I want to do a mysql select
then using php
while ($a_row = mysql_fetch_array($result))
{
do something to get a small portion of the data
}
and that works fine. Then later I need to access $result as a complete array
again. Is there a way I can
At 3:56 PM +0100 1/3/05, Paun wrote:
I am very new in mysql, and don't want to disturb users who have much more
expirience with mysql.
Is there any mysql list for newbies??
No, this is the appropriate list...just make sure you:
(1) first try to search the manual:
http://dev.mysql.com/doc/
Hi,
I have a big table (900k rows, 200M MYD, 200M MYI) with a fulltext index
on it. The table gets corrupted every 1 week or so and I have to repair
it. I've tried upgrading to newer versions of mysql 3 times but the
problem persists. I think it may have something to do with the raid 1
mirror
[snip]
this has been bugging me for some time now.
I want to do a mysql select
then using php
while ($a_row = mysql_fetch_array($result))
{
do something to get a small portion of the data
}
and that works fine. Then later I need to access $result as a complete
array
again. Is there a way I
Hi all ,
I have a question about how to best approach indexing a table with many
variations of fields searched by, but one common ORDER BY field.
Take for example this table (with only relevant searched fields shown):
CREAT TABLE Offers (
bid` mediumtext NOT NULL,
`company_name`
Ian,
are you sure that you copied the complete ibdata1 file to the new place? It
is strange how 7 MB can be missing from the file end.
What does the old .err log contain? Any message about disk space running
out?
The error below probably has not corrupted your tablespace. Best to run
CHECK
http://us2.php.net/manual/en/function.mysql-data-seek.php
This lets you set the internal row pointer of the mysql result. In your case
you would want mysql_data_seek($result,0).
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
-Original Message-
From: julian haffegee
mysql_field_seek( resultset, 0 );
PB
-
julian haffegee wrote:
Hi all,
this has been bugging me for some time now.
I want to do a mysql select
then using php
while ($a_row = mysql_fetch_array($result))
{
do something to get a small portion of the data
}
and that works fine. Then later I need
julian haffegee schrieb:
Hi all,
this has been bugging me for some time now.
I want to do a mysql select
then using php
while ($a_row = mysql_fetch_array($result))
{
do something to get a small portion of the data
}
hi julian,
how about using this snip
$result = mysql_query($sql)or
Mark,
- Original Message -
From: Mark Maggelet [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Monday, January 03, 2005 8:36 PM
Subject: big table corruption
Hi,
I have a big table (900k rows, 200M MYD, 200M MYI) with a fulltext index
on it. The table gets corrupted every 1
I am having areal time trying to get my Open Office to recognize my
MySQL server. I am using the j-connector :
Generally Available (GA) 3.0.6
I have this installed in my path $HOME/java.
I have notified the tools-Options-Security-ClassPath.
but I still keep getting an error:
A driver is not
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jay Scherrer wrote:
I am having areal time trying to get my Open Office to recognize my
MySQL server. I am using the j-connector :
Generally Available (GA) 3.0.6
I have this installed in my path $HOME/java.
I have notified the
Frederik,
I may be losing my mind, but I don't think I am according to your show
index, you have multiple indexes on the same fields which is absolutely
worthless and actually makes things slower.
For example, id, which you have as primary should not have any other indexes
on it, but with the
Thanks Heikki,
check table gives me this:
mysql check table resourcesback;
++---+--++
| Table | Op| Msg_type | Msg_text |
[snip]
I may be losing my mind, but I don't think I am according to your show
index, you have multiple indexes on the same fields which is absolutely
worthless and actually makes things slower.
For example, id, which you have as primary should not have any other indexes
on it, but with the
There are some unnecessary indexes though. These include id_2 and 1st. This
is because id_3 is an index on (id,parent,date) and id_2 is and index on
(id,parent). The way mysql uses indexes, id_3 will work for (id),
(id,parent), and (id,parent,date). The same is true of the '1st' index. This
is
WOW!
This is a really bad bug...
mysql SHOW INDEX FROM LITERAL;
+-++--+--+-+---+-+--++--++-+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation |
Cardinality |
Kevin A. Burton wrote:
WOW!
This is a really bad bug...
So now only that... but check this out:
mysql SELECT * FROM LITERAL WHERE VALUE = 'Law';
+--+---+
| ID | VALUE |
+--+---+
| 14076840 | Law |
+--+---+
1 row in set (0.00 sec)
Which only returns ONE
Hi,
This could also be a badly corrupted table, what does CHECK TABLE / REPAIR
TABLE report ?
Regards,
Jocelyn
- Original Message -
From: Kevin A. Burton [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Monday, January 03, 2005 10:04 PM
Subject: MySQL 4.1.7 allows non-unique values
At 12:37 PM 1/3/2005, you wrote:
Hi,
I have a big table (900k rows, 200M MYD, 200M MYI) with a fulltext index
on it. The table gets corrupted every 1 week or so and I have to repair
it. I've tried upgrading to newer versions of mysql 3 times but the
problem persists. I think it may have
Jocelyn Fournier wrote:
Hi,
This could also be a badly corrupted table, what does CHECK TABLE / REPAIR
TABLE report ?
Thats next on our list... going to take care of that tonight.
Kevin
--
Use Rojo (RSS/Atom aggregator). Visit http://rojo.com. Ask me for an
invite! Also see irc.freenode.net
Hi there,
I create a large table with the following command
CREATE TABLE MyTable(
ID int unsigned not null,
Description longtext,
index(ID),
foreign key (ID) references MainTable (ID) on delete cascade
);
alter table MyTable max_rows = 200;
Then if I do
I really appreciate your help :)
I did some cleanup of my indexes(there are a couple of them left to
clean out but it takes so long time):
mysql show index from
art;
Could some one enlighten me about the differences between these 2 mysql
products?
Thanks
Juan M. Quiroz
Oregon Department of Agriculture
Systems Analyst
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Juan,
MAXDB is a totally different product, more akin to the corporate
databases like Oracle, Informix, Sybase etc. A description from the
mysql web site ( www.mysql.com )
MaxDB(tm) by MySQL
For the most demanding enterprise applications, MySQL offers MaxDB by
MySQL. Formerly known as SAP
I am making my first attempt to access MySQL with Perl
#!/perl
use warnings;
use strict;
use dbi;
my $dbh=DBI-connect( 'dbi:MySQL, 'user', 'pass' ) or die Cannot connect
- !br$DBI::errstr;
and I get the following error:
Can't connect to data source dbi:MySQL, no data driver
Try something like this:
use DBI;
my $driver = mysql;
my $server = myhost;
my $database = mydb;
my $url = DBI:$driver:$database:$server;
my $user = username;
my $pass = password;
my $dbh = DBI-connect($url, $user, $pass)
|| die Couldn't connect to database:
Hi Gerald,
Check your syntax, I can't see the hostname or database name in your
connect statement. I have a statement similar to that below. Note the
hostname and database.
my %err_handle = (
PrintError = 1,
RaiseError = 1
);
$dsn =
Logan, David (SST - Adelaide) wrote:
Hi Juan,
MAXDB is a totally different product, more akin to the corporate
databases like Oracle, Informix, Sybase etc. A description from the
mysql web site ( www.mysql.com )
MaxDB(tm) by MySQL
For the most demanding enterprise applications, MySQL offers MaxDB
Hi Kevin,
Lucky its not IBM, they have Cloudscape, DB2, Informix, Unidata,
Universe, Redbrick and a few others that I can't remember. Did you say
only 2? 8-)
Regards
David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61
Thanks Mike,
It's hardware raid, but I don't know the manufacturer. I could try to
find out but if the problem is the hardware there isn't much I can do
about it anyway without turning it into a big project.
I'm not really expecting to solve this, I'm just hoping for some advice
on what the
Random hardware failures will NOT only impact a single file.
The only thing that I know that will consistantly fail at the same spot is s/w.
On Mon, 03 Jan 2005 16:32:31 -0800, Mark Maggelet
[EMAIL PROTECTED] wrote:
Thanks Mike,
It's hardware raid, but I don't know the manufacturer. I could
Hi,
I have mysql-4.0.18 installed and entered data with UTF-8 characters.
When I use a Select command, mysql doesn't sort the data correctly which
starts with native Turkish letters. Is there a way to fix it?
Thanks..
--
Erol YILDIZ
HEV Schools Kemerkoy
http://www.kemerkoy.k12.tr
--
MySQL
59 matches
Mail list logo