Moving users to a new Moodle Server

Posted on 2011-03-01
Last Modified: 2012-05-11
How would I move users accounts, complete with password from one moodle instance to another. I have full admin access to both moodle and the mySQL backed database which is based on shared web hosting .
Question by:weegiraffe
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
LVL 10

Accepted Solution

NetExpert-Warszawa earned 500 total points
ID: 35014574
Copy all SQL tables with names starting with mdl_user_
LVL 10

Expert Comment

ID: 35014578
... starting with mdl_user (mdl_user itself is the most important :) )

Author Comment

ID: 35033316
Should this be copy the tables, copy the records from the table. I want to ensure that existing records remain in tact
Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

LVL 10

Expert Comment

ID: 35033866
It does not matter. You can:
delete the tables,
dump the old ones with a structure and data,

run the dump script on the new installation

delete all records from the tables,
dump the old ones with data only,
run the dump script on the new installation

Before you do anything, make a complete backup of both databases. Just to be able to revert.

Author Comment

ID: 35068348
Thanks, will a few days before I can attempt this.

Author Closing Comment

ID: 35354250
Sorry for the delay in getting back to this, life gets busy sometimes

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
PHP on CMS across all themes in Magento 3 135
SLA's content for <Outsourcing contractors 3 155
YouTube parental control 2 138
Dynamic content on SharePoint 2013 13 119
Read about how to choose the best possible content marketing agency to suit your needs. Content marketing has become an integral part of running a successful tech business, so it is wise to be informed.
Knowledge base software has turned out to be a quite reliable method for storing information, promoting collaborative work and for sharing valuable input and solutions.However, some organizations are trying to develop a knowledge base that works wit…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
In an interesting question ( here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question