Moving Sql Database From One Account To Another

[koocha]

Hi

 

I need to move my coppermine SQL database from one hosting account to another one. The thing is, I have no idea what I need to do.

 

Can anybody give me a few pointers?

 

Thanks

 

Tim

Edited August 8, 2006 by koocha

[TCH-JimE]

Hello Tim,

 

Are you moving databases between TCH accounts or from an outside hosting company to ours?

 

If its between TCH accounts, then submit a help desk ticket and ask nicely and they should be able to do this for you. If its from an outsiding hosting company, if they have cpanel, you can move the entire website through a cpanel transfer.

 

If you really want to do this yourself (its not hard) then in your other hosting account, access phpmyadmin and select the database. Then when the fields have come up, click export at the top. When the page appears, under the export column on the left is lots of fields, make sure these are all highlighted. At the bottom should be the ability to save to a faile, make sure its gzipped and click on "ok". A prompt will appear asking you to download and save it to your hard disk.

 

To upload it, its just a matter of using the import button instead.

 

Remember, you will need to copy over all your files because the database does not store the actual pictures.

 

Hope this is of some help

 

JimE

[koocha]

Hello Tim,

 

Are you moving databases between TCH accounts or from an outside hosting company to ours?

 

If its between TCH accounts, then submit a help desk ticket and ask nicely and they should be able to do this for you. If its from an outsiding hosting company, if they have cpanel, you can move the entire website through a cpanel transfer.

 

If you really want to do this yourself (its not hard) then in your other hosting account, access phpmyadmin and select the database. Then when the fields have come up, click export at the top. When the page appears, under the export column on the left is lots of fields, make sure these are all highlighted. At the bottom should be the ability to save to a faile, make sure its gzipped and click on "ok". A prompt will appear asking you to download and save it to your hard disk.

 

To upload it, its just a matter of using the import button instead.

 

Remember, you will need to copy over all your files because the database does not store the actual pictures.

 

Hope this is of some help

 

JimE

 

Hi Jim

 

Thanks for that. It is between TCH accounts but I might have upset them by accidently breaking the AUP, that's why I've got another account now.

 

I'll submit a ticket and see what happens.

 

Thanks

 

Tim

[TCH-Carl]

If its between TCH accounts, then submit a help desk ticket and ask nicely

[TCH-JimE]

Thankyou Carl

 

JimE