Ahhh.... using mysql command instead of mysqldump command to import. It
worked splendidly!
Gracias,
Jeff Gannaway
At 07:21 PM 2/21/01 -0300, Fábio Ottolini wrote:
>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 -----
>
>> 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