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
Solved

Moving users to a new Moodle Server

Posted on 2011-03-01
6
568 Views
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 .
0
Comment
Question by:weegiraffe
  • 3
  • 3
6 Comments
 
LVL 10

Accepted Solution

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

Expert Comment

by:NetExpert-Warszawa
ID: 35014578
... starting with mdl_user (mdl_user itself is the most important :) )
0
 

Author Comment

by:weegiraffe
ID: 35033316
Should this be copy the tables, copy the records from the table. I want to ensure that existing records remain in tact
0
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
LVL 10

Expert Comment

by:NetExpert-Warszawa
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

or
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.
0
 

Author Comment

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

Author Closing Comment

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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Since I am currently running into this issue right now as I type this, I though I would share my experiences with moving a ModX Revolution site from one server to another.  It is not an easy task, but can be accomplished rather easily. The first …
In this blog, I will share you some basic tips for content marketing and to rank your website on Google.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) 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…

856 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