Wednesday, 17 March 2010
|
| MyISAM index file recovery/writing by hand Sergei Rodionov 18:34:07 |
| | Hi all.
I am desperately seeking advice on quite unusual matter with MyISAM tables.
We have application with very large volume of data being posted into
database at once, and in order to speed process up,
an attempt to write MYD files by hand has been attempted. However, MySQL
wont load such table properly, unless MYI (index) file
is written accordingly. Present recovery tools (myisamchk) are
normalizing database by index, so I cant just put there empty MYI file and
ask for recovery (then I will get empty table, basically). Is there any
recovery tool that restores MYI file by MYD? Or is there any
documentation available somewhere (except for sources) where one can
find how MYI files are organized?
Thanks in advance
Sergei
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| |  2 answer | Add comment |
Monday, 15 March 2010
|
| Change decimal to fraction Warren S. Wyght 22:36:58 |
| | I would like to know how to change a decimal to a fraction for printout
purposes only.
I.E.
34.0625 = = 34 1/16
The number or float in the DB would still be the same but when it is
sent to the front end I would like it to be sent as a fraction to the
nearest 1/16th. Is there a method in MySql to do this?
Thanks
Warren
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org
|
| | 18 answers | Add comment |
Monday, 15 February 2010
|
| Restore Data from deleted DB in MySql Alex 12:32:41 |
| | Hi
I created DB in MySql with name “xxxxx”
I finish fill data to this DB
Next day somebody run any script
And this script removed my DB and created new DB with the same name
How can I get my data back in MySql
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 2 answer | Add comment |
Thursday, 11 February 2010
|
| ib_logfile based recovery Christopher Korn 18:20:08 |
| | Hello everyone,
Today a script killed a few InnoDB tables in my database. Although I have backups (2 days old) I want to recover - if possible - a more current state of my database. Is it possible to recover tables via the "ib_logfileX" files?
If i simply open the files with VIm I can see that much of the data I need is in this file.
Greetings,
Chris
--
--chris [chris@chkorn.de]
Bis zu 70% Ihrer Onlinekosten sparen: GMX SmartSurfer!
Kostenlos downloaden: http://www.gmx.net/de/go/smartsurfer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 2 answer | Add comment |
Tuesday, 9 February 2010
|
| http://virt.voicemessage.com/index.listen.php2=35affv - The webpage you requested - A service of Pag Guest 18:22:59 |
| | A service of PageGetter.com, Inc.
*PageGetter.com Home: http://www.PageGetter.com
*Other Services: http://www.PageGetter.com/services.htm
*Advertise with Us: http://www.PageGetter.com/advertise.htm
*Terms of Use: http://www.PageGetter.com/terms.htm
*Privacy Policy: http://www.PageGetter.com/privacy.htm
*Help: http://www.PageGetter.com/help.htm
This page is brought to you by American Express - Get Blue, the first
Card designed for the 21st Century, with a 0% Introductory APR, no
annual fee, a built-in Smart Chip for Internet security, plus
CoolBlueOffers, BlueLoot (sm) and more. Get approved instantly at
http://by.advertising.com/1/c/33488/14783//41369
________________________________________________
VIRUS ALERT - Monday, June 14, 2004
Our website has been referenced in, without our consent or knowledge, as
part of a virus! Please understand that we had no part in this virus,
and that we are being victimized as much as you are! Voicemessage.com is
in no way involved in the perpetration of this criminal activity.
The virus is called W32.Erkez.B@mm and is also known as W32/Zafi.b@MM.
This is a worm virus that sends e-mails to all the e-mail addresses it
finds on an infected computer and then attempts to overwrite program
files associated with security. You can read more about the virus and
find out how to repair damage at
http://securityresponse.symantec.com/avcenter/venc/data/w32.erkez.b@mm.h
tml
and
http://www.trendmicro.com/vinfo/virusencyclo/default5.asp?VName=PE_ZAFI.
B&VSect=T
<http://www.trendmicro.com/vinfo/virusencyclo/default5.asp?VName=PE_ZAFI
.B&VSect=T>
The virus sends many different types of e-mails, and one of them
references our website, voicemessage.com. Unsuspecting recipients may
open these e-mails, and when they click the link in the e-mail they
unknowingly infect their computer with the virus. Here is the e-mail
that references our website:
To: Jennifer
Subject: You`ve got 1 VoiceMessage!
Attachment: "link.voicemessage.com.listen.index.php1Ab2c.pif"
Message:
Dear Customer!
You`ve got 1 VoiceMessage from voicemessage.com website!
Sender:
You can listen your Virtual VoiceMessage at the following link:
http://virt.voicemessage.com/index.listen.php2=35affv
or by clicking the attached link.
Send VoiceMessage! Try our new virtual VoiceMessage Empire!
Best regards: SNAF.Team (R).
Visit Our Home Page <http://www.voicemessage.com/index.html>
________________________________________________
Please support your PageGetter.com sponsors! - American Express -
http://by.advertising.com/1/c/33488/14783//41369
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org
|
| | 2 answer | Add comment |
Monday, 8 February 2010
|
| ISAM corruption: Error 1033: Incorrect information in file
'/path/x.frm' Brian J.S. Miller 18:32:58 |
| | Hello,
I've read over every archived posting I can find about this problem and
havne't found a solution that seems to work for me.
Here is the deal:
I had a server crash. Hard.
I re-built the server (i686, Debian install, kernel 2.4.18).
I restored the data for 1 database from tapes to use for testing purposes.
The database has 76 tables, all of type ISAM.
To restore the data, I did the following:
1) /etc/init.d/mysql stop
2) cp all files from tape restore (ISM, ISD and frm for each of the 76
tables) to /var/lib/mysql/databasename/
3) chown/chgrp/chmod the new files so they're mysql.root, 0664
4) chown/chgrp/chmod the new directory so it's mysql.root, 0775
5) /etc/init.d/mysql start
The server starts just fine.
~> mysql databasename
I get 66 tables working fine, 9 tables reporting "Didn't find any fields
in table 'admin_privs'" (or whatever the table name is..that's just 1
exaple).
Here is what I have tried already:
1) backing down to Mysql 3.23
2) Running 2.6 kernel (read that ISAMs aren't binary compatible across
OS/platform)
3) CHECK TABLE admin_privs (says: "Incorrect information in file:
'./path/admin_privs.frm')
4) isamchk (says: "isamchk: error: 'admin_privs' is not a ISAM-table")
Does anyone have ANY ideas?! I'm at a complete loss here (and, of course,
getting bashed for not being able to restore from tape).
Thanks,
Brian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 6 answers | Add comment |
|
| Table crashes GuГ°mundur Bjarni Г“lafsson 18:26:04 |
| | Hello,
I'm using MySQL 4.0.12 on RedHat 7.1. I grabbed the binaries off mysql.com
because I was having random table crashes like stated in the download section
for gcc-2.96.*.
When I switched over to the binaries the crashes continued, but now they are
getting pretty violent on one table. The table crashes so badly that I
haven't been able to fix it with myisamchk -r/-o.
Here I paste an example of output from myisamchk:
# myisamchk -o myndir
- recovering (with keycache) MyISAM-table 'myndir'
Data records: 8221
Key 1 - Found wrong stored record at 114103880
Found link that points at 7080077846876182184 (outside data file) at 114104860
Found block with too small length at 114105416; Skipped
Found block with too small length at 114105552; Skipped
Found link that points at 31060663335674065 (outside data file) at 114105756
Found block with too small length at 114106036; Skipped
Found link that points at -1447392181387475218 (outside data file) at
114106100
Found block with too small length at 114106192; Skipped
Found link that points at -1432101689887775058 (outside data file) at
114106208
Found link that points at 770256467916358051 (outside data file) at 114106372
Found link that points at -6654559182842471983 (outside data file) at
114106376
Found link that points at -7674053380346937280 (outside data file) at
114107172
Found block with too small length at 114107440; Skipped
Found link that points at 606174609524421989 (outside data file) at 114107520
Found block with too small length at 114107668; Skipped
Found block with too small length at 114108196; Skipped
Found link that points at -5398872103199542048 (outside data file) at
114108216
....
Found block with too small length at 114123420; Skipped
Found link that points at -4538900753816510448 (outside data file) at
114123552
myisamchk: error: Not enough memory for blob at 114123616
myisamchk: Error writing file 'UNOPENED' (Errcode: 9)
MyISAM-table 'myndir' is not fixed because of errors
Try fixing it by using the --safe-recover (-o) or the --force (-f) option
I'm pretty sure this has nothing to do with disk space or memory, since this
machine has enough of both (approx 20gb free hd, 3gb free of ram). Also, the
datarecords it shows above, are more like 27000.
Can anyone help me fix this. Recovering the files from backup isn't fun to do
2-3 times a day. :/
best regards,
GuГ°mundur Г“lafsson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 8 answers | Add comment |
|
| Repair tables Mike Blezien 18:17:38 |
| | Hello,
What is the recommend alternative to REPAIR TABLE for InnoDB tables, this does
not work with Innodb table types ??
TIA
--
Mike<mickalo>Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Quality Web Hosting
http://www.justlightening.net
MSN Messager: mickalo@thunder-rain.com
Cell:1.985.320.1191 - Office:1.712.737.2548
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 2 answer | Add comment |
Saturday, 23 January 2010
|
| Re: Restore InnoDB data Heikki Tuuri 15:39:31 |
| | Hi!
----- Original Message -----
From: "Lazy70" <s.pulvirenti@katamail.com>
Newsgroups: mailing.database.mysql-win32
Sent: Tuesday, December 16, 2003 4:31 PM
Subject: Restore InnoDB data
Hi to everyone,> Ihave a hard problem to resolve.> In my Mysql database there is sometihng that doesn't work.> With MySQLFront I have all my InnoDB tables with this comment:> "Can't open file: 'certificatetype.InnnoDB'. (errno: 1)"> and in my loog files I read:> 031215 15:33:53 InnoDB error:> Cannot find table test/certificatetyp e from the internal data> dictionary> of InnoDB though the .frm file for the table exists. Maybe you> have deleted and recreated InnoDB data files but have forgotten> to delete the corresponding .frm files of InnoDB tables, or you> have moved .frm files to another database?> Look from section 15.1 of http://www.innodb.com/ibman.html> how you can resolve the problem.> I have read the 15.1 section and I try to delete .frm files, but I can> not be able to see all the tables  > Any body have some tip?
you are probably using a wrong my.cnf or my.ini which makes InnoDB to look
for the ibdata file(s) from a wrong place. The table data is stored in the
ibdata file(s).
Use
dir /s ibdata*
to look where in your computer you have ibdata files, and edit my.cnf or
my.ini accordingly.
Thank you> Ktrl+S
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - hot backup tool for InnoDB which also backs up MyISAM
tables
Order MySQL technical support from https://order.mysql.com/
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org
|
| | 1 answer | Add comment |
|
| Backup and restore problem Peter Blajev 15:38:18 |
| | Hi,
I have two identical machines in terms of OS and software installed (more info
at the end of the message).
I need to dump a database on the first machine and restore it on the second
one.
Here is step by step what I'm doing.
==> on server1
$mysqldump cerberus_database > cerberus_database-dump.mysql
$cat cerberus_database-dump.mysql | mysql cerberus_test
This works!
==> on server2
I coped the dump file to server2. The copy is good, md5 sums match.
$cat cerberus_database-dump.mysql | mysql cerberus_database
ERROR at line 1513:
$
===
Line 1513 is a very long like that starts with this:
INSERT INTO thread_attachments_parts VALUES (185,198,'BM6^^K\0\0\0\0\06\0\...
<cut>
On both servers I have:
OS: Red Hat Enterprise Linux ES release 3
Mysql: mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386)
This is the latest version of mysql that RedHat allows to install with
up2date tool.
I guess the question is why the restore succeed on server1 and fails on
server2.
Any comments and suggestions are highly appreciated.
Thank you
Peter Blajev
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 1 answer | Add comment |
Thursday, 21 January 2010
|
| mysqldump: Error 2013 David Perron 02:42:37 |
| |
Hello - Since recently switching from MyISAM to InnoDB tables in 4.1 on RH
Linux I receive this error when attempting to dump some tables.
mysqldump: Error 2013: Lost connection to MySQL server during query when
dumping table `campaigns` at row: 14721
Any idea what could be causing this?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 16 answers | Add comment |
|
| Connection problem Alec Cawley 02:42:33 |
| | I am getting unexpected results trying to connect to mysql from Java. Up to
now I have been connecting to "localhost", which has worked for development
on my own maching. Now I want to put in the real name of the machine to get
ready for splitting the app and the database. My connection code is as
follows:
(Strings host, userName and password defined - password is the empty
string, others are printed below)
try
{
Class.forName (driverName).newInstance () ;
System.out.println ("Connection to '" + host + "' user '" + userName +
"'") ;
connection = DriverManager.getConnection (host, userName, password) ;
System.out.println ("Connected OK") ;
}
catch (Exception e)
{
System.err.println ("Unable to connect to Database: " + e) ;
System.exit (1) ;
}
Which results in
Connection to 'jdbc:mysql://Dove.Research.Quantel/quantel' user 'quantel'
Unable to connect to Database: java.sql.SQLException: General error: Access
denied for user: '@10.162.63.80' to database 'quantel'
The IP address given in the error message is the ip address from which I am
attempting to communicate with the database. I have given full access
permissions to all users. However, this does not seem relevant because
username I an giving doesn't seem to be getting through.
System details:
Win2K
mysql-connector-java-3.0.1-beta
mysql 4.0.2-alpha-max-nt
What am I doing wrong?
Alec Cawley
---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail java-thread4392@lists.mysql.com
To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail java-unsubscribe@lists.mysql.com instead.
|
| | 44 answer | Add comment |
|
| Euro Symbol (Ђ) Hassan Shaikh 02:42:29 |
| | Hi,
I've inserted the following currecy sumbols in my table (structure mentioned below). All symbols, in CYSYMBOL, are displayed properly when I do select, expect for the Euro symbol, which just shows a question mark (?). Any idea why is it behaving like that? I am using MySQL 4.0.17 on Windows XP Pro.
Ђ Euro
Ґ Yen
Ј Pound Sterling
$ Dollar
+----------+--------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+--------------------------------+------+-----+---------+-------+
| CYRANK | decimal(3,0) unsigned zerofill | | | 999 | |
| CYSYMBOL | varchar(5) | YES | | | |
| CYNAME | varchar(50) | | | | |
| CYCODE | char(3) | | PRI | | |
+----------+--------------------------------+------+-----+---------+-------+
Thanks.
Hassan Shaikh
|
| | 8 answers | Add comment |
Tuesday, 19 January 2010
|
| Cannot start mysqld Guest 16:05:16 |
| | Hi,
Installed mySQL 4.11, initially with success. I then made some changes to
the my.cnf file for optimization purposes and since then I cannot get the
server started again. This happens even if I use my old my.cnf file, the
one that worked before.
It attempts to start myslqd, but then it suddenly ends with "mysqld ended"
message.
The data_directory/hostname.err file reports: Can't find message file
'/usr/local/mysql/share/mysql/english/errmsg.sys'. But the file is in the
directory. I even increased the permissions on the file (777) to see if it
had to do with access rights; such did not help.
Does anyone knows what gives? Can't figure this out.
Thanks,
Boris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 8 answers | Add comment |
Sunday, 17 January 2010
|
| Configure error: no curses/termcap library found Tyler Devereaux 20:33:15 |
| |
Can anyone help me?
I get this whenever I run ./configure --prefix=/usr/local/mysql
"checking for termcap functions library... configure: error: No
curses/termcap library found"
then configure quits. I'm really new to linux, so please give me the
"lamans" version of it ;)
_________________________________________________________________
MSN 8: advanced junk mail protection and 2 months FREE*.
http://join.msn.com/?page=features/junkmail
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <mysql-thread128809@lists.mysql.com>
To unsubscribe, e-mail <mysql-unsubscribe-gcdmg-mysql=m.gmane.org@lists.mysql.com>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
|
| | 2 answer | Add comment |
Wednesday, 13 January 2010
|
| Error 1714. The older version of Mysql Query Browser1.1 cannot be removed. Romyd Misc 13:53:54 |
| | Hi All,
I submitted this query in Mysql Query Browser forum last month and haven't
got any help to fix this, so here I'm submitting this again.
I tried to install mysql query browser 1.1.20 and previous i had version
1.1.6, but every time i try installing i keep getting the following error.
"Error 1714. The older version of Mysql Query Browser1.1 cannot be removed.
Contact your technical support group."
Can someone help me fixing this or can someone tell me how i can install the
previous version, since i couldn't find achieves for query browser on mysql
downloads section. It would be great if I can just install any version of
mysql query browser.
Thanks,
Romy
|
| | 3 answer | Add comment |
|
| load data LOCAL infile to upload to a remote database Rich Lott 13:53:49 |
| | Hi.
I have a MySQL database running on a remote web server.
I have a text data file sitting on my PC here.
I want to get the data from the text file to the database and am having
difficulties! I log onto the database and I'd like to issue
LOAD DATA LOCAL INFILE "c:/thedata.txt" INTO TABLE thetable
..and be done with it, but I get an error 13: can't find file (or can't get
"stat" of file) message.
can anyone help? The manual pages on mysql.com didn't help me.
cheers.
rich
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <mysql-thread127118@lists.mysql.com>
To unsubscribe, e-mail <mysql-unsubscribe-gcdmg-mysql=m.gmane.org@lists.mysql.com>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
|
| | 4 answer | Add comment |
|
| Fatal error: Call to undefined function mysql_connect() in c:\Inetpub\wwwroot\mysqlconnect.php
on l Tony Aldemir 13:53:43 |
| | Hello There,
I am getting the "Fatal error: Call to undefined function mysql_connect()
in c:\Inetpub\wwwroot\mysqlconnect.php on line 2" error when I try to
connect to the MySQL DB using:
<?php
$conn = mysql_connect("localhost", "joeuser", "somepass");
echo $conn;
?>
I have made sure that my PHP.INI file is adjusted to reflect the following:
Uncommented the line "extension=php_mysql.dll" exposing this DLL to PHP.
I added the following line
extension_dir = "c:\php\ext"
I copied the libmySQL.dll to the c:\inetpub\wwwroot folder (I am using the
IIS on this machine, but I have the same configuration using the latest
APACHE Server on my home machine and when It try the same code on that
machine, I get no response showing me the value of the $conn, but I do not
get any error message either). Confusing situation!
I do have the php_mysql.dll in the C:\php\ext folder
Well, none of this seem to matter. I am still getting the error listed
above using IIS .
Here is my setup:
I have MySQL 4.1.13a-nt installed. I am able to run MySQL Admin to add
users, add tables to the TEST DB, add records to the new table via the
command line as well as via the MySQL Query Browser. So I am pretty sure
that my MySQL is installed and working fine.)
I have the MySQL program installed on the default location "C:\Program
Files\MySQL\MySQL Server 4.1" as oppose to changing it to c:\MySQL folder
during the installation. I am hoping that this is not the reason for this
problem, but I am not sure.
I am able to run other non-MySQL related simple PHP code via my browser
just fine.
(Example:
<html>
<?php echo '<p>Hello World</p>'; ?>
and a few other simlar stuff. That all works fine.
But when I use the
<?php
$conn = mysql_connect("localhost", "joeuser", "somepass");
echo $conn;
?>
code it just does not want to work. I get the "Fatal error: Call to
undefined function mysql_connect() in c:\Inetpub\wwwroot\mysqlconnect.php
on line 2" error.
Any help would be greatly appreciated.
Regards,
Tony Aldemir
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org
|
| | 8 answers | Add comment |
Wednesday, 23 December 2009
|
| How long should a check table take? Horizon 16:20:32 |
| | I have a 50 millions row table on NT2K mySQL 4.x
mysql admin seem to lock up when I try to run a
check table `mytable` TYPE=QUICK
What else should I try?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 2 answer | Add comment |
|
| Continual Database Corruption Dale 16:10:18 |
| | Hello,
Sorry if this has been covered, but I've searched the archives with no
results.
I have 2 identical servers running mysql 3.23.54a on RedHat linux 7.2
(custom kernel 2.4.17). One is running as master, one slave using mysql
internal replication.
The primary server has a database where one or more tables get
corrupted almost daily. I don't think it's an extremely busy server,
although it reports an average of ~17 queries per second, 70% of those
being selects, the rest being inserts, and very few updates and
deletes.
One occassion it reported error 127 (corrupted table), other times it
just reports that the index is off and needs repaired.
The slave server seems to get corruption also, but it always seems to
differ from master server's corruption (both row position and number of
errors). Should the slave have the master errors or be error free in
this case?
REPAIR TABLE has always worked, but I'm afraid that it won't someday.
There is no signs of harddrive failure (software raid1) but my best
guess at this point is hardware. What should I look at replacing
first? Or is there a better way to debug this? The master server
needs 24/7 access, so I'd rather not try anything that would cause too
much downtime.
Any pointers and/or suggestions are appriciated.
TIA,
Dale
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <mysql-thread128960@lists.mysql.com>
To unsubscribe, e-mail <mysql-unsubscribe-gcdmg-mysql=m.gmane.org@lists.mysql.com>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
|
| | 1 answer | Add comment |
Friday, 20 November 2009
|
| InnoDB table recovery problem - not beeing able to start database server Ivan Tomasic 16:21:15 |
| | Hi.
Please help.
During long delete operation from one InnoDB table there was PC shutdown due to power supply failure. After that I was unable to start database server so I have started it with set-variable = innodb_force_recovery=4 option and I have dropped all databases with InnoDB tables. Still I am unable to start database server normally. Following is the part of Err file:
030630 11:58:36 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 3895685648
InnoDB: Doing recovery: scanned up to log sequence number 0 3895685632
InnoDB: 1 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 1777810 row operations to undo
InnoDB: Trx id counter is 0 22060800
InnoDB: Starting rollback of uncommitted transactions
InnoDB: Rolling back trx with id 0 22060495, 1777810 rows to undo
InnoDB: Progress in percents: 1InnoDB: Dump of the tablespace extent descriptor:
len 40; hex 0000000000000095ffffffff0000ffffffff000000000004aaaaaaaaaaaaaaaaaa
aaaaaafeffffff; asc .......ДЅ................¬¬¬¬¬¬¬¬¬¬¬¬в–...;
InnoDB: Serious error! InnoDB is trying to free page 32306
InnoDB: though it is already marked as free in the tablespace!
InnoDB: The tablespace free space info is corrupt.
InnoDB: You may need to dump your InnoDB tables and recreate the whole
InnoDB: database!
InnoDB: If the InnoDB recovery crashes here, see section 6.1
InnoDB: of http://www.innodb.com/ibman.html about forcing recovery.
030630 11:58:37 InnoDB: Assertion failure in thread 580 in file D:\mysql-4.0.12
\innobase\fsp\fsp0fsp.c line 2689
InnoDB: We intentionally generate a memory trap.
InnoDB: Send a detailed bug report to mysql@lists.mysql.com
030630 11:58:37 mysqld-max-nt: Got signal 11. Aborting!
030630 11:58:37 Aborting
030630 11:58:37 InnoDB: Warning: shutting down a not properly started
InnoDB: or created database!
030630 11:58:37 mysqld-max-nt: Shutdown Complete
Please help
B.Sc.E.E Ivan Tomasic
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 5 answers | Add comment |
Tuesday, 10 November 2009
|
| Microsoft OLE DB Provider for ODBC Drivers error '80004005' Jeremy Hodges 17:57:51 |
| | Hey Guys,
I just installed MySQL 4.0 and MyODBC 3.51 on Windows XP running IIS.
But when I try to connect to my database with ASPs I get this error:
--------------------------
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/source/experimenting/mysql.asp, line 20
--------------------------
Here is my code:
<%
Set adoDataConn = Server.CreateObject("ADODB.Connection")
adoDataConn.Open "MySQLTest"
%>
Please help! |
| | 14 answers | Add comment |
Wednesday, 20 May 2009
|
| ERROR 1045 (28000): Access denied for user (Using password: YES)
from outside localhost Aron Levy 11:14:54 |
| | Hi good afternoon, i am triying to connect with my company's mysql
server using a client program from shell and I keep receiving the
following answer:
[root@GWTServer ~]# mysql -u user1 -p -h serverCompany.com
Enter password:
ERROR 1045 (28000): Access denied for user 'user1'@'200.93.42.209'
(using password: YES)
[root@GWTServer ~]#
I already checked the user was configured for any host ("%"), the port
3306 is open (checked with nmap), but i dont know what i need to do or
see other variables. I am 100% sure of the passwords i am using for
this users, and i am attaching some info about the database.
Thank you in advance,
mysql> select * from user;
+-----------+--------------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| Host | User | Password | Select_priv |
Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv |
Reload_priv | Shutdown_priv |Process_priv | File_priv | Grant_priv |
References_priv | Index_priv | Alter_priv |
+-----------+--------------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| % | user1 | 5804b8eebr456240 | N | N |
N | N | N | N | N |
N | N | N | N | N
| N | N |
| % | user4 | 6f37d73jsdred201d | N | N |
N | N | N | N | N |
N | N | N | N | N
| N | N |
[root@CompanyServer ~]# nmap -A -T4 my.domain.com
Starting Nmap 4.03 ( http://www.insecure.org/nmap/ ) at 2006-06-07 09:57 VET
Interesting ports on xx.xx.xx.xx:
(The 1653 ports scanned but not shown below are in state: closed)
PORT STATE SERVICE VERSION
21/tcp open ftp ProFTPD 1.2.10
22/tcp open ssh OpenSSH 3.9p1 (protocol 1.99)
25/tcp open smtp netqmail smtpd 1.04
53/tcp open domain
80/tcp open http Apache httpd 2.0.53 ((Fedora))
106/tcp open pop3pw poppassd
110/tcp open pop3 Courier pop3d
111/tcp open rpcbind 2 (rpc #100000)
135/tcp filtered msrpc
139/tcp filtered netbios-ssn
143/tcp open imap Courier Imapd (released 2004)
443/tcp open ssl/http Apache httpd 2.0.53 ((Fedora))
445/tcp filtered microsoft-ds
465/tcp open ssl/smtp netqmail smtpd 1.04
593/tcp filtered http-rpc-epmap
993/tcp open ssl/imap Courier Imapd (released 2004)
995/tcp open ssl/pop3 Courier pop3d
1720/tcp filtered H.323/Q.931
3306/tcp open mysql MySQL 4.1.15
4444/tcp filtered krb524
8443/tcp open http Apache httpd 1.3.33 ((Unix)
mod_ssl/2.8.22 OpenSSL/0.9.7e PHP/5.0.4)
Device type: general purpose
Running: Linux 2.6.X
OS details: Linux 2.6.5 - 2.6.11
Uptime 26.627 days (since Thu May 11 18:56:31 2006)
Service Info: OS: Unix
Nmap finished: 1 IP address (1 host up) scanned in 63.549 seconds
mysql
MySQL Support
Active Persistent Links
Active Links
Client API version 4.1.15
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 5 answers | Add comment |
Saturday, 18 April 2009
|
| Word/Excel XP(2002) cant use MyODBC 2.50.39 Joel D Peshkin 21:26:54 |
| |
Word XP(2002) and Excel XP(2002) cannot use new MyODBC datasources even
though Access XP can on the same machine.
Further, a word document with an existing MyODBC database inserted in
it, when opened in Word XP will successfully access the database.
If the field codes for the (old, working) connection are manually
modified to change the SQL syntax, that still works.
Inserting the field codes to query a database manually from Word XP fails.
The failure in word is a failure to access datasource if the field code
is manually entered, but it provides a message inidcating that it can't
get a list of tables if using the MSQuery "insert database" in Word or
Excel.
I realize this is totally inconsistent, but that't the situation.
Please advise if there are any experiments that I should try.
This is running on Windows 2000, Office XP (2002) and has been observed
on several machines.
---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail myodbc-thread5751@lists.mysql.com
To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail myodbc-unsubscribe@lists.mysql.com instead.
|
| | 1 answer | Add comment |
Wednesday, 4 February 2009
|
| DBDesigner 4 connection problem with MySQL DB Ritu Sinha 03:34:42 |
| | Hi,
I just downloaded the latest version of DBDesigner 4
from fabFORCE.net (v4.0.5.6) and installed it on
Windows. I already have MySQL server installed and
running on my machine. When I try to connect to MySQL
DB, it asks me for the Username (root) and password. I
use the same root password that I use for the MySQL
Administrator (and it works), however, I keep getting
"dbExpress: Invalid Username/password" message. Can
someone please help??
Thanks,
Ritu
Discover Yahoo!
Find restaurants, movies, travel and more fun for the weekend. Check it out!
http://discover.yahoo.com/weekend.html
--
MySQL GUI Tools Mailing List
For list archives: http://lists.mysql.com/gui-tools
To unsubscribe: http://lists.mysql.com/gui-tools?unsub=gcdmm-mycc@m.gmane.org
|
| | 7 answers | Add comment |
|
