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