Free hosting in exchange for help

[Anon]

I need someone who is cabable of pulling information (very small, 20 or so users) from one mySQL db and transferring it to an identical db (already set up) on another web site.

We will give away free hosting for 6 months to the person who can do this for us. If you are interested or just want to help, you can contact us @ [e-mail].

Best,

Matt
http://glowhost.com

[Anon]

why don't you use phpadmin to make a copy the data in a .sql file and then use phpadmin on the other server to put it on the server ?

al

[Anon]

The original DB sits on a different configuration. They require connecting to the DB from a client like mySQL front, so there is no phpmyadmin there. Make sense?

[Anon]

if you have have a shell (or telnet/ssh access to a machine) you can:
dump the DB:
mysqldump --add-drop-table -h hostname -u username -p dbname > dump.sql
(it will ask for the db password)

once you have the file dump.sql you can make it eat to the new db in this way

mysql -h hostname -u username -p dbname < dump.sql
(it will ask for the db password)

of course a db should be prepared in the new mysql installation (but the name havent to be identical)

its a good idea (for migration issue) having same users/dbname on both mysql, and if you can give the new one the cname (or A record) of the old one... so you dont have to rewrite/correct your applications and scripts... just wait for the dns to refresh!

if you work on local machine yo ucan omit -h hostname

if you connect remotely be sure the user you are using can connect remotely to mysql

hope it helps