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
>
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.
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,
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
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
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