Moving the database Moving the database
 

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

Main Menu

Moving the database

Started by volodomd, September 09, 2004, 03:43:33 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

volodomd

Hello all,

I'd like to move a 1.3.2 database from one database to another, but the current database has many other tables as well, so could someone please post a list of all tables that this version requires? If I understand correctly, I just have to move the tables and then update the settings in the galery to reflect the new database name - correct?  ??? Or, please give an exact procedure on how to move from one database to another.

Thanks in advance!

  Dennis
MCP, MCSD
Software for animal shelters - http://www.smartpethealth.com

Joachim Müller

you will have to make a dump of the tables that have the prefix you chose during coppermine install, e.g. "cpg132_". The exact names can be found when looking into the file sql/schema.sql in your coppermine folder (using a plain text editor). To be sure, you should always make a full backup first, then a backup (or rather: a dump) of the tables you actually want to move.

Joachim