Okay, panic over. I recursively stripped the ACLs and things are working.
Next time I drop a table from phpMyAdmin, I'll carefully read the little thing
that pops up saying I'm about to drop an entire database... :-( One gets so
"yea, whatever" to warning notifiers...)
Thanks to all who sent he
Hi,
It is not very surprising that the database cannot recover from a Time Machine
backup. This generally applies to any software that is running at the moment
the backup is taken. The InnoDB is especially sensitive to taking what is
called a 'dirty' backup because it has a cache. You ma
Am 09.01.2013 16:33, schrieb Jan Steinman:
> I accidentally dropped a crucial database. My only backup is via Apple's Time
> Machine.
>
> First, I stopped mysqld and copied (via tar) the database in question from
> the backup. Restarted, but drat -- most of the tables were apparently using
>
I accidentally dropped a crucial database. My only backup is via Apple's Time
Machine.
First, I stopped mysqld and copied (via tar) the database in question from the
backup. Restarted, but drat -- most of the tables were apparently using
innodb's ibdata1 file, as only the MyISAM tables showed u
Can one of these columns have binary data in it? If so that could
explain what the garbled text is. Although it should still
export/import correctly. My guess is that somewhere beteween > file
and < file file became corrupted. Try dumping it again. If possible
check that table to make sure it's ok.
I have backed a bugzilla database using:
mysqldump -u root -p bugs > bugzilla.20050418 and am trying to import it on
a new mysql server using
mysql -u root -p bugs < bugzilla.20050418
I'm getting
ERROR at line 84:
Line 84 is all garbled text...
Working with 3.23.58 ... Any thoughts?
--
Patr
Thursday, April 22, 2004, 9:21:35 PM, Dave Dennis wrote:
DD> Is there a procedure to follow for this exactly, step by step?
Yes.
DD> Its on a running production server, don't want to lose data.
Note:
If you run MySQL server with --skip-grant-tables option, MySQL will not use privilege
tables.
Dave Dennis <[EMAIL PROTECTED]> wrote:
> Dear MySQL list,
>
> Managed to create a problem where:
>
> mysql > use mysql;
>
> ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'mysql'
>
> Need a procedure to follow / documented steps to restore root's access
> to database mysql,
Dear MySQL list,
Managed to create a problem where:
mysql > use mysql;
ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'mysql'
Need a procedure to follow / documented steps to restore root's access
to database mysql, version 4.0.17 .
Kind regards,
+
Victoria,
b> Thanks for replying. How does one know what parameter to pass on as
b> "position", in other words how do I know from what point to start the
b> roll-forward from the binlog? What's more what format is this parameter?
b> (timestamp, integer??)
Binary logs are now used mostly for re
Victoria,
Thanks for replying. How does one know what parameter to pass on as
"position", in other words how do I know from what point to start the
roll-forward from the binlog? What's more what format is this parameter?
(timestamp, integer??)
Thanks,
Balteo.
P.S. I tried "mysqlbinlog --help" b
I am trying to restore some data from the binary log and I am not sure on
b> how to proceed.
b> I understand restoring data is a two-stage process:
b> 1. You start by restoring data saved with mysqldump.
b> 2. Using mysqlbinlog, you restore the data logged in the binary log from the
b> point wh
Hello all,
I am trying to restore some data from the binary log and I am not sure on
how to proceed.
I understand restoring data is a two-stage process:
1. You start by restoring data saved with mysqldump.
2. Using mysqlbinlog, you restore the data logged in the binary log from the
point where
On Monday, 25. February 2002 17:47, Miretsky, Anya wrote:
> How do I restore a Mysqldump of a database? I've found documentation on how
> to backup a db and have done but I can't figure out how to create a new db
> from my dump file? Please help.
1) Create an empty db "yourdb"
2) mysql -uuser -pp
How do I restore a Mysqldump of a database? I've found documentation on how
to backup a db and have done but I can't figure out how to create a new db
from my dump file? Please help.
thanks
Anya Miretsky
Computer Technology Dept.
Brooklyn Botanic Garden
1000 Washington Avenue
Brooklyn, NY 11225
15 matches
Mail list logo
