Am 14.08.2012 09:42, schrieb Bob Sauvage:
> Hello *,
>
> My INNODB database has a size of 80GO. I've a replication setup on 3 slaves
> and I backup my db from them.
> If a problem occurs on the database, a recovery from a dump takes around 6H !
> That's too long for us.
>
> 2 ideas :
> 1.
Step # 1 : Stop mysql service
# /etc/init.d/mysql stop
Step # 2: Start to MySQL server w/o password:
# mysqld_safe --skip-grant-tables &
Step # 3: Connect to mysql server using mysql client:
# mysql -u root
Step # 4: Setup new MySQL root user password
mysql> use mysql;
mysql> update user set pas
I actually get the feeling you are not connecting as root.
Try mysql -uroot -p test instead of just mysql test
Have a nice day,
- Martijn
On Wed, Aug 26, 2009 at 03:02, Joe wrote:
> OK, thanks, that got me in. But upon inspection, the user.host
> values do not look fouled up as I thought they w
When you are in without the flag , issue the following:
Select current_user();
It should return root.
Then do this:
Grant all privileges on *.* 'root'@'%' identified by 'letmein'
It should work If you did not mess too much with grant tables.
Claudio
Il giorno 26 ago, 2009 4:36 m., "Todd Lyons"
>> On Wed, Aug 26, 2009 at 02:12, Joe
> wrote:
>> > We have an inaccessible MySQL v5.0.45 DB (w/Innodb) we
>> > really need some help regaining access to. While attempting
>> > to adjust/add remote user access, we accidentally did the
>> > following:
>> >
>> > use mysql;
>> > update user set hos
OK, thanks, that got me in. But upon inspection, the user.host
values do not look fouled up as I thought they were (it appears
the bogus update may have aborted). But my access problem
remains
If I start with --skip-grant-tables, 'show databases' shows all
DBs. But without that flag, I only
You have to reset the permissions.
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
Carlos
On 8/25/2009 7:12 PM, Joe wrote:
We have an inaccessible MySQL v5.0.45 DB (w/Innodb) we really
need some help regaining access to. While attempting to
adjust/add remote user access, we
Hey Joe,
stop the server, start it with --skip-grant-tables, change the root
entry in mysql.user to your liking, and then restart the server
without --skip-grant-tables.
viola!
Walter
On Wed, Aug 26, 2009 at 02:12, Joe wrote:
> We have an inaccessible MySQL v5.0.45 DB (w/Innodb) we really
> nee
Gleb Paharenko wrote:
> Hello.
>
> REPAIR TABLE ... USE_FRM helps in difficult cases. See:
> http://dev.mysql.com/doc/mysql/en/repair-table.html
>
Thanks Gleb. I'd forgotten about that option.
To others who try the same thing - make sure you have enough space in your
TMPDIR or set
TMPDIR/
try
REPAIR TABLE 'tablename'
Gleb Paharenko wrote:
>Hello.
>
>
>
>REPAIR TABLE ... USE_FRM helps in difficult cases. See:
>
> http://dev.mysql.com/doc/mysql/en/repair-table.html
>
>
>
>
>
>
>
>
>
>
>
>Per Jessen <[EMAIL PROTECTED]> wrote:
>
>
>
>>All,
>>
>>
>
>
>
>>I've got a table wit
Hello.
REPAIR TABLE ... USE_FRM helps in difficult cases. See:
http://dev.mysql.com/doc/mysql/en/repair-table.html
Per Jessen <[EMAIL PROTECTED]> wrote:
> All,
> I've got a table with about 25mill rows that was victim of a crash recently.
> (power-failure).
> I've been trying t
Per Jessen wrote:
> I've got a backup of the table, but I'm not sure what sort of state
> it is in.
Correction - no backup is available. This table has got to be recoverable.
--
/Per Jessen, Zürich
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
Not a bad suggestion... but when I try it, I get the following output:
Checking MyISAM file: theTable
Data records: 22906970 Deleted blocks: 0
myisamchk: warning: Table is marked as crashed and last repair failed
- check file-size
myisamchk: error: Size of indexfile is: 2049552384Sh
On Wednesday 06 April 2005 20:05, jon wrote:
> Normal recovery seems to grab 490 rows... but, originally there were
> some 22 million rows in there.
Seems your data file was corruped too not only the indexes. and probably broke
when updating the 491st registry... try use myisamchk -e
-e, --ext
Mailinglist
Subject: Re: Recovery in MySql
On 1/29/03 5:13 AM, "Inbal Ovadia" <[EMAIL PROTECTED]> wrote:
> Hi All,
> I have MySql on Windows.
> Today i had an electrical power interruption in the middle of working.
> The database remain not consistent and i could
On 1/29/03 5:13 AM, "Inbal Ovadia" <[EMAIL PROTECTED]> wrote:
> Hi All,
> I have MySql on Windows.
> Today i had an electrical power interruption in the middle of working.
> The database remain not consistent and i could not continue working with it.
>
> Is there any Recovery after crash mechanis
Hello Inbal,
Wednesday, January 29, 2003, 4:13:24 PM, you wrote:
IO> Hi All,
IO> I have MySql on Windows.
IO> Today i had an electrical power interruption in the middle of working.
IO> The database remain not consistent and i could not continue working with it.
IO> Is there any Recovery after cr
-Original Message-
From: Martin Waite [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 28, 2002 3:19 AM
To: Manuel Villasante
Cc: '[EMAIL PROTECTED]'
Subject: Re: Recovery with binary logs.
Hi Manuel,
On Tue, 2002-11-26 at 21:38, Manuel Villasante wrote:
> Hi,
>
> I h
Hi Manuel,
On Tue, 2002-11-26 at 21:38, Manuel Villasante wrote:
> Hi,
>
> I have a few questions regarding recovery of a database using binary logs.
>
>
> 1) If you have a set of binary logs in your directory mylog-bin.001 to
> mylog-bin.nmp, is there an easy way to find out which logs you nee
Massimo,
Friday, November 22, 2002, 2:59:38 PM, you wrote:
MB> I'd want to backup my database. Which is the best method between mysqldump and
copying the /usr/local/var directory?
For InnoDB tables take a look at InnoDB Hot Backup software (non-free). It is a must
to have on a production box. W
Dobrý den,
sexta-feira, 22 de novembro de 2002, 10:59:38, napsal jste:
MB> I'd want to backup my database. Which is the best method between mysqldump and
copying the /usr/local/var directory?
MB> Thanks, Massimo.
you use InnoDB ? the best and fast metod to backup your InnoDB
databases is usin
I have been told that once deleted you can not get the data back (can some
one correct me)...
Have you got all your update logs or binary logs? If you have you should be
able to run the sql quires form there and so just recreate your data!
This mite be stating the obvious but like any data base th
Elekes Attila wrote:
>
> Steve Ruby wrote:
>
> > Elekes Attila wrote:
> > >
> > > Hi!
> > >
> > > The mysql server (version 3.22.32-4) has hanged up, and the restarting
> > > causes a part of the
> > > *.ISM and *.ISD files are gone. Unfortuanetly, I have not got a backup
> > > from these files
Steve Ruby wrote:
> Elekes Attila wrote:
> >
> > Hi!
> >
> > The mysql server (version 3.22.32-4) has hanged up, and the restarting
> > causes a part of the
> > *.ISM and *.ISD files are gone. Unfortuanetly, I have not got a backup
> > from these files :(
> > Is there any method to recover the my
Elekes Attila wrote:
>
> Hi!
>
> The mysql server (version 3.22.32-4) has hanged up, and the restarting
> causes a part of the
> *.ISM and *.ISD files are gone. Unfortuanetly, I have not got a backup
> from these files :(
> Is there any method to recover the mysql tables from the remaining
> *.M
25 matches
Mail list logo
