Need help moving MySQL db from one server to another

ultranet · **Need help moving MySQL db from one server to another -** 12-25-2006

Hello to all members

I have some qustion
I'm trying to move a db from a shared hosting account to a dedicated server. I exported the DB; but I can't get it to import.

I am using SSL to run bash. This is the first time I have ever done this. If anyone can tell me what the command line is to import the db I'd appreciate it.

thanks in advance..

cheers

softwareprojects · **Re: Need help moving MySQL db from one server to another -** 12-25-2006

Hi Ultranet,

What command are you running? Are you RSHing to run mysqlimport? Are you running mysql and passing a local file?

Please paste the command you are running and the error message you're getting back

xtremeshowup · **Re: Need help moving MySQL db from one server to another -** 12-27-2006

I recommend using phpMyAdmin phpMyAdmin | MySQL Database Administration Tool | www.phpmyadmin.net . This program allows you too work with mysql straight from your browser.

Just Try it out.. It might help.

RS Tom · **Re: Need help moving MySQL db from one server to another -** 12-27-2006

phpMYAdmin is useful, but it can time out if the database is too large. If you're working with a small database that is only a few megabytes, you should be fine.

You can also transfer the database files directly from server to server and initiate repairs on them to fix any index issues.

The command for that follows:

Code:

 
myisamchk *.MYI