urgent : PLEASE HELP - problems with back up and restore

------=_NextPart_000_0019_01C5F06F.FDFC1780
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi,



I'm really desperate on this on.

After struggling with some really weird bugs I finally finished my project.



Buuuuuuuuuuttttt I can't perform a good backup and restore.



I'm using :

MySql 5.0.16-nt (essentials version)

Windows xp

The DB contains tables, vw's and sp's.

It is a very small one and at the moment I don't have any data inside.

The whole backup file size is 100Kb.



1. I backed up my db using mysql administrator.
It created a back up file with all tables, views and sp's, but when I tried
a restore it got errors like.
"Could not handle this statement etc.


2. I tried : mysqldump -uroot -pmypassword dbname > backup.sql
And then mysqldump -uroot -pmypassword newDbName < backup.sql
I didn't get any error.
The shell printed to the screen the backup file completely only without the
table script part.

It Created a backup file only for the tables (why ? a minute ago I did the
backup with the same tool).
But after restoring, the new db was still empty.


3. I tried to restore with mysql > -uroot -pmypassword newDbName <
backup.sql
But I got the same results.





It should be a very simple and basic issue.
Why everything is so hard with mysql ?



Is there any really good and quick forum for mySql ? I posted some new
thread in mysql.com at the past few days but never got answered.



Is it just me or that's the life on the mysql planet ?



I now try this mailing-list. I hope you can help me.



Thanks in advance

Barak








------=_NextPart_000_0019_01C5F06F.FDFC1780--

Re: urgent : PLEASE HELP - problems with back up and restore

On 11/23/05, Barak Mery wrote:
> Hi,
>
> I'm really desperate on this on.
>
> After struggling with some really weird bugs I finally finished my projec=
t.
> Buuuuuuuuuuttttt I can't perform a good backup and restore.
> I'm using :
>
> MySql 5.0.16-nt (essentials version)
> Windows xp
> The DB contains tables, vw's and sp's.
> It is a very small one and at the moment I don't have any data inside.
> The whole backup file size is 100Kb.
> 1. I backed up my db using mysql administrator.
> It created a back up file with all tables, views and sp's, but when I tri=
ed
> a restore it got errors like.
> "Could not handle this statement etc.
>

The way you setup your backup is probably the reason why it won't
work, also check for permissions, its always best to lock everything
before the backup.

> 2. I tried : mysqldump -uroot -pmypassword dbname > backup.sql
> And then mysqldump -uroot -pmypassword newDbName < backup.sql
> I didn't get any error.
> The shell printed to the screen the backup file completely only without t=
he
> table script part.

Check the Manual at:
http://dev.mysql.com/doc/refman/5.1/en/disaster-prevention.h tml
For backup and restore instructions.

> It Created a backup file only for the tables (why ? a minute ago I did th=
e
> backup with the same tool).
> But after restoring, the new db was still empty.
>

There are differences between table and data dump with mysqldump, you
can restore it using mysqlimport in many ways, you'll have to check
the manual for the syntax and specific options for your needs.

> 3. I tried to restore with mysql > -uroot -pmypassword newDbName <
> backup.sql
> But I got the same results.
>

Well, its a strange line you have here, you're at the mysql> prompt or
using mysql.exe at the /bin directory.

>
> It should be a very simple and basic issue.
> Why everything is so hard with mysql ?
>

Please don't flame the use of a program at your FIRST mail to a list
that is dedicated to this same program, its kinda rude.

>
> Is there any really good and quick forum for mySql ? I posted some new
> thread in mysql.com at the past few days but never got answered.
>

I usually answer this list instantly, and still sometimes people
answer before me, so, we have a good knowledge base and a good amount
of experienced users around, but hey, if you have a urgent issue, you
should be searching docs and howtos too, not depending only in human
help that we kindly donate to this program (in my case due to the
amount of time and money it saves me by using MySQL).

>
> Is it just me or that's the life on the mysql planet ?
>

It's you!

>
> I now try this mailing-list. I hope you can help me.
>
> Thanks in advance
>
> Barak
>


Also please TRIM the line returns from your mail, its BIG, annoying
and makes you think twice before scrolling, but that's just a friendly
tip.

Good luck,

--
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=3Dgcdmw-win32@m.gmane.org

