Re: Help restoring database: MacOS Server (Snow Leopard)

2013-01-10 Thread Jan Steinman
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

Re: Help restoring database: MacOS Server (Snow Leopard)

2013-01-09 Thread Karen Abgarian
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

Re: Help restoring database: MacOS Server (Snow Leopard)

2013-01-09 Thread Reindl Harald
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 >

Re: Help restoring

2005-04-18 Thread Eric Bergen
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.

Re: Help restoring mysql access

2004-04-23 Thread Egor Egorov
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.

Re: Help restoring mysql access

2004-04-22 Thread Egor Egorov
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,

Re: Help restoring data with mysqlbinlog

2002-04-12 Thread Victoria Reznichenko
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

Re: Help restoring data with mysqlbinlog

2002-04-08 Thread Victoria Reznichenko
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

Re: Help Restoring a MySQLdumped database...????

2002-02-25 Thread Georg Richter
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