Zikula Community

• g.c.
  
  

  • Rank: Registered User
  • Registered: Dec 23, 2009
  • Last visit: Mar 09, 2010
  • Posts: 43

  Posted: Dec 23, 2009 - 09:54 AM

  Hello,
  
  I have used the Search function but found no similar question.
  I have a new Zikula 1.2 site up, and would like to "manually" migrate the users from the Postbuke .764 database to the new zikula 1.2 database. I'm thinking of these steps:
  -backup the Zikula DB
  -assess wich PN .764 tables contain the user data
  -use phpMyAdmin to generate a backup of those tables to SQL
  -use a search and replace to change the table prefix
  -use phpMyAdmin to put these tables into the Zikula 1.2 database.
  
  Some questions:
  
  Is this feasible at all?
  Any special considerations about the admin account?
  Will the users passwords stay the same (can they logon using their PN .764 passwords after this?)
  
  For many reasons I would like to take this approach instead of using the provided upgrade script. One reason being: The site is completely changed, and things like categories and group permissions and such I would like to start from scratch with.
  
  Thanks, GC

  • 
  •  
• Teb
  
  

  • Rank: Team Member
  • Registered: Feb 27, 2005
  • Last visit: Apr 12, 2010
  • Posts: 665

  Posted: Dec 23, 2009 - 01:12 PM

  This will not work, as the structure of the users table and it's data is different. The migration distribution takes care of this.
  
  You could try something else. This requires some time and is not guaranteed to work, so depending on the importance you could give it a go. This is from the top of my head:
  

  • backup your .764 DB and import it on a separate machine / database / host / whatever environment you can create for yourself.
    
  • download a clean migration distribution for 1.1.2
    
  • in that clean unpacked distribution:
    • change the config/config.php to match your dbuname / dbpass / dbname of that backupped .764db
      
    • change the config/config.php to read $...['installed'] = 1
    
    
  • read the online migration doc…764 -> Zikula 1.1.2
    
  • migrate the database to zikula-1.1.2 compatible version

  
  
  You should end up with a running core of the migrated database. Then figuring out what tables contain the user data is the next step... Backing Up and importing those have a bigger chance of success. Needless to say, you should test it first on a copy of your current 1.2 site...
  
  I remember that the passwords stay the same, and their storage method gets converted as users login to the new zikula site for the first time, from an old md5 hash to a new sha* hash. However, not sure if a separate config variable is needed for this.
  
  Good luck.
  
  --
  -- Teb
  -- Dutch Zikula Community
  
  Support questions in a Personal Message will be ignored. Use the forums at all times!

  • 
  •  
•  
•  

Users on-line

• rgasch

This list is based on users active over the last 60 minutes.