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: Changing MySQL host  (Read 4016 times)

0 Members and 1 Guest are viewing this topic.

Terborch

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Changing MySQL host
« on: January 27, 2008, 02:13:48 am »

How do I change the MySQL host without losing everything? This isn't my idea, is't my host server/site idea. They are in the process of adding 14 new servers to there MySQL Grid. The new hardware will considerably increase the speed of the hosting service and make the websites much faster! Any ideas?
Logged

François Keller

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: fr
  • Offline Offline
  • Gender: Male
  • Posts: 9096
  • aka Frantz
    • Ma galerie
Re: Changing MySQL host
« Reply #1 on: January 27, 2008, 05:57:23 am »

do your host move your files to a new server ?
the way to mo to anothe hos is:
backup your database (via php myadmin or the backup plugin)
copy all your coppermine files on your local computer via FTP (using a real ftp tool like filezilla)
upload all your saved coppermine file on your new server
restore your database via phpmyadmin on your new mysql host
modify your include/config.inc file accordingly with the new database acces values.
it's done (normaly  ;))
Logged
Avez vous lu la DOC ? la FAQ ? et cherché sur le forum avant de poster ?
Did you read the DOC ? the FAQ ? and search the board before posting ?
Mon Blog

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Changing MySQL host
« Reply #2 on: January 27, 2008, 09:50:37 am »

If your webhost is moving your database to another server, it's their job to move your database tables there IMO. Ask them to perform the move for you (free of charge of course). All they could possibly ask you for is editing the mysql information in coppermine to reflect the new mysql connection data. To do this, edit include/config.inc.php
Logged

Terborch

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Changing MySQL host
« Reply #3 on: January 27, 2008, 09:21:38 pm »

Well I logged in to see if they have switched me over to the "new" mysql, and they did. So I went ahead to modify that one file. I couldn't, because I don't have that file. Is that a bad thing?
Logged

Nibbler

  • Guest
Re: Changing MySQL host
« Reply #4 on: January 27, 2008, 09:36:30 pm »

You must have an include/config.inc.php. If you didn't then your gallery would not be working.
Logged

Terborch

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Changing MySQL host
« Reply #5 on: January 27, 2008, 10:19:37 pm »

You must have an include/config.inc.php. If you didn't then your gallery would not be working.
Actually It's working just fin even though I don't have that file.
Logged

TigerClaw

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 28
Re: Changing MySQL host
« Reply #6 on: January 27, 2008, 11:48:46 pm »

Actually It's working just fin even though I don't have that file.

Check again you really need that file to just start working on coppermine  ;)
Logged

Terborch

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Changing MySQL host
« Reply #7 on: January 28, 2008, 03:04:01 am »

I looked again and it's not there. But the gallery works like it normally would if it was there.
Logged

Nibbler

  • Guest
Re: Changing MySQL host
« Reply #8 on: January 28, 2008, 09:05:40 am »

Post a link to your gallery.
Logged

Terborch

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Changing MySQL host
« Reply #9 on: January 30, 2008, 08:39:39 pm »

Well, I got to thinking.
Quote
Maybe I really do need that file.
So I uploaded it and nothing happened, then I decided to delete it to see if it still mattered. It did. It's just error messages now. Go check it out & refresh to get both messages. http://nilow-gallery.co.nr
Logged

Terborch

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Changing MySQL host
« Reply #10 on: February 05, 2008, 04:40:52 am »

So does any one care to help me fix this "little" problem you basically help create? You kept telling me I needed it and look at where it got me:
Quote
Coppermine critical error:
Unable to connect to database !

MySQL said: Lost connection to MySQL server at 'reading initial communication packet', system error: 113
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Changing MySQL host
« Reply #11 on: February 05, 2008, 09:24:49 am »

So you're blaming us that your gallery is no longer operational? Come on...
Ask your webhost for support.
Logged
Pages: [1]   Go Up
 

Page created in 0.025 seconds with 19 queries.