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
