nil18@stripped wrote on 02/09/2005 10:40:43 AM:
> Hi!
>
> Thanks for that quick answer...
>
> But what are NT file perms ?? Sorry for that dumb question, but I'm very
> new in this.
perms = shorthand for Permissions.
> I tried it at stopped server, stopped service and stopped mysql-nt task.
> But with no success.
Actually, both your laptop service and your PC service should be stopped
before attempting the transfer. (sorry for the incomplete answer)
>
> I read, that there is an mysqldump option.
> With "mysqldump -h localhost -u root -p PASSWORT mydb > mydb.sql" I
> created a backup successfully.
> But with "mysqldump -h localhost -u root -p PASSWORT mydb < mydb.sql"
> another error occured:
> "ERROR 1051 (42S02) at line 19: Unknown table 'autor'"
>
> Is mysqldump the right method for this kind of failure?
>
"failure"? Not sure how you meant that.
mysqldump can create a file containing all of the SQL statements necessary
to recreate one or more databases (if you execute it with the correct
options declared). If you have any tables that are larger than your
destination server's "max_allowed_packet" you need to tell mysqldump how
large that value is for your destination server. If you do not, it will
create insert statements that exceed the allowed value and your SQL script
will fail.
You do not use mysqldump to load data. If you have a valid dump file, one
of the easiest way to load it is to use your mysql client (a command shell
program) to replay the commands in your dump file. You can use the
"source" command to tell it to read your dump file and process its
contents or you can declare your dump file on the command line when you
start the client.
Here is some reading that may help you to understand how those two
programs operate.
(mysql client) http://dev.mysql.com/doc/mysql/de/mysql.html
(mysqldump) http://dev.mysql.com/doc/mysql/de/mysqldump.html
> Thanks for help!
> Regards, Gerrit
Bitte,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
>
> Am Wed, 9 Feb 2005 10:06:32 -0500 schrieb <SGreen@stripped>:
>
> > "Jorge Bastos" <mysql.jorge@stripped> wrote on 02/09/2005 10:03:23
AM:
> >
> >> check NT file perms
> >>
> >
> > ...also verify that your laptop's server is STOPPED before making your
> > image.
> >
> > Shawn Green
> > Database Administrator
> > Unimin Corporation - Spruce Pine
> >
> >
> >>
> >> ----- Original Message -----
> >> From: <nil18@stripped>
> >> To: <dotnet@stripped>
> >> Sent: Wednesday, February 09, 2005 2:48 PM
> >> Subject: InnoDB error
> >>
> >>
> >> > Hi everybody!
> >> >
> >> > I have a big problem!
> >> > I want to copy a database from my Laptop to my Computer.
> >> >
> >> > The Laptop runs with MySQL Server 4.1
> >> > My Computer has MySQL 4.1 -win installed.
> >> >
> >> > All I do is: I go to the "data" directory and copy the whole folder
> > with
> >> > ctrl+c
> >> > Then I paste it on my USB Stick, and put the whole folder on my
> > Computers
> >> > "data" directory.
> >> >
> >> > But when I'm trying to access via MySQL, the following error
occurs:
> >> > ERROR 1016 (HY000): Can't open file: 'autor.InnoDB' (errno: 1)
> >> >
> >> > Please help me! What can I do to make it run?
> >> >
> >> > Thanks a lot, and sorry for my bad english :)
> >> > Greetings from Austria
> >> > Gerrit
> >> >
> >> > --
> >> > MySQL on .NET Mailing List
> >> > For list archives: http://lists.mysql.com/dotnet
> >> > To unsubscribe:
> >> > http://lists.mysql.com/dotnet?unsub=1
> >> >
> >> >
> >>
> >>
> >> --
> >> MySQL on .NET Mailing List
> >> For list archives: http://lists.mysql.com/dotnet
> >> To unsubscribe: http://lists.mysql.com/dotnet?unsub=1
> >>
>
>
>
> --
> Liebe Grüße, Gerrit (aka Nil)
