forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: Terborch on January 27, 2008, 02:13:48 am

Title: Changing MySQL host
Post by: Terborch 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?

Title: Re: Changing MySQL host
Post by: François Keller 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  ;))

Title: Re: Changing MySQL host
Post by: Joachim Müller 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

Title: Re: Changing MySQL host
Post by: Terborch 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?

Title: Re: Changing MySQL host
Post by: Nibbler 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.

Title: Re: Changing MySQL host
Post by: Terborch on January 27, 2008, 10:19:37 pm

Quote from: Nibbler 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.

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

Title: Re: Changing MySQL host
Post by: TigerClaw on January 27, 2008, 11:48:46 pm

Quote from: Terborch on January 27, 2008, 10:19:37 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  ;)

Title: Re: Changing MySQL host
Post by: Terborch 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.

Title: Re: Changing MySQL host
Post by: Nibbler on January 28, 2008, 09:05:40 am

Post a link to your gallery.

Title: Re: Changing MySQL host
Post by: Terborch 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

Title: Re: Changing MySQL host
Post by: Terborch 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

Title: Re: Changing MySQL host
Post by: Joachim Müller 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.