forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: marceln on July 24, 2007, 07:48:56 am

Title: MySQL is going to be disabled on my freehost, what to do?
Post by: marceln on July 24, 2007, 07:48:56 am
Hello , This is my position:

Ive got properly working gallery on one of free hostings. Galerry size is of about 1300MB. The problem is , that my freehost is going to shut down mysql support becouse of big server loads.

I really dont want to move my site, it would be really difficult to move 1300MBs of photos, and even worse - all the users of my gallery would need to register again. And all the groups i have created in my gallery would dissapear.

So my questions are:
Is it possible to do this? :  I will make backup of my present MySQL database. I will upload it to some other hosting, or some sql service. And then to force my present gallery to begin working with this moved SQL? And what is more important: How to do this? How to make gallery to work with SQL placed at the other server.


Thank you
Title: Re: MySQL is going to be disabled on my freehost, what to do?
Post by: Abbas Ali on July 24, 2007, 08:00:19 am
I really dont want to move my site, it would be really difficult to move 1300MBs of photos, and even worse - all the users of my gallery would need to register again. And all the groups i have created in my gallery would dissapear.

Moving 1300MB data is definitely difficult. BUT moving the gallery to another host will not require your users to register again. All users, photos and groups are preserved if moved properly.

Quote
Is it possible to do this? :  I will make backup of my present MySQL database. I will upload it to some other hosting, or some sql service. And then to force my present gallery to begin working with this moved SQL? And what is more important: How to do this? How to make gallery to work with SQL placed at the other server.[/i]

Yes, this is possible. You can make a backup of current sql and import that sql to the new mysql host. You will need to edit include/config.inc.php and change the mysql host name, username and password. Ofcourse your new mysql host should allow the remote connections (i.e. from your free webhost to mysql host).