[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-win32
Subject:    Re: urgent : PLEASE HELP - problems with back up and restore
From:       Daniel da Veiga <danieldaveiga () gmail ! com>
Date:       2005-11-23 20:40:45
Message-ID: 342e1090511231240q11a96e8lfe68a9b9009af353 () mail ! gmail ! com
[Download RAW message or body]

Finding bugs means nothing... And that's it... You're an experienced
tech, so, I'll suppose you have worked with open source before, and
bugs are part of it. Maybe that's the exact reason why it works, we
find and kill them. I won't even

As to your problem, can you post your table structure? I would like
some more info about the problem, I mean, as far as I could see, you
had a full working MySQL environment, decided to back it up and now
has problems restoring it? Well, one of the first steps described in
every tutorial is to backup the "data" directory, if you did so, its
easy to get back your data and work with it trying to automate your
backup procedure and test it. Else, well, you'll have to work with
what you have (the backup you created with Administrator).

Well, you checked the backup file, its not really big, so, try:

mysql -u root -p -D <database> < backup.sql

If you made a full backup of all databases, then you can even not set
the -D option. You can get errors if you try to restore all tables
when the server is already running (thus using the mysql database).

If you have a non-functional MySQL (because you stated that restoring
it you got empty tables), drop all tables and try restoring it (all
but the mysql database tables, of course).

I wouldn't mind if you posted (at me, privately) the full content
backup file that's generating erros, so I can test it.

Don't get me wrong, but you started kicking MySQL, then I tried to
help and you kicked me AND MySQL again, one more of this:

"> So If don't want to help don't bother answering that kind of messages."

And I won't answer for sure.

--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/win32?unsub=mysql-win32@progressive-comp.com


[prev in list] [next in list] [prev in thread] [next in thread]