Changing MySQL host

[Terborch]

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?

[François Keller]

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  )

[Joachim Müller]

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

[Terborch]

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?

[Nibbler]

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

[Terborch]

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.

[TigerClaw]

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 

[Terborch]

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

[Nibbler]

Post a link to your gallery.

[Terborch]

Well, I got to thinking.

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

[Terborch]

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:

Coppermine critical error:
Unable to connect to database !

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

[Joachim Müller]

So you're blaming us that your gallery is no longer operational? Come on...
Ask your webhost for support.