[Solved]: Migration questions

[Understudy]

Hi ,

I have some question that have been addressed but I don't have a complete understanding of the issues.
So I will ask some questions to help me avoid some mistakes.

I have a coppermine gallery at http://www.brendhanhorne.com/coppermine_dir/index.php.

It is currently running on FreeBSD 6.3 with:
mysql-client-4.1.22 Multithreaded SQL database (client)
mysql-server-4.1.22 Multithreaded SQL database (server)
php4-mysql-4.4.8    The mysql shared extension for php
php4-4.4.8          PHP Scripting Language (Apache Module and CLI)
php4-gd-4.4.8       The gd shared extension for php
php4-mysql-4.4.8    The mysql shared extension for php
php4-pcre-4.4.8     The pcre shared extension for php
php4-xml-4.4.8      The xml shared extension for php

I have run out of disk space and will be moving it to a new server with the same address when done.
The new server is running FreeBSD 6.3 with:
mysql-client-5.0.51a Multithreaded SQL database (client)
mysql-server-5.0.51a Multithreaded SQL database (server)
php4-mysql-4.4.8    The mysql shared extension for php
php4-4.4.8          PHP Scripting Language (Apache Module and CLI)
php4-gd-4.4.8       The gd shared extension for php
php4-mysql-4.4.8    The mysql shared extension for php
php4-pcre-4.4.8     The pcre shared extension for php
php4-xml-4.4.8      The xml shared extension for php

The Version of coppermine on the first server is 1.4.16. I will use the same version on the second. These servers are run by myself.

I have read http://coppermine-gallery.net/demo/cpg14x/docs/faq.htm#moveGallery.

And now for my questions.
In reading about the migration of dbs from Mysql 4.1 to 5.0 frequent comments on changing the default encoding from latin 1 to utf-8 are made.

Should I make this language encoding change to the db I use for my coppermine gallery?
If yes , should I change tables, rows, and columns?

I am not using phpadmin(no room on disk). I was planning on using a command line mysql dump.
In new server create database name:
mysql > copperminedb
In old server:
mysqldump -user -p copperminedb > /backup/copperminedb.sql     <-- Is that acceptable?
I would copy that to a usb drive and restore it with:
mysqldump -user -p /usb/copperminedb < copperminedb.sql    <-- Is that acceptable ?

Are there any special switches I should use or that are recommended ?

On the new server I have created the the mysql user for the database with all the required permissions and functions.

At this stage I would install my backup copy of albums?

Now I would unzip and install coppermine? Should I copy any other files from my old server to the new one? config.inc.php? anycontent.php?

And then run update.php?

Thank you for your time with my questions.

Sincerely,
Brendhan

[Understudy]

Okay I have done the migration. I guess I can answer my own questions.

Hi ,

I have some question that have been addressed but I don't have a complete understanding of the issues.
So I will ask some questions to help me avoid some mistakes.

I have a coppermine gallery at http://www.brendhanhorne.com/coppermine_dir/index.php.

It is currently running on FreeBSD 6.3 with:
mysql-client-4.1.22 Multithreaded SQL database (client)
mysql-server-4.1.22 Multithreaded SQL database (server)
php4-mysql-4.4.8    The mysql shared extension for php
php4-4.4.8          PHP Scripting Language (Apache Module and CLI)
php4-gd-4.4.8       The gd shared extension for php
php4-mysql-4.4.8    The mysql shared extension for php
php4-pcre-4.4.8     The pcre shared extension for php
php4-xml-4.4.8      The xml shared extension for php

I have run out of disk space and will be moving it to a new server with the same address when done.
The new server is running FreeBSD 6.3 with:
mysql-client-5.0.51a Multithreaded SQL database (client)
mysql-server-5.0.51a Multithreaded SQL database (server)
php4-mysql-4.4.8    The mysql shared extension for php
php4-4.4.8          PHP Scripting Language (Apache Module and CLI)
php4-gd-4.4.8       The gd shared extension for php
php4-mysql-4.4.8    The mysql shared extension for php
php4-pcre-4.4.8     The pcre shared extension for php
php4-xml-4.4.8      The xml shared extension for php

The Version of coppermine on the first server is 1.4.16. I will use the same version on the second. These servers are run by myself.

I have read http://coppermine-gallery.net/demo/cpg14x/docs/faq.htm#moveGallery.

And now for my questions.
In reading about the migration of dbs from Mysql 4.1 to 5.0 frequent comments on changing the default encoding from latin 1 to utf-8 are made.

Should I make this language encoding change to the db I use for my coppermine gallery?
If yes , should I change tables, rows, and columns?

There was no need to make this change. it worked fine without making these changes.

I am not using phpadmin(no room on disk). I was planning on using a command line mysql dump.
In new server create database name:
mysql > copperminedb
In old server:
mysqldump -user -p copperminedb > /backup/copperminedb.sql     <-- Is that acceptable?

I would copy that to a usb drive and restore it with:
mysqldump -user -p /usb/copperminedb < copperminedb.sql    <-- Is that acceptable ?

This worked fine.

Are there any special switches I should use or that are recommended ?

None are needed.

On the new server I have created the the mysql user for the database with all the required permissions and functions.

At this stage I would install my backup copy of albums?

Now I would unzip and install coppermine? Should I copy any other files from my old server to the new one? config.inc.php? anycontent.php?

And then run update.php?

Thank you for your time with my questions.

Sincerely,
Brendhan

On the old server I had to backup albums folder.
I also backed up anycontent.php and the include/config.inc.php. Just like you were doing an upgrade.

On the new server.
Create the database of the same name as the old one.
Create the same user and password.
Grant the rights of the user to the database.
Use mysqldump to upload the database as mentioned above.
Use ftp to upload the albums folder.
Use ftp to upload the same version of coppermine.
Check folder permissions.
Upload the anycontent.php and include/config.inc.php from that you saved from the old server.
Then run http://foo.com/coppermine/update.php

That is how it worked for me. You results may vary.

Sincerely,
Brendhan