Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: MySQL is going to be disabled on my freehost, what to do?  (Read 2169 times)

0 Members and 1 Guest are viewing this topic.

marceln

  • Coppermine newbie
  • Offline Offline
  • Posts: 10
MySQL is going to be disabled on my freehost, what to do?
« 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
Logged

Abbas Ali

  • Administrator
  • Coppermine addict
  • *****
  • Country: in
  • Offline Offline
  • Gender: Male
  • Posts: 2165
  • Spread the PHP Web
    • Ranium Systems
Re: MySQL is going to be disabled on my freehost, what to do?
« Reply #1 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).
Logged
Chief Geek at Ranium Systems
Pages: [1]   Go Up
 

Page created in 0.016 seconds with 21 queries.