I just importa data created by mysqldump using
mysql -u username -p dbname < table
MySQL asks for my password and it's done.
BR,
Fábio Ottolini
----- Original Message -----
From: "Jeff Gannaway" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 21, 2001 1:21 PM
Subject: Copying a ddatabase from one server to another
> Here's my situation....
>
> I've been hosting my sites with one company for over a year and am now
> moving to a dedicated server operated by the same company.
>
> My existing database is large, containing around a dozen tables and over
> 5,000 entries. I want to copy the database structure and data to the new
> dedicated server.
>
> I've already created the new database, but not the tables.
>
> At first I tried copying the files from the database directory on my old
> server to the new database directory. I was able to read them but no
> combination of permissions or ownerships would allow me to insert/update
> the values (even when logged in as the super user).
>
> I found the mysqldump command in the MySQL docs. I created a dump file
> using the following command:
>
>
[EMAIL PROTECTED]
> ysql.com
>
> mysqldump -uUSERNAME -pPASSWORD database > dbBackup.sql
>
> and it created the dump file. I transferred it to the new server then
> tried to load it into my new database using the following command:
>
> mysqldump -uUSERNAME -pMILLER31 database < dbBackup.sql
>
> (I also tried it with the -c option)
>
> I received the following output:
> # MySQL dump 8.12
> #
> # Host: localhost Database: database
> #--------------------------------------------------------
> # Server version 3.23.32
>
> It did not insert any of the tables (and obviously not the data either).
>
> I tried another variation I found in the MySQL docs. I went to the
> original server and entered in the following command:
>
> mysqldump -uUSERNAME -pPASSWORD database | mysql --host=[IP Address of
New
> Server] database -uUSERNAME -pPASSWORD
>
> and I received the following output:
>
> ERROR 1130: Host 'old.server.hostname.net' is not allowed to connect to
> this MySQL server
>
> Any tips???
>
> Thanks,
> Jeff Gannaway
> _______________________________________________________
>
> 2001 Wall Calendars....
> * Art, Jazz, Blues, Women's, African-American.
> * Everyday Discounts.
> * Excellent paper and reproductions.
>
> And as always, a great selection of abstract,
> contemporary and African-American art prints.
>
> PopStreet.com is your avenue to art.
> http://www.popstreet.com
> _______________________________________________________
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