Re: urgent : PLEASE HELP - problems with back up and restore

In addition: I've been using scheduled backup project in MySQL
Administrator with version 4.1.14 successfully for about 8 months now,
so, it works...

My system:
Windows XP Pro
MySQL 4.1.14 in 3 different servers, two Win and one Lin
MySQL Administrator 1.1.2 (many bugs corrected)

--
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=3Dgcdmw-win32@m.gmane.org

RE: urgent : PLEASE HELP - problems with back up and restore

I Realy appriciate your kindness and will to help new guy in the field.
After two weeks with no sleep I let myself put out some steam.

Belive me I'm not new in the programming area I'm working mysql/oracle/ for
a few years.
And If working with MySql for two weeks and already found two real bugs,
then there is some problem with the platform.

http://bugs.mysql.com/?id=15091&edit=2
http://bugs.mysql.com/?id=15084&edit=2

maybe You didn't have any problem with mysql administrator by I did.
It is very simple to backup/restore with this tool but it didn't worked for
me. Maybe I did something wrong but I expected to find it out by the error.
In administrator tool you have analyze backup file before restoring, and it
prompt that everything was ok.
Look at the bug section at mysql.com.

That's why that kind of forums/mailing list were made to.

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

Barak




-----Original Message-----
From: Daniel da Veiga [mailto:danieldaveiga@gmail.com]
Sent: Wednesday, November 23, 2005 9:22 PM
To: MySQL Win32 List
Subject: Re: urgent : PLEASE HELP - problems with back up and restore

On 11/23/05, Barak Mery wrote:
> Hi,
>
> I'm really desperate on this on.
>
> After struggling with some really weird bugs I finally finished my
project.
> Buuuuuuuuuuttttt I can't perform a good backup and restore.
> I'm using :
>
> MySql 5.0.16-nt (essentials version)
> Windows xp
> The DB contains tables, vw's and sp's.
> It is a very small one and at the moment I don't have any data inside.
> The whole backup file size is 100Kb.
> 1. I backed up my db using mysql administrator.
> It created a back up file with all tables, views and sp's, but when I
tried
> a restore it got errors like.
> "Could not handle this statement etc.
>

The way you setup your backup is probably the reason why it won't
work, also check for permissions, its always best to lock everything
before the backup.

> 2. I tried : mysqldump -uroot -pmypassword dbname > backup.sql
> And then mysqldump -uroot -pmypassword newDbName < backup.sql
> I didn't get any error.
> The shell printed to the screen the backup file completely only without
the
> table script part.

Check the Manual at:
http://dev.mysql.com/doc/refman/5.1/en/disaster-prevention.h tml
For backup and restore instructions.

> It Created a backup file only for the tables (why ? a minute ago I did the
> backup with the same tool).
> But after restoring, the new db was still empty.
>

There are differences between table and data dump with mysqldump, you
can restore it using mysqlimport in many ways, you'll have to check
the manual for the syntax and specific options for your needs.

> 3. I tried to restore with mysql > -uroot -pmypassword newDbName <
> backup.sql
> But I got the same results.
>

Well, its a strange line you have here, you're at the mysql> prompt or
using mysql.exe at the /bin directory.

>
> It should be a very simple and basic issue.
> Why everything is so hard with mysql ?
>

Please don't flame the use of a program at your FIRST mail to a list
that is dedicated to this same program, its kinda rude.

>
> Is there any really good and quick forum for mySql ? I posted some new
> thread in mysql.com at the past few days but never got answered.
>

I usually answer this list instantly, and still sometimes people
answer before me, so, we have a good knowledge base and a good amount
of experienced users around, but hey, if you have a urgent issue, you
should be searching docs and howtos too, not depending only in human
help that we kindly donate to this program (in my case due to the
amount of time and money it saves me by using MySQL).

>
> Is it just me or that's the life on the mysql planet ?
>

It's you!

>
> I now try this mailing-list. I hope you can help me.
>
> Thanks in advance
>
> Barak
>


Also please TRIM the line returns from your mail, its BIG, annoying
and makes you think twice before scrolling, but that's just a friendly
tip.

Good luck,

--
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=barak.mery@gmail.com


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: urgent : PLEASE HELP - problems with back up and restore

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 < 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=3Dgcdmw-win32@m.gmane.org